关于删除DATAGRIDVIEW表里面的一条记录的问题
我用了一个DATAGRIDVIEW控件
我想 "删除 "这个按钮 可以删除上面表的一条记录,怎么做呢?请问
[解决办法]
Public Class Form1
Dim conn As Data.OleDb.OleDbConnection
Dim da As Data.OleDb.OleDbDataAdapter
Dim ds As Data.DataSet
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New OleDb.OleDbConnection( "Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:\data.mdb ")
conn.Open()
da = New OleDb.OleDbDataAdapter( "SELECT * FROM 表1 ", conn)
ds = New Data.DataSet
da.Fill(ds)
conn.Close()
DataGridView1.DataSource = ds.Tables(0)
End Sub
' Button1,用于更新数据库
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim b As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(da) ' 自动生成SQL语句
Try
ds.AcceptChanges()
da.Update(ds) ' 更新数据库,必须这样才能改变源数据库中的数据
MsgBox( "Updated ")
Catch ex As Exception
MsgBox( "Error ")
End Try
End Sub
' Button2,用于删除当前行的记录
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
ds.Tables(0).Rows.RemoveAt(DataGridView1.CurrentRow.Index) ' 删除当前行的记录
End Sub
End Class