读书人

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

发布时间: 2012-05-01 12:48:58 作者: rapoo

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 Dotnet

热点推荐