protected void ImageButton9_Click(object sender, ImageClickEventArgs e) { try { string SQL = ""; if (TextBox9.Text != "" && TextBox10.Text != "") { SQL = "Select * from tbl_subname where subname='" + TextBox9.Text.Trim() + "' and subid ='" + TextBox10.Text.Trim() + "'"; } else if (TextBox10.Text != "") { SQL = "Select * from tbl_subname where subid ='" + TextBox10.Text.Trim() + "'"; } SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); SqlDataAdapter AD = new SqlDataAdapter(cmd); DataSet DS = new DataSet(); AD.Fill(DS); GridView2.DataSource = DS; GridView2.DataBind(); TextBox9.Text = ""; TextBox10.Text = ""; } catch (Exception ex) { lblmsg.Visible = true; lblmsg.Text = "Error :" + ex.Message.Trim(); return; } }
protected void SaveAll() { string SQL = "INSERT INTO tbl_subname (fname,fid,subname,subid,code)" + " Values (@fname,@fid,@subname,@subid,@code)"; try { SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); cmd.Parameters.AddWithValue("@fname", SqlDbType.NVarChar).Value = DropDownList1.SelectedItem.Text.Trim(); cmd.Parameters.AddWithValue("@fid", SqlDbType.NVarChar).Value = lblAbrv.Text.Trim(); cmd.Parameters.AddWithValue("@subname", SqlDbType.NVarChar).Value = TextBox6.Text.Trim(); cmd.Parameters.AddWithValue("@subid", SqlDbType.NVarChar).Value = TextBox7.Text.Trim(); cmd.Parameters.AddWithValue("@code", SqlDbType.NVarChar).Value = TextBox8.Text.Trim(); cmd.ExecuteNonQuery(); con.Close(); cmd.Dispose(); CLS(); Loadgrd(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = "Error :" + ex.Message.Trim(); return; } }
/// <summary> /// Module to store data into sql server /// </summary> protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { try { string SQL = "INSERT INTO tbl_facility (statename,lga,facname,faclevel,techarea) VALUES (@statename,@lga,@facname,@faclevel,@techarea)"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); cmd.Parameters.Add("@statename", SqlDbType.NVarChar).Value = DrpState.SelectedItem.Text.Trim(); cmd.Parameters.Add("@lga", SqlDbType.NVarChar).Value = DrpLGA.SelectedItem.Text.Trim(); cmd.Parameters.Add("@facname", SqlDbType.NVarChar).Value = TextBox1.Text.Trim(); cmd.Parameters.Add("@faclevel", SqlDbType.NVarChar).Value = DrpFacname.SelectedItem.Text.Trim(); cmd.Parameters.Add("@factype", SqlDbType.NVarChar).Value = Drpfactype.SelectedItem.Text.Trim(); cmd.Parameters.Add("@techarea", SqlDbType.NVarChar).Value = DrpTechArea.SelectedItem.Text.Trim(); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); Fillgrd(); CLS(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = " " + ex.Message.ToString().Trim(); } }
public static int ProgramTable(string theTable) { try { SqlConnection SC = new SqlConnection(ConnectAll.ConnectMe()); string cmdText = @"IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='" + theTable + "') SELECT 1 ELSE SELECT 0"; SC.Open(); SqlCommand DateCheck = new SqlCommand(cmdText, SC); int x = Convert.ToInt32(DateCheck.ExecuteScalar()); if (x == 1) { return(1); } else { return(0); } SC.Close(); } catch (Exception ex) { return(-1); } }//===end
protected void LoaDGrid() { try { string mFile1 = drpProgramArea.SelectedItem.Text.Trim(); string mFile = string.Empty; DataTable dt = new DataTable(); GetThematic(mFile1, out mFile); string SQL = " SELECT * FROM tbl_defn where grouptype ='" + mFile.Trim() + "'"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQL, cn); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { webMessage.Show("ERROR :" + ex.Message); return; } }
protected void Button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); DataSet reportData = new DataSet(); string filenames = FileUpload1.FileName.ToString(); //Server.MapPath(string.Format("~/{0}/", "XML")) string Filename = Server.MapPath(string.Format("~/{0}/", "XML") + filenames); reportData.ReadXml(Filename); con.Open(); DataTable dt2 = new DataTable(); foreach (DataTable dt in reportData.Tables) { SqlBulkCopy sbc = new SqlBulkCopy(con); sbc.DestinationTableName = "tbl_ART"; foreach (DataColumn dc in dt.Columns) { sbc.ColumnMappings.Add(dc.ColumnName, dc.ColumnName); }// Second Foreach //dt2 = dt.DefaultView.ToTable(true); //sbc.WriteToServer(dt.DefaultView.ToTable(true)); dt2 = RemoveDuplicatesRecords(dt); sbc.WriteToServer(dt2); }// First Foreach con.Close(); }
protected void LoadDrp() { try { string SQL = "Select * from tbl_grpname order by fname asc"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); SqlDataReader r = cmd.ExecuteReader(); DropDownList1.Items.Clear(); DropDownList1.Items.Add(""); while (r.Read()) { DropDownList1.Items.Add(r["fname"].ToString()); } r.Dispose(); cmd.Dispose(); con.Close(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = "Error :" + ex.Message.Trim(); return; } }
private void LoadData() { string SQl = "Select * from tbl_grpname order by abrv asc"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQl, cn); SqlDataReader r = cmd.ExecuteReader(); try { drpProgram.ClearSelection(); drpProgram.Items.Clear(); drpProgram.Items.Add(""); while (r.Read()) { drpProgram.Items.Add(r["fname"].ToString()); } } catch (Exception e) { webMessage.Show("Error :" + e.Message.ToString()); return; } }
protected void FillState() { string SQl = "Select Distinct statename from tbl_States order by statename asc"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQl, cn); SqlDataReader r = cmd.ExecuteReader(); try { drpStates.ClearSelection(); drpStates.Items.Clear(); drpStates.Items.Add(""); while (r.Read()) { drpStates.Items.Add(r["statename"].ToString()); } } catch (Exception e) { Response.Write("<script language=javascript>alert('" + e.Message.ToString() + "' );</script>"); return; } }
protected void drpStates_SelectedIndexChanged(object sender, EventArgs e) { string SQL, SQL1 = ""; if (drpStates.SelectedItem.Text.Trim() == "Ebonyi") { SQL1 = "Abakaliki"; SQL = "SELECT * from tbl_states where capitals ='" + SQL1 + "' order by lga asc"; } else { SQL = "SELECT * from tbl_states where statename ='" + drpStates.SelectedItem.Text.Trim() + "' order by lga asc"; } SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQL, cn); SqlDataReader r = cmd.ExecuteReader(); try { drpLGA.ClearSelection(); drpLGA.Items.Clear(); drpLGA.Items.Add(""); while (r.Read()) { drpLGA.Items.Add(r["lga"].ToString()); } } catch (Exception ex) { webMessage.Show("Error Message : " + ex.Message.ToString()); return; } }
protected void drpProgram_SelectedIndexChanged(object sender, EventArgs e) { try { string mFile1 = drpProgram.SelectedItem.Text.Trim(); string mFile = string.Empty; GetThematic(mFile1, out mFile); string SQL = "SELECT * from tbl_TargetDefine where grouptype ='" + mFile + "'"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQL, cn); SqlDataAdapter DA = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); DA.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { webMessage.Show("Error :" + ex.Message.ToString()); return; } }
}//=== End of EditMe() Method protected void ImageButton4_Click(object sender, ImageClickEventArgs e) { try { string SQL = "Delete tbl_facility where facname=@facname"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); cmd.Parameters.Add("@statename", SqlDbType.NVarChar).Value = DrpState.Text.Trim(); cmd.Parameters.Add("@lga", SqlDbType.NVarChar).Value = DrpLGA.Text.Trim(); cmd.Parameters.Add("@facname", SqlDbType.NVarChar).Value = TextBox1.Text.Trim(); cmd.Parameters.Add("@faclevel", SqlDbType.NVarChar).Value = DrpFacname.Text.Trim(); cmd.Parameters.Add("@factype", SqlDbType.NVarChar).Value = Drpfactype.Text.Trim(); cmd.Parameters.Add("@techarea", SqlDbType.NVarChar).Value = DrpTechArea.Text.Trim(); cmd.ExecuteNonQuery(); Fillgrd(); HideText(); CLS(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = "Error :" + ex.Message; return; } }
}///===== End void FillstateDp() { try { string sqlstate = "Select distinct statename from tbl_state order by statename asc"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(sqlstate, con); SqlDataReader r = cmd.ExecuteReader(); DrpState.Items.Clear(); DrpState.Items.Add(""); drpstate2.Items.Clear(); drpstate2.Items.Add(""); while (r.Read()) { DrpState.Items.Add(r["statename"].ToString()); drpstate2.Items.Add(r["statename"].ToString()); } DrpState.DataBind(); drpstate2.DataBind(); con.Close(); r.Dispose(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = " " + ex.Message.ToString().Trim(); } }
protected void FillThematic() { string SQl = "Select * from tbl_grpname order by abrv asc"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd = new SqlCommand(SQl, cn); SqlDataReader r = cmd.ExecuteReader(); try { drpProgramArea.ClearSelection(); drpProgramArea.Items.Clear(); drpProgramArea.Items.Add(""); while (r.Read()) { drpProgramArea.Items.Add(r["fname"].ToString()); } } catch (Exception e) { Response.Write("<script language=javascript>alert('" + e.Message.ToString() + "' );</script>"); return; } }
}//=== End of EditMe() Method protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { string PO = Session["fname"].ToString().Trim(); string SQL = "Update tbl_grpname set fid=@fid,fname=@fname where fname='" + PO + "'"; try { SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); cmd.Parameters.AddWithValue("@fid", SqlDbType.NVarChar).Value = TextBox2.Text.Trim(); cmd.Parameters.AddWithValue("@fname", SqlDbType.NVarChar).Value = TextBox1.Text.Trim(); cmd.ExecuteNonQuery(); CLS(); Loadgrd(); con.Close(); cmd.Dispose(); PO = null; } catch (Exception ex) { lblerr2.Visible = true; lblerr2.Text = "Error :" + ex.Message; return; } }
///======== protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { string SQL = ""; try { if (TextBox1.Text != "" && TextBox2.Text != "") { SQL = "Delete tbl_grpname where fname ='" + TextBox1.Text.Trim() + "' and fid='" + TextBox2.Text.Trim() + "'"; } else if (TextBox2.Text != "") { SQL = "Delete tbl_grpname where fid ='" + TextBox2.Text.Trim() + "'"; } SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); cmd.Parameters.AddWithValue("@fname", SqlDbType.NVarChar).Value = TextBox1.Text.Trim(); cmd.Parameters.AddWithValue("@fid", SqlDbType.NVarChar).Value = TextBox2.Text.Trim(); cmd.ExecuteNonQuery(); con.Close(); Loadgrd(); CLS(); ImageButton2.Visible = false; } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = "Error " + ex.Message.ToString().Trim(); return; } }
//======== End protected void EditMe(string SuppID) { if (SuppID == null) { return; } string KK = "Select * from tbl_facility Where num='" + Convert.ToString(SuppID) + "'"; using (SqlConnection p = new SqlConnection(ConnectAll.ConnectMe())) { p.Open(); SqlCommand Cmd = new SqlCommand(KK, p); try { //DataRow dr = ConnectAll.GetDataRow(KK); // ===== Get the datarow from a generic method in a classs SqlDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { if (dr != null) { TextBox3.Visible = true; TextBox4.Visible = true; TextBox5.Visible = true; TextBox6.Visible = true; TextBox7.Visible = true; //DrpState.Items.Clear(); //ListItem newItem = new ListItem(); //newItem.Text = dr["statename"].ToString(); //DrpState.Text = dr["statename"].ToString(); TextBox3.Text = dr["statename"].ToString(); TextBox4.Text = dr["lga"].ToString(); TextBox1.Text = dr["facname"].ToString(); TextBox5.Text = dr["faclevel"].ToString(); TextBox6.Text = dr["factype"].ToString(); TextBox7.Text = dr["techarea"].ToString(); } } ImageButton2.Visible = true; TabContainer1.ActiveTabIndex = 0; } catch (Exception ex) { lblerr2.Visible = true; lblerr2.Text = "Error :" + ex.Message; return; } finally { p.Close(); Cmd.Dispose(); //MultiView1.ActiveViewIndex = 0 } } }//=== End of EditMe() Method
protected DataTable GetDatafromDatabase() { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(ConnectAll.ConnectMe())) { con.Open(); SqlCommand cmd = new SqlCommand("Select * from VW_htc", con); // "Select TOP 10 UserName,LastName,Location FROM UserInformation", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); } return(dt); }
protected void EditMe(string SuppID) { if (SuppID == null) { return; } Session["fname"] = null; string KK = "Select * from tbl_subname Where num='" + Convert.ToString(SuppID) + "'"; using (SqlConnection p = new SqlConnection(ConnectAll.ConnectMe())) { p.Open(); SqlCommand Cmd = new SqlCommand(KK, p); try { DataRow dr = ConnectAll.GetDataRow(KK); // ===== Get the datarow from a generic method in a classs if (dr != null) { DropDownList1.Text = dr["fname"].ToString(); lblAbrv.Text = dr["fid"].ToString(); TextBox6.Text = dr["subname"].ToString(); TextBox7.Text = dr["subid"].ToString(); TextBox8.Text = dr["code"].ToString(); Session["fname"] = dr["fname"].ToString(); CLS2(); } ImageButton6.Visible = true; ImageButton8.Visible = true; TabContainer1.ActiveTabIndex = 0; GridView2.DataSource = null; GridView2.DataBind(); } catch (Exception ex) { lblmsg.Visible = true; lblmsg.Text = " " + ex.Message.ToString().Trim(); return; } finally { p.Close(); Cmd.Dispose(); //MultiView1.ActiveViewIndex = 0 } } }//=== End of EditMe() Method
}//===== End protected void LoadGrd() { string SQL = "SELECT * FROM tbl_DataElems"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); }
//IF TABLE tbl_TempReport IF FOUND DROP IT AND RECREATE IT private void LoadThematic() { string m_code; string m_descrip; object m_value; string m_grouptype; DataTable dt = GetDatafromDatabase(); // My own Testing Code foreach (DataColumn dc in dt.Columns) { foreach (DataRow dr in dt.Rows) { string SQL = "Select * from tbl_defn where code='" + dc.ToString().Trim() + "'"; // and grouptype = 'htc'"; using (SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe())) { if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlCommand cmd = new SqlCommand(SQL, cn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { m_code = dc.ToString(); m_descrip = rd["description"].ToString(); m_value = dr.ToString(); m_grouptype = rd["grouptype"].ToString(); rd.Close(); //pass the code and description and value to the reporting table string sqlIN = "INSERT INTO tbl_TempReport (code,descrip,value,grouptype) VALUES(@code,@descrip,@value,@grouptype)"; if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlCommand cmdIN = new SqlCommand(sqlIN, cn); cmdIN.Parameters.AddWithValue("@code", SqlDbType.NVarChar).Value = m_code; cmdIN.Parameters.AddWithValue("@descrip", SqlDbType.NVarChar).Value = m_descrip; cmdIN.Parameters.AddWithValue("@value", SqlDbType.Int).Value = m_value; cmdIN.Parameters.AddWithValue("@grouptype", SqlDbType.NVarChar).Value = m_grouptype; cmdIN.ExecuteNonQuery(); // names = rd["description"].ToString(); } } /// ChkLoadData(dr, dc.ColumnName); } } }
protected void Fillgrd() { try { string SQL = "Select * from tbl_facility"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(SQL, con); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(' Facility " + ex.Message.ToString() + "';", true); return; } }
private void TableCreate() { try { Object I; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); SqlCommand cmd; if (FindTable.ProgramTable("tbl_TargetDefine") == 1) { return; } else { string sqlCreate1 = "CREATE TABLE tbl_TargetDefine ( ID int IDENTITY(1,1) NOT NULL,"; sqlCreate1 += "Grouptype Nvarchar(50) Null, Code Nvarchar(50) Null, Description Nvarchar(2000) Null)ON [PRIMARY] "; if (cn.State == ConnectionState.Closed) { cn.Open(); } cmd = new SqlCommand(sqlCreate1, cn); I = cmd.ExecuteScalar(); cmd.Dispose(); cn.Close(); } if (FindTable.ProgramTable("tbl_TargetAssin") == 1) { return; } else { string sqlCreate2 = "CREATE TABLE tbl_TargetAssin ( ID int IDENTITY(1,1) NOT NULL,"; sqlCreate2 += "Grouptype Nvarchar(50) Null, Code Nvarchar(50) Null, Description Nvarchar(2000) Null,"; sqlCreate2 += "mYears nvarchar(20) Null, Months Nvarchar(20) Null, TargetValue Int)ON [PRIMARY] "; if (cn.State == ConnectionState.Closed) { cn.Open(); } cmd = new SqlCommand(sqlCreate2, cn); I = cmd.ExecuteScalar(); cmd.Dispose(); cn.Close(); } }catch (Exception ex) { webMessage.Show("Error Creating Report Table :" + ex.Message); } }
protected void CreateXML(string TblName) { #region how to create and delete directory //string directoryPath = Server.MapPath(string.Format("~/{0}/", txtFolderName.Text.Trim())); //if (!Directory.Exists(directoryPath)) //{ // Directory.CreateDirectory(directoryPath); //} //else //{ // ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Directory already exists.');", true); //} //============================================================================================= //string directoryPath = Server.MapPath(string.Format("~/{0}/", txtFolderName.Text.Trim())); //if (Directory.Exists(directoryPath)) //{ // Directory.Delete(directoryPath); //} //else //{ // ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Directory does not exist.');", true); //} #endregion try { string mName = TextBox15.Text.Trim() + "_" + TblName.Trim() + "_" + ComboBox1.SelectedItem.Text + "_" + DateTime.Now.Year.ToString(); SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); string strSQL = "Select * from " + TblName.Trim(); SqlDataAdapter dt = new SqlDataAdapter(strSQL, con); DataSet ds = new DataSet(); dt.Fill(ds, TblName.Trim()); ds.WriteXml(@"C:\PPMExpress\XML\" + mName + ".xml"); } catch (Exception ex) { Response.Write("<script language=javascript>alert('" + TblName.Trim() + " " + ex.Message.ToString() + "');</script>"); return; } }
private void CREATTable() { try { string SQLT = "CREATE TABLE tbl_TempReport ( GROUPTYPE NVARCHAR(50),code NVARCHAR(50), DESCRIP NVARCHAR(MAX),VALUEP NVARCHAR(50))"; int done = 0; using (SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe())) { cn.Open(); SqlCommand cmd = new SqlCommand(SQLT, cn); done = cmd.ExecuteNonQuery(); } }catch (Exception ex) { webMessage.Show("Error check for temp table :" + ex.Message); } }
public static void InsertTempReport(string GroupType, string Code, string Desc) { var Dat = new DataTable(); using (SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe())) { cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_InsertTempReport"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = cn; cmd.Parameters.AddWithValue("@grouptype", SqlDbType.NVarChar).Value = GroupType; cmd.Parameters.AddWithValue("@code", SqlDbType.NVarChar).Value = Code; cmd.Parameters.AddWithValue("@descrip", SqlDbType.NVarChar).Value = Desc; cmd.ExecuteNonQuery(); } }
protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { try { string sql = "DELETE tbl_States where statename ='" + TextBox1.Text.Trim() + "'"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); } catch (Exception ex) { LblErr.Visible = true; LblErr.Text = "Can not Erase this document.....: " + ex.Message.ToString().Trim(); } }
private void DropTable() { try { string SQLT = "drop table tbl_TempReport"; int done = 0; using (SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe())) { cn.Open(); SqlCommand cmd = new SqlCommand(SQLT, cn); done = cmd.ExecuteNonQuery(); } } catch (Exception ex) { webMessage.Show("Error check for temp table :" + ex.Message); } }
public static DataTable SearchTableDefine(string mFile) { var Dat = new DataTable(); using (SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe())) { cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_SearchTableDefine"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = cn; cmd.Parameters.AddWithValue("@mFile", SqlDbType.NVarChar).Value = mFile; var sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(Dat); return(Dat); } }
protected void Button1_Click(object sender, EventArgs e) { try { //==== Create SQL Table for storage TableCreate(); foreach (GridViewRow row in GridView1.Rows) { //===== Accessing the checkbox CheckBox cb = (CheckBox)row.FindControl("ChkSelect"); if (cb != null && cb.Checked) { int ID = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value); //== Search for the records and store in datatbase string SQLP = "SELECT * FROM tbl_defn where ID ='" + Convert.ToString(ID) + "'"; SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe()); cn.Open(); SqlCommand cmd1 = new SqlCommand(SQLP, cn); SqlDataReader r = cmd1.ExecuteReader(); while (r.Read()) { string SQL = "INSERT INTO tbl_TargetDefine (grouptype,code,description) VALUES(@grouptype,@code,@description)"; if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlCommand cmd = new SqlCommand(SQL, cn); cmd.Parameters.AddWithValue("@code", SqlDbType.NVarChar).Value = r["code"].ToString(); cmd.Parameters.AddWithValue("@description", SqlDbType.NVarChar).Value = r["description"].ToString(); cmd.Parameters.AddWithValue("@grouptype", SqlDbType.NVarChar).Value = r["grouptype"].ToString(); cmd.ExecuteReader(); } } } } catch (Exception ex) { webMessage.Show("ERROR :" + ex.Message.ToString()); return; } }