How to add all the row data of gridview to database?

Question

Hi all, I am adding rows to a gridview at button click... User can add as many records to the gridview .... Now i want to add all the rows data to database in one go.. How can i do this please help

Prabhu Raja · Answer

Try this. In Button_Click() Event() SqlCommand cmd ; SqlConnection oConn = new SqlConnection(" Your Connection String "); oConn.Open(); cmd.Connection = oConn; cmd.CommandType = CommandType.Text; int n=0 ; //get how many rows are added at end of insert foreach (DataRow dr in GridView1.Rows) { cmd = new SqlCommand("Insert Into Tablename values (@Value1, @Value2)"); //Insert Query //Give Your Column name or use as dr.rows.cell[ index ] cmd.parameter["@Value1"].value = dr["GridViewColumnName"]; cmd.parameter["@Value2"].value = dr["GridViewColumnName"]; n += cmd.ExecuteNonQuery(); cmd.parameter.clear(); } oConn.Close(); --------------------------------------------------------------------------------------------- Thank You

Mayur Gujrathi · Answer

Dim dgqty As New TextBox Dim hdpdtcid As New TextBox For Each dg As GridViewRow In grdDematChk.Rows dgqty = dg.FindControl("TextBox1") hdpdtcid = dg.FindControl("TextBox2") //write insert statement here you can get text as dgqty .Text End If Next

Satish Bhat · Answer

Ref this link

How to add all the row data of gridview to database?

Answers (3)