很简单的问题!!
Dim strSQLConn_insert As String
strSQLConn_insert = "server=lizhen;database=Sys_EM_CD;trusted_Connection=yes"
Dim SQLConn_insert As New SqlConnection(strSQLConn_insert) '数据库连接
Dim sqladapt As New SqlDataAdapter("select * from tUpdate", SQLConn_insert)
Dim sqlcommandBuilder As SqlCommandBuilder = New SqlCommandBuilder(sqladapt)
SQLConn_insert.Open()
Dim Ddataset As New DataSet()
sqladapt.Fill(Ddataset, "tUpdate")
Ddataset.Tables(0).Rows(0)(0) = 8 '改变Dataset中一个值
sqladapt.Update(Ddataset, "tUpdate") '想在源数据库中更新改变的值
SQLConn_insert.close()
错误显示:对于不返回任何键列信息的 SelectCommand 不支持 UpdateCommand 的动态 SQL 生成。
why?
谢谢!!!!!!