数据库更新问题?
hxzgy 2008-10-28 03:12:54 我把数据库(表名123)的数据导入datagridview中,修改数据,保存,而数据库没变?在网上找了很多相关资料 ,都没解决!(不好意思是新手)
保存按钮的代码如下:
Dim myConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & fFileName & ";" & "Jet OLEDB:Database Password='" & PassWord & "';")
Dim myDataAdapter = New OleDbDataAdapter
myDataAdapter.SelectCommand = New OleDbCommand("SELECT * FROM 123", myConn)
myConn.Open()
Dim custCB = New OleDbCommandBuilder(myDataAdapter)
Dim custDS = New DataSet()
myDataAdapter.Fill(custDS, "123")
myDataAdapter.Update(custDS, "123")
myConn.Close()
都查了几天了!没出错提示,请帮忙解决一下,谢谢!!!