I am trying to delete one or more items from the datagrid using Delete button. But I receive the following error:
InvalidOperation Exception was handled by user code Collection was modified; enumeration operation may not execute.
I have written the code as follows:
protected void btndelete_Click(object sender, EventArgs e) {
foreach (DataGridItem dgi in grdCorpAcc.Items) { CheckBox checkall; int i = 0; int id;
checkall = (CheckBox)dgi.FindControl("chkSelect");
id = (int)grdCorpAcc.DataKeys[dgi.ItemIndex];
if (checkall.Checked == true) { string delrecord = "delete Account where Id=" +id;
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(delrecord, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close(); } grdCorpAcc.CurrentPageIndex = 0; grdCorpAcc.EditItemIndex = -1; BindDataGrid(); }
}
Please help ............