Dim cnn As New ADODB.Connection Dim rs As New ADODB.Recordset cnn.ConnectionString = "Provider=MSDASQL;DSN=data;UID=sa;PWD=sa;" cnn.CursorLocation = adUseClient cnn.Open rs.Open "select * from table where 条件 , cnn, adOpenDynamic,adLockBatchOptimistic Set Data.DataSource = rs
Set Data.DataSource = rs
data.databasename=数据库路径data.datasource="select * from 表" data.refresh
Dim rs As New ADODB.Recordset
cnn.ConnectionString = "Provider=MSDASQL;DSN=data;UID=sa;PWD=sa;"
cnn.CursorLocation = adUseClient
cnn.Open
rs.Open "select * from table where 条件 , cnn, adOpenDynamic,adLockBatchOptimistic
Set Data.DataSource = rs
data.refresh