rahulchd3112

 Profile Answers by rahulchd3112 Questions by rahulchd3112

• Dec 28th, 2008

 

You can't insert data in multiple table in one query but the other solution is below

first get data from gridview to a temp table (DataTable) as following:

{

 CheckBox cb;
  DataTable tb=new DataTable();
  tb.Columns.Add("eno", Type.GetType("System.Int32"));
  tb.Columns.Add("ename", Type.GetType("System.String"));
  tb.Columns.Add("eadd", Type.GetType("System.String"));
  tb.Columns.Add("esal", Type.GetType("System.Int32"));
  for (int i = 0; i < GridView1.Rows.Count; i++)
  {
  cb = ((CheckBox)(GridView1.Rows[i].FindControl("cb")));
  if (cb.Checked)
  {
  DataRow r = tb.NewRow();
  r[0] = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text);
  r[1] = GridView1.Rows[i].Cells[2].Text;
  r[2] = GridView1.Rows[i].Cells[3].Text;
  r[3] = Convert.ToInt32(GridView1.Rows[i].Cells[4].Text);
  tb.Rows.Add(r);
  }

//Now here write the code for inserting data in multipal tables, you have to write seperate insert command for each table

SqlConnection con = new SqlConnectio("Server=tiger;database=database1;uid=sa");
con.Open();

for(int j=0;j

{

//write the code for inserting data in tables
 }