I'm using vb.net, but if you only have a c# answer, feel free to offer it!.

Anyway, I have a DataTable and a DataView which is a subset I have ID'd
to be deleted from that DataTable. I tried looping through the DataView
and deleting rows like this:

Dim dvAuto As New DataView
dvAuto.Table = dtCart
dvAuto.RowFilter = "AutoAdd = True"
If dvAuto.Count > 0 Then
Dim dr As DataRow
For Each dr In dvAuto.Table.Rows
dr.Delete()
Next
End If

But obviously it didn't work. I suspected modifying a collection while
looping through it would be a no-no and I was right (but tried anyway).

Without being able to issues a SQL delete like:
delete from dtCart where AutoAdd = True

I'm just not sure how to do this. How is this typically done? Thanks!

Matt

MattB <(E-Mail Removed)> wrote in
news:(E-Mail Removed):
> Dim dr As DataRow
> For Each dr In dvAuto.Table.Rows
> dr.Delete()
> Next
> End If
>
> But obviously it didn't work. I suspected modifying a collection while
> looping through it would be a no-no and I was right (but tried
> anyway).

Use a for loop and count backwards. If ir you want to clear all, just call .Clear.


--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Blog: http://blogs.atozed.com/kudzu