How to delete a group of rows from a DataTable?

Hello,

I need to delete a group of rows from a DataTable based on a condition. Something like:

Code Block

string CRefeicao = "01", CFamiliaPrato = "02";

foreach (DataRow LinhaDetalhe in Detalhe.Rows)
{
string Crefeicao2 = LinhaDetalhe["CRefeicao"].ToString();
string CFAmiliaPrato2 = LinhaDetalhe["CFamiliaPrato"].ToString();

if (CRefeicao == Crefeicao2 & CFamiliaPrato == CFAmiliaPrato2)
{
LinhaDetalhe.Delete();
}
}

The problem is: if i have a DataTable with 2 Rows, and the first row fills the condition it will be deleted, then it will remain 1 row in the DataTable. In the 2nd passage of the ForEach loop i'll get an exception: "Colection has been modified. INumerate operation can not be executed.".

It makes sense: now there's no row nº2 to loop through, but how can i delete a group of DataTable.DataRows?
There's other way to do this?

Thank You,

Joaquim

How to delete a group of rows from a DataTable?

You can use google to search for other answers

More Threads