Gridview in asp.net 2.0

[Milind Panchal]

Hi, I am working on gridview. while deleting the record i am getting the error as Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index my code is protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int empid=0; empid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex]); cmd = new SqlCommand("delete employee where empid='" + empid + "'", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } please give me what is the syntax for it. can any one help me urgently thanks!

[nandhububbly]

Hi change ur rowindex value or empid value after that u will get other wise reply to me i will give code for u .. Reg Nantha

[N a r e s h P a t e l]

Hi, Set e.EditEndex=-1 After deleting the row.

Naresh Patel

[Milind Panchal]

thanks your guidance.:rose: can u send me code please

[N a r e s h P a t e l]

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int empid=0; empid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex]); cmd = new SqlCommand("delete employee where empid='" + empid + "'", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); e.EditIndex=-1; }

Naresh Patel

[nandhububbly]

Hi try this ... protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int n = Convert.ToInt32(GridView1.DataKeys[e.RowIndex]); int empid=n-1; cmd = new SqlCommand("delete employee where empid='" + empid + "'", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } in case not working send full functionality about this grid view process

[N a r e s h P a t e l]

I am giving you only Idea, not implementation. Ok

Naresh Patel

[Milind Panchal]

very thank you Naresh Patel