把 set datagrid1.datasource=adodc1 放到form_load()按钮事件中: adodc1.recordsource=sql adodc1.refresh
Dim Conn As New ADODB.Connection Dim Rs As New ADODB.Recordset Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" + ConData With Rs .ActiveConnection = Conn .Source = Sql .Open End With Set DataGrid1.DataSource = Rs对不对?试了试,也报错 the rowset is not bookable 而且还有一种生成的sql,最简单的查询 sql="select * from users" 结果可以在datagrid中显示,我狂晕~~~~
而在datagrid中却无法显示???
adodc1.recordsource=sql
adodc1.refresh
Dim Rs As New ADODB.Recordset
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" + ConData
With Rs
.ActiveConnection = Conn
.Source = Sql
.Open
End With
Set DataGrid1.DataSource = Rs对不对?试了试,也报错
the rowset is not bookable 而且还有一种生成的sql,最简单的查询
sql="select * from users"
结果可以在datagrid中显示,我狂晕~~~~