Dim cmd As New SQLCommand
Dim dt As DataTable
Dim sCols() As String = {"订单号","联系人电话","上门日期","时间"}
Dim dCols() As String = {"订单号","电话号码","截止日期","时间"}
cmd.C
cmd.CommandText = "SELEC T * From {shdd}"
dt = c
For Each dr As DataRow In dt.DataRows
Dim nr As DataRow = DataTables("派工_Table1").AddNew()
For i As Integer =0 To sCols.Length -1
nr(dCols(i)) = dr(sCols(i))
Next
Next
msgbox("新增" & newcount & " " & "更新旧数据" & oldcount)
t.ResumeRedraw()
请教老师:如何通过 ”订单号” 来实现已有相同订单号的行更新,没有的新增呢?更新完,再提示。谢谢
[此贴子已经被作者于2023/3/13 16:13:52编辑过]