高手帮帮忙呀,我想用右键删除datagridview当前记录,并更新到数据库,删除了但是没有更新到数据库.这是我的代码Private Sub DataGridView1_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseClick Dim row As Integer = DataGridView1.CurrentRow.Index If e.Button = Windows.Forms.MouseButtons.Right Then If row >= 0 And row < DataGridView1.RowCount Then Dim a As Integer = MessageBox.Show("确定删除当前记录吗?", "删除当前记录", MessageBoxButtons.OKCancel, MessageBoxIcon.Hand) If a = 1 Then DataGridView1.Rows.RemoveAt(row) update1() 'sql_user() End If End If End If End Sub Sub update1() Dim con As New SqlConnection("Data Source=Localhost;Initial Catalog=xsdaxt;Integrated Security=True") con.Open() Dim ds As New DataSet Dim dba As New SqlDataAdapter("select * from xx", con) Dim cmdb As New SqlCommandBuilder(dba) dba.Fill(ds, "xx") dba.Update(ds, "xx") ds.AcceptChanges() con.Close() End Sub

dba.Fill(ds, "xx") 所有记录状态都为未改动 dba.Update(ds, "xx")update只更新状态变动的行

用SqlCommandBuilder来更新就行了，你都根本没用到commandbuilder当然无法更新了。

你的删除数据库语句都没写何来的更新数据