vb.net怎么删除datatable中满足条件的某行

vb.net如何删除datatable中满足条件的某行
下面的语句想删除LDS中店名列等于rm变量的行，可是总出错提示某行没有记录，各位高手你们一般都用什么方法删除DTATTABLE中的满足条件的某行呢？

VB.NET code

            Dim i As Integer
            For i = 0 To lds.Rows.Count - 1
                If lds.Rows(i)("店名").ToString = rm Then

                    lds.Rows.RemoveAt(i)

                End If

            Next

------解决方案--------------------
从后向前就ok了

VB.NET code

Dim i As Integer
            For i = lds.Rows.Count - 1 to 0 step -1
                If lds.Rows(i)("店名").ToString = rm Then

                    lds.Rows.RemoveAt(i)

                End If

            Next

------解决方案--------------------
店名不会重复即只删除1行的情况
           Dim i As Integer
           For i = 0 To lds.Rows.Count - 1
               If lds.Rows(i)("店名").ToString = rm Then

                   lds.Rows.RemoveAt(i)
                   Exit For
               End If
           Next
店名会重复即删除复数行的情况
           Dim i As Integer
          Dim list As ArrayList = New ArrayList()
           For i = 0 To lds.Rows.Count - 1
               If lds.Rows(i)("店名").ToString = rm Then
                   list.Add(i)
               End If
           Next

       For i = 0 To list.Count - 1
           lds.Rows.RemoveAt(list(i))
       Next

vb.net怎么删除datatable中满足条件的某行

相关推荐