Gridview Problem

Question

I am fetching data in gridview from one table and how can i save it in another table as it is whole data of gridview on single button click

Sam Hobbs · Answer

If you want to do it the way that experienced developers would do it then you would have a DataTable bound to the GridView and then you would copy the data from the DataTable to another DataTable. You do not have to access the DataTable directly there are many ways to process data in DataTables. There are many articles in this web site about DataTables and such. So where does the data come from that is in the GridView?

Mayur Gujrathi · Answer

Try this protected void SaveButton(object sender EventArgs e) { SqlConnection conn = new SqlConnection(@ your_connection_string ); conn.Open(); foreach (GridViewRow gvr in GridView1.Rows) { string data1 = gvr.Cells[0].Text; //get data from BoundField in each row string data2 = ((Label)gvr.FindControl(Label1)).Text; //get data from control in TemplateField in each row SqlCommand cmd = new SqlCommand( insert_sql  conn); //generate insert sql using above data cmd.ExecuteNonQuery(); } conn.Close(); }