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.