how to insert the data from the grid view using asp.net

Question

how to insert the data from the grid view

selvi subramanian · Answer

this is the solution private void Save() { string conString = ConfigurationManager.AppSettings["s"].ToString(); using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("insert into presentdays(Id,Date,Name,Status,Section,totaldays,present) values(@Id,@Date,@Name,@Status,@Section,@totaldays,@present)", con)) { con.Open(); cmd.Parameters.AddWithValue("@Id", GridView1.Rows[0].Cells[0].Text); cmd.Parameters.AddWithValue("@Date", GridView1.Rows[0].Cells[1].Text); cmd.Parameters.AddWithValue("@Name", GridView1.Rows[0].Cells[2].Text); cmd.Parameters.AddWithValue("@Status", GridView1.Rows[0].Cells[3].Text); cmd.Parameters.AddWithValue("@Section", GridView1.Rows[0].Cells[4].Text); cmd.Parameters.AddWithValue("@totaldays", TextBox2.Text); cmd.Parameters.AddWithValue("@present", lblStatusCount.Text); cmd.ExecuteNonQuery(); con.Close(); } } } and call the method where u need

Bhabani Prasad · Answer

Go through Below Link Its Really Helpful http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

Munesh Sharma · Answer

go on this link

selvi subramanian · Answer

thanks Nilesh in that foreach is the problem for me.because its a loop so it is inserted so many times.please check it

Nilesh Avhad · Answer

Refer, http://www.c-sharpcorner.com/Blogs/10923/ Thanks, Nilesh

selvi subramanian · Answer

i have to insert the data that is shown in the gridview

Lakshmanan Sethu Sankaranarayan · Answer

hi, chk this http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html