tables(表A).find(生产线 = 生产线 and 批次 = 批次 or 产品 = 'PD01' or 产品 = 'PD02')tables表B.addnew()
为何会出错?
Dim Cols1() As String = {"生产线", "批次", "产品"}
Dim Cols2() As String = {"生产线", "批次", "产品"}
For Each dr1 As DataRow In DataTables("生产线列表").datarows
Dim dr2 As DataRow = DataTables("车间列表").find("生产线 = '" & dr1("生产线") & "' And 批次 = '" & dr1("批次") & "' or 产品 = 'PD01' OR 产品 = 'PD02'")
If dr2 Is Nothing Then
dr2 = DataTables("车间列表").AddNew()
For i As Integer = 0 To Cols1.Length - 1
dr2(Cols2(i)) = dr1(Cols1(i))
Next
End If
Next
这样的话只会列出一条数据
如何正确的使用or?