deleting a row in data gridview

Question

i am not able to delete a row in grid view tool in asp.net error is Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Lakshmanan Sethu · Answer

Please debug your code and try to see what's the sid you are getting? I guess you should be deleting based on your ID not SID?

vinit · Answer

protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { try { SqlCommand cmd = new SqlCommand(delete from student where sid=@sid con); cmd.Parameters.Add(@sid SqlDbType.BigInt).Value = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); con.Open(); int i = cmd.ExecuteNonQuery(); if (i > 0) { Response.Write( alert('row is deleted') showdata(); } }

dinesh vasamshetty · Answer

please paste your source code