小妹昨天调试了一下午,今天早上还是没调试出来,大虾们,帮忙呀!毕业设计就剩这一点了!
看看下面的代码:
在一个datagrid里已经显示出数据库表中的记录,我想对其中的“审核”字段的值进行修改后,再更新回数据库,下面的代码是在“提交审核”按钮里写的。审核的在表里的数据类型是bit类型。
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConn As New SqlConnection( "Data Source =(local);Initial Catalog=caiwu;Integrated Security=SSPI ")
Dim myDataAdapter As New SqlDataAdapter
myDataAdapter.SelectCommand = New SqlCommand( "select * from 凭证简要表 ", myConn)
Dim cb As SqlCommandBuilder = New SqlCommandBuilder(myDataAdapter)
myConn.Open()
Dim ds As DataSet = New DataSet
myDataAdapter.Fill(ds, "凭证简要表 ")
myDataAdapter.Update(ds, "凭证简要表 ")
myConn.Close()
End Sub
郁闷死了,老是有错误
[解决办法]
什么错误? 是值没有变吗?
你的修改没有读入数据库啊
myDataAdapter.UpdateCommand(myDataAdapter);
myDataAdapter.SelectCommand = New SqlCommand( "select * from 凭证简要表 ", myConn)
Dim cb As SqlCommandBuilder = New SqlCommandBuilder(myDataAdapter)