Option Explicit
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strsql As StringPrivate Sub Command1_Click()
Set DataGrid1.DataSource = rs
Set MSHFlexGrid1.DataSource = rs
End SubPrivate Sub Form_Load()
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\mydb.mdb;Jet OLEDB:Database Password=zcb;Persist Security Info=False;" strsql = "select * from mytable"
Set rs = New ADODB.Recordset
rs.Open strsql, cnn, adOpenKeyset, adLockOptimistic
End Sub
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strsql As StringPrivate Sub Command1_Click()
Set DataGrid1.DataSource = rs
Set MSHFlexGrid1.DataSource = rs
End SubPrivate Sub Form_Load()
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\mydb.mdb;Jet OLEDB:Database Password=zcb;Persist Security Info=False;" strsql = "select * from mytable"
Set rs = New ADODB.Recordset
rs.Open strsql, cnn, adOpenKeyset, adLockOptimistic
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货