I'm using DataSet that fills data from a filestore (filenames, size, a
DelMe bool coln, etc). Now I want to delete rows which have DelMe set
to true. Since I'm using a DataAdapter here, which would be the best
way to delete rows that have DelMe=true;

Currently I do this.
DataRow[] changes = parentTable.Select(null, null,
DataViewRowState.ModifiedCurrent);
Then I loop and set each to row.Delete() and finally call
AcceptChanges() to remove them from the table.

Is there a more efficient way to select and delete. ?

thanks
Sunit

IndexOutOfRangeException - Index was outside the bounds of the array.
SqlDataReader Function From a VB6 refugee
Empty Parameter
Store procedure vs Direct statement ???
UniqueIdentifier Sql Data and Parameters