弄堂和胡同的区别:Vb中关于datagrid的请教

来源:百度文库 编辑:高校问答 时间:2024/05/02 07:35:20
想要实现在datagrid控件中删除当前鼠标选中的行该怎么操作啊?
恳请高手能帮一下在下

在DataGrid 控件显示的数据中删除一条数据,可将鼠标选中该行记录,使用SQL查询语句进行
删除操作代码供参考:
Private Sub Command2_Click()
Adodc1.Recordset.Delete
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ldgz\jly.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from jishijilu"
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ldgz\jly.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from jishijilu"
Adodc1.Refresh
DataGrid1.Refresh
End Sub

Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ldgz\jly.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from jishijilu"
Adodc1.Refresh
End Sub