One guy asked me a question, he was having problems in updating and deleting rows when looping through a DataTable rows.
A
typical scenario is, say you have to loop through a DataTable rows and
do some calculations on the rows and delete some rows depending on the
condition. For example, deleting rows with Name = Mahesh.
If
you do like in the following code, you will get an error on
AcceptChanges method and the reason is deleting rows inside the loop
means affecting the indexing.
' Loop though the table
For Each dr As DataRow In ds.Tables(0).Rows
If (dr("Name") = "Omar" Then
dr.Delete()
End If
ds.Tables(0).AcceptChanges()
Next
However,
if you mark the rows as delete using Delete method and accept changes
on the DataTable outside the loop, you should be good to go. See the
following code:
' Loop though the table
For Each dr As DataRow In ds.Tables(0).Rows
If (dr("Name") = "Omar" Then
dr.Delete()
End If
Next
ds.Tables(0).AcceptChanges()
