Hello,

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

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