How to delete items from a DataTable during an enumeration

Author	Message
Greg McGuffey	Greg McGuffey posted 18 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 2K, Visits: 6.6K	I'm trying to enumerate all the rows in a DataTable and if a certain condition is met, delete the current row. .NET doesn't like this: Dim myTable As DataTable '...fill table, two columns a string and an integer For Each myRow As DataRow In myTable.Rows If myRow.Item(1) = 34 Then myTable.Delete(myRow) End If Next It bombs when the Next statement hits. Is there another way to do this?
	Reply Like 0
Replies
Greg McGuffey	Greg McGuffey posted 18 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Got it. I think the DataRow.Delete() works because it doesn't remove the item from the collection until you AcceptChanges, which I'm doing after the enum.
	Reply Like 0
Trent Taylor	Trent Taylor posted 18 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	Good.
	Reply Like 0