How to delete items from a DataTable during an enumeration

Author	Message
Greg McGuffey	Greg McGuffey posted 17 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

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Greg McGuffey - 17 Years Ago

It is because you are changing the contents of the value being...

Trent L. Taylor - 17 Years Ago

Thanks for the help. While implementing what you suggestion, I...

Greg McGuffey - 17 Years Ago

This has nothing to do with data tables, but rather any type of...

Trent L. Taylor - 17 Years Ago

Got it. I think the DataRow.Delete() works because it doesn't remove...

Greg McGuffey - 17 Years Ago

Good. :)

Trent L. Taylor - 17 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login