For Each dr1 As DataRow In DataTables("Pricelist").Select("[FNeg] = true ")
If DataTables("test").find("ID='" & dr1("ID") & "'") Is Nothing Then
Dim dr2 As DataRow = DataTables("ConfirmList").AddNew()
For i As Integer = 0 To Cols1.Length -1
dr2(Cols2(i)) = dr1(Cols1(i))
dr2("FEntryID") = ""
dr2("FLastModifiedDate") = Nothing
dr2("FUsed") = False
Next
End If
else
DataTables("test").DeleteFor("ID='" & dr1("ID") & "'")
Next