• Delete Rows from DataTable And reindex collection

When you loop through a DataTable object in order to find the match records and delete the rows, it can generally be achieved as below.

foreach (DataRow dr in oDataTable.Rows)
{
   if(dr["Name"]) == "ChristopherThant")
   dr.Delete();
}

However, after you've called the Delete() method from DataRow object, the index in DataRow collection was changed and it makes your looping breaks and thrown an error.

Collection was modified; enumeration operation might not execute.

Some people suggest to commit the DELETE transaction out of the loop by calling AcceptChanges() method.

foreach (DataRow dr in oDataTable.Rows)
{
   if(dr["Name"]) == "ChristopherThant")
   dr.Delete();
}
oDataTable.AcceptChanges();

After I have tried all the possible methods, I finally come up with the decent solution which I've been using whenever I encounter into this situation.

Basically, you will need a method to repopulate the collection index of DataRow.

//With the DataRow[] ToArray(DataRowCollection collection) create a collection-object of datarows and so make sure that there won't be any errors
public static DataRow[] ToArray(DataRowCollection collection)
{
   DataRow[] result = new DataRow[collection.Count];
   collection.CopyTo(result, 0);
   return result;
}

And just apply that method to your DataRow Collection.
foreach (DataRow dr in ToArray(oDataTable.Rows))
{
   if(dr["Name"]) == "ChristopherThant")
   dr.Delete();
}