how to store multiple rows in a table from gridview

Question

hi  iam using asp.net2.0 with c# in my gridview iam at page load event iam displaying data from view. my 1st column in the gridview is checkbox when user selects the checkbox and iam using paging in gridview when user selects the checkbox and selects the rows from first page or from any page that have to be stored in database. in my database the table contains orderid int primary key autoincrement productname nvarchar price nvarchar quantity nvarchar total nvarchar when user selects the rows then in database how to store multiple rows in that table field can you give an example which helps me.

charan sekhar · Answer

my question is when user selects no of rows from 1st page and some records from 3rd page. then in database in one row how to store all selected records from gridview can you give example which helps me

jayant bramhankar · Answer

A dd a check box column to your gridview by writing fallowing code ItemTemplate > asp : CheckBox ID =chkSelect r unat =server /> ItemTemplate > then add this cs code protected void butapp_Click(object sender EventArgs e) { try { foreach (GridViewRow row in GridView3.Rows) { //get checkBox from gridview CheckBox chk = (CheckBox)row.FindControl(checkBoxName); if (chk.Checked) //checking checkboxes { //your logic goes here SqlConnection con=new SqlConnection(yourConnString); con.Open(); SqlCommand cmd=new SqlCommand(Insert into tableName values ('+row.Cells[].ToString()+''+row.Cells[1].ToString()+''+row.Cells[2].ToString()+''+row.Cells[3].ToString()+') con); cmd.ExecuteNonQuery(); con.Close(); } } } catch (Exception ex) { Response.Write(ex.Message); } } You can find a tutorial here http://csharpings.blogspot.com/2010/02/checkboxex-in-gridview.html Hope it helps