…… For n As Integer = 1 To Sheet.Rows.Count -1
Dim r As DataRow = t.DataTable.SQLFind("fa piao号 = '" & sheet(n, 3).text & "'")
If r Is Nothing Then
r = t.DataTable.AddNew()
newcount += 1
Else
oldcount += 1
End If
For i As Integer = 0 To sheet.Cols.Count -1
Dim cname As String = sheet(0, i).text
If t.Cols.Contains(cname) Then
r(cname) = sheet(n, i).Text
End If
Next
r.save
Next
……