level 1
taogehu9
楼主
请大神指教,使用VB2013开发,对access进行更新,但是发现只能在Debug文件里自动生成更新后的数据库文件,在原来的数据库文件中始终不更新。代码如下:
Dim str As String = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source=通知数据库.accdb"
Dim conn As New OleDbConnection(str)
Dim strsql = "select * from XX软件园"
conn.Open()
Dim da As New OleDbDataAdapter(strsql, conn)
Dim ds As New DataSet
Dim dt As New DataTable
da.Fill(ds)
dt = ds.Tables(0)
DataGridView1.DataSource = dt
dt.Rows(0)(1) = "QQ"
Dim cmd1 As OleDbCommandBuilder = New OleDbCommandBuilder(da)
da.Update(dt)
conn.Close()
2018年06月12日 11点06分
1
Dim str As String = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source=通知数据库.accdb"
Dim conn As New OleDbConnection(str)
Dim strsql = "select * from XX软件园"
conn.Open()
Dim da As New OleDbDataAdapter(strsql, conn)
Dim ds As New DataSet
Dim dt As New DataTable
da.Fill(ds)
dt = ds.Tables(0)
DataGridView1.DataSource = dt
dt.Rows(0)(1) = "QQ"
Dim cmd1 As OleDbCommandBuilder = New OleDbCommandBuilder(da)
da.Update(dt)
conn.Close()