how to delete a row in gridview

Question

//int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //if (con.State == ConnectionState.Closed) //{ // con.Open(); //} //SqlCommand cmd = new SqlCommand(Delete from gridview where id=' + id + ' con); //cmd.ExecuteNonQuery(); //con.Close(); //GridView1.DataBind(); //display(); how can i delete a row in using row deleting event . i was used this code but its not working in the table i use identity to generate id

Lakshmanan Sethu · Answer

Hi Nitin p:GridView ID=GridView1 runat=server AutoGenerateColumns=False AutoGenerateEditButton=True onrowcancelingedit=GridView1_RowCancelingEdit onrowediting=GridView1_RowEditing onrowupdating=GridView1_RowUpdating onselectedindexchanged=GridView1_SelectedIndexChanged AutoGenerateDeleteButton=True onrowdeleting=GridView1_RowDeleting> Datakey is missed in your file.. Please add datakeynames=YourIDColumnName

Nitin Sharma · Answer

thank you very much Lakshmanan i was missing datakeynames  now my code is working thanku for ur support Dear selva thanku for ur code but now my code is working using datakeynames field

selva kumar · Answer

Try this.. protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; Label lblid = (Label)row.FindControl(lblid); int T_ID = Convert.ToInt32(lblid.Text); Con.Open(); Cmd = new SqlCommand(Delete From Tablename Where T_ID= + T_ID +  Con); Cmd.ExecuteNonQuery(); Con.Close(); GridView1.EditIndex = -1; gvbind(); }

Nitin Sharma · Answer

now i m posting all the file which is help to understand the coding please check it and than advice me what i need to do

Nitin Sharma · Answer

yes it is id

Lakshmanan Sethu · Answer

Hi Nitin Please check whether you placed datakeys in your grid view definition and it should be id to make Kalai code to work.

Nitin Sharma · Answer

this code show erroe Index was out of range. Must be non-negative and less than the size of the collection.

Kalai · Answer

Try this code. protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand(Delete from gridview where id=' + id + ' con); cmd.ExecuteNonQuery(); con.Close(); GridView1.DataBind(); display(); }