Private Sub Form_Load()
Dim con As ADODB.Connection ' 建立连接没问题
Dim rs As ADODB.Recordset
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist Security Info=False"
con.Open
Set rs = New ADODB.Recordset
rs.Open "select * from tab", con, adOpenDynamic, adLockOptimistic, adCmdText
DataGrid1.DataSource = rs
End Sub
------------------------------------------------
这样datagrid显示不出信息来,我会用 adodc绑,我想试试纯代码绑.谁能教几招?
Dim con As ADODB.Connection ' 建立连接没问题
Dim rs As ADODB.Recordset
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist Security Info=False"
con.Open
Set rs = New ADODB.Recordset
rs.Open "select * from tab", con, adOpenDynamic, adLockOptimistic, adCmdText
DataGrid1.DataSource = rs
End Sub
------------------------------------------------
这样datagrid显示不出信息来,我会用 adodc绑,我想试试纯代码绑.谁能教几招?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货