protected void btnDel_Click(object sender, EventArgs e)
{
try
{
con.ConnectionString = ConString;
con.Open();
foreach (GridViewRow row in grdvw.Rows)
{
//CheckBox cb = (CheckBox)row.FindControl("chkDel");
CheckBox cb = (CheckBox)grdvw.Rows[row.RowIndex].FindControl("chkDel");
if (cb.Checked)
{
//int id =Convert.ToInt32( grdvw.DataKeys[row.RowIndex]["Emp_no"].ToString);
int Emp_no = Convert.ToInt32(grdvw.DataKeys[row.RowIndex].Values[0].ToString());
cmd = new SqlCommand("Delete from employee where Emp_no=" + Emp_no, con);
cmd.ExecuteNonQuery();
con.Close();
BindData();
lblMsg.Text = "Selected Records Deleted";
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
I am getting an error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index "
and only single record is deleted
Thanks & Regards
Priti