为什么我的update没有反映?
代码如下,conn是连接字符串,连接没有问题,语句也都对,但是整个过程执行后数据库根本没有更新,单独执行语句都可以正常执行。
Dim strupdate = "update aa set bb=3 where id=1"
Dim strsql = "select * from aa"
Dim myDataAdapter As New SqlDataAdapter
Dim myDataSet As New DataSet
Dim TableName As String
Dim a() As String
a = strSQL.Split(" ")
TableName = a(3)
myDataAdapter.SelectCommand = New SqlCommand(strsql, Conn)
Dim custCB As SqlCommandBuilder = New SqlCommandBuilder(myDataAdapter)
myDataSet.Tables.Add(TableName)
myDataAdapter.Fill(myDataSet, TableName)
myDataAdapter.UpdateCommand = New SqlCommand(strupdate, Conn)
Try
myDataAdapter.Update(myDataSet, TableName)
'myDataSet.Tables.Remove(TableName)
Catch er As Exception
MsgBox(er.ToString)
End Try
请教这是为什么?