以下是引用江南小镇在2024/5/6 22:03:00的发言:
老师,每次打开接收表多会重新复制相同的数据。
老师好,谢谢老师帮我写一下吧。
For Each dr1 As DataRow In DataTables("表A").Select("")
Dim dr2 As DataRow = DataTables("接收表").find("编号=‘“ & dr1(“编号”) & ”’")
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