返回的表是否有 联合查询,还是仅仅是单表?
绑定的datatable 是强类型的还是弱类型的?
如果是单表,可以使用一下代码一件更新,但是,请自己确认每个数据的正确型及确定表中含有主键!!
Public Shared Sub UpdateDataTable(ByVal dt As DataTable, ByVal TableName As String)
Dim cnn As SqlConnection = New SqlConnection(CnStr)
cnn.Open()
Dim Sqlstr As String = "SELECT * FROM" & TableName & " WHERE 1 = 2"
Dim TmpDs As New DataSet
Using da As New SqlDataAdapter(Sqlstr, cn)
Dim scb As SqlCommandBuilder = New SqlCommandBuilder(da)
da.Update(dt)
dt.AcceptChanges()
End Using
cnn.Dispose()
End Sub
其中:cnstr是链接字符串,dt - 是绑定的表,tablename 是表的名称