Delete records from dataset. 1

[160473]

I have a table in a dataset. I need to delete several rows in that table. But if I do like this:

For Each row In newDataTable.Rows
If row(1) = 505050 Then
newDataTable.Rows(linenr).Delete()
End If
linenr = linenr + 1
Next

then the line count changes and give me the following error:
An unhandled exception of type 'System.InvalidOperationException' occurred in mscorlib.dll
Additional information: Collection was modified; enumeration operation may not execute.

Is there an alternative way of deleting rows in a dataset?
Like the SQL-way; 'DELETE FROM table WHERE ID=505050'

 

[chrissie1]

I would do it like this

dim intcounter as integer
dim inttemp as integer
intcounter = newdatatable.rows.count
inttemp = 0
do while intcounter > 0
  If newdatatable.rows(inttemp).item(1) = 505050 Then
    newDataTable.Rows(linenr).Delete()
  else
    inttemp += 1
  End If
  intcounter -= 1
loop

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[160473]

Thanks!!!
You are the star of .NET!!!