如何将修改后的dataset结果插入到一张空白表中?
通过查询,得到dataset,然后进行修改,将结果(已修改记录或所有记录)插入到一张结构相同的空白表中.
用以下语句,却总是提示错误.违反并发性,我想原因应该是datarow状态的问题.
但datarow状态又是只读的,没法改成add.
如何实现插入功能呢.谢谢.
Private Sub updatedttotbl(ByVal _dt As DataTable, ByVal tblname As String)
With frmChild
Dim conn As New SqlConnection(strdmcw)
Dim dataAdapter As New SqlDataAdapter("select * from " & tblname, conn)
Dim cb As New SqlCommandBuilder(dataAdapter)
dataAdapter.Update(_dt)
_dt.AcceptChanges()
End With
End Sub