UPDATE and DELETE from DataGridView Control

Question

How to Update & Delete a selected row from DataGridView Control ?

Ramjee · Answer

Hi Deepak, You just gothrough the below update and delete codings in C#. It will help you to get an idea in VB too. Update: mycon.Open(); GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; Label lbl = (Label)row.FindControl("lblid"); TextBox textdesignation = (TextBox)row.FindControl("textbox1"); SqlCommand cmd = new SqlCommand("update emp set designation='" +textdesignation.Text + "' where empid=" + lbl.Text + "", mycon); GridView1.EditIndex = -1; cmd.ExecuteNonQuery(); mycon.Close(); After the line mycon.close you just write the codings to view the gridview data. It will show the updated and also the whole data's on the grid. Here i just updated only one column(designation). you just try more than one in your project. Delete: mycon.Open(); GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; Label lbldel = (Label)row.FindControl("lblid"); SqlCommand cmd = new SqlCommand("delete from emp where empid=" + lbldel.Text + "", mycon); cmd.ExecuteNonQuery(); mycon.Close(); After the line mycon.close you just write the codings to view the gridview data. It will show the remaining data's on the grid.

UPDATE and DELETE from DataGridView Control

Answers (1)