Dim tns() As String = {"表A", "表B", "表C"} Dim dt As DataTable = DataTables("快递查询表") For Each tn As String In tns For Each r As Row In Tables(tn).Rows If r.IsNull("快递单号") = False Then Dim fdr As DataRow = dt.Find("快递单号 = '" & r("快递单号") & "'") If fdr Is Nothing Then Dim nr As DataRow = dt.AddNew nr("快递名称") = r("快递名称") nr("快递单号") = r("快递单号") nr("寄件日期") = r("寄件日期") End If End If Next Next
|