Dim drs As new List(of DataRow) drs=CurrentTable.DataTable.sqlSelect("") Dim idx As String = "" For Each dr As DataRow In drs idx &= dr("_Identify") & "," Next CurrentTable.DataTable.SqlDeletefor("[_Identify] in (" & idx.Trim(",") & ")") With CurrentTable.DataTable .loadfilter="" .load End With