为了更新数据库,做了个测试窗体就两个按钮(显示和更新数据),一个DataGridView1,一个DataSet1,一个OleDbConnection1(连接已经设置),一个OleDbDataAdapter1(SelectCommand已经设置,updatecmd,delcmd等已经自动生成,但发现有问题,里面有很多问号,是怎么回事啊),一个OleDbCommandBuilder1-----------------------------------------------------显示按钮事件代码(可以正常显示数据): Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Me.OleDbCommandBuilder1.DataAdapter = Me.OleDbDataAdapter1 Me.OleDbDataAdapter1.Fill(Me.DataSet1, "table") Me.DataGridView1.DataSource = Me.DataSet1.Tables(0) End Sub--------------------------------------------------------更新数据按钮代码: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Me.OleDbCommandBuilder1.DataAdapter = Me.OleDbDataAdapter1 Dim myCount As Integer = Me.OleDbDataAdapter1.Update(Me.DataSet1, "table") Me.DataGridView1.EndEdit() Me.DataSet1.Tables(0).AcceptChanges() M