Deleted row information cannot be accessed thru the row

Ramco Ramco

I am getting this error after dt.delete()

foreach (DataRow row in dt.Rows)
{
    if (ND == (dtCount - 1) - init && (Convert.ToInt32(row[3].ToString().Trim()) < (Convert.ToInt32(HRpl) - 1)))
    {
        row.Delete();
    }
    if (ND == (dtCount - 1) - init && (Convert.ToInt32(row[3].ToString().Trim()) > (Convert.ToInt32(HRpl))))
    {
        row.Delete();
    }
}

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago

Accepted answer

better use DataSet

int i=0;
foreach (DataRow row in dt.Rows)
{
    if (ND == (dtCount - 1) - init && (Convert.ToInt32(row[3].ToString().Trim()) < (Convert.ToInt32(HRpl) - 1)))
    {
     ds.Tables[0].Rows[i].Delete();
     ds.AcceptChanges();
    }
    if (ND == (dtCount - 1) - init && (Convert.ToInt32(row[3].ToString().Trim()) > (Convert.ToInt32(HRpl))))
    {
        ds.Tables[0].Rows[i].Delete();
        ds.AcceptChanges();
    }
    i++;
}