Private Sub Form_Load() Set db = New ADODB.Connection db.CursorLocation = adUseClient db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=newdb;uid=shenghuo;pwd=shenghuo" Set rs = New ADODB.Recordset strsql = "select * from table" rs.Open strsql, db, adOpenDymanic, adLockBatchOptimistic set datagrid1.datasource=rs '将结果集显示在DATAGRID表中 End Sub
Set db = New ADODB.Connection
db.CursorLocation = adUseClient
db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=newdb;uid=shenghuo;pwd=shenghuo" Set rs = New ADODB.Recordset
strsql = "select * from table"
rs.Open strsql, db, adOpenDymanic, adLockBatchOptimistic
set datagrid1.datasource=rs '将结果集显示在DATAGRID表中
End Sub