Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting a row
Message
 
 
To
02/01/2011 19:00:34
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01494343
Message ID:
01494360
Views:
45
I know Bonnie answered this question, but even I can spot an error in your code. The same applies to VFP also.

You can not use FOR EACH loop and remove a member of collection at the same time. It should be even documented in the FOR EACH loop (in C# I do remember reading it).

If you need to remove a member of collection, then you need to use next loop and start from the last member and do it backwards.

>>What code are you using that you get this error? A DataRow can call it's Delete() method with no problem. Are you doing something peculiar?
>
>I always have to do something like this:
>
>
>            loDataView = New DataView(loDataProvider.oDataSet.Tables.Item(0))
>
>            loDataView.RowFilter = "Flag=1"
>
>            ' Delete all records which have been flagged
>            For Each loRowView In loDataView
>                loRowView.Delete()
>            Next
>
>            loDataView.RowFilter = ""
>            loDataView.Table.AcceptChanges()
>
>            ' Adjust the count
>            loDataProvider.nCount = loDataProvider.oDataSet.Tables("Temp").Rows.Count
>
>
>Because, if I scan my dataset, and based on a condition, I want to remove the record, it will tell me that the Delete() method cannot be used:
>
>
>            ' For each message
>            For lnCounter = 0 To loDataProvider.nCount - 1
>                loRow = loDataProvider.oDataSet.Tables("Temp").Rows(lnCounter)
>
>                ' If we have to delete the row
>                If True Then
>                    loRow.Delete()
>                End If
>
>            Next
>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform