逐行保存
For Each l As Integer In dic.Keys
Dim ndr As DataRow
If dic(l) Is Nothing Then
ndr = dt.AddNew
Else
ndr = dic(l)
End If
For Each m As String In nms.keys
If dt.DataCols(m).IsBoolean Then
If ary(l,nms(m))= "" OrElse ary(l,nms(m))= "False" OrElse ary(l,nms(m))= 0 Then
ndr (m) = False
Else
ndr (m) = True
End If
Else If dt.DataCols(m).Expression > "" Then
'表达式列
Else If dt.DataCols(m).IsNumeric Then
ndr (m) = val(ary(l,nms(m)))
Else If dt.DataCols(m).IsDate Then
Dim d As Date
If Date.TryParse(ary(l,nms(m)), d)
ndr (m) = d
End If
Else
ndr (m) = ary(l,nms(m))
End If
Next
ndr.save
Next
dt.ResumeRedraw()
加好友 
发短信
Post By：2021/7/31 10:43:00 [显示全部帖子]
