Dim ar As New ADODB.Recordset Dim ac As New ADODB.Connection
Private Sub Form_Load() ac.ConnectionString = "*****" ac.CommandTimeout = *** ac.Provider = "*******" ac.Open ar.Open Tablename, ac, adOpenDynamic, adLockOptimistic, adCmdTable End Sub
Private Sub cmd_click_Click() On Error GoTo err_proc With ar .Filter = "**********" .MoveFirst Do While Not .EOF '/////进行统计,可以写统计代码,如统计合计数等 '------ .MoveNext Loop End With Set DataGrid1.DataSource = ar Exit Sub err_proc: '//////出错处理 End Sub
Option Explicit
Dim ar As New ADODB.Recordset
Dim ac As New ADODB.Connection
Private Sub Form_Load()
ac.ConnectionString = "*****"
ac.CommandTimeout = ***
ac.Provider = "*******"
ac.Open
ar.Open Tablename, ac, adOpenDynamic, adLockOptimistic, adCmdTable
End Sub
Private Sub cmd_click_Click()
On Error GoTo err_proc
With ar
.Filter = "**********"
.MoveFirst
Do While Not .EOF
'/////进行统计,可以写统计代码,如统计合计数等
'------
.MoveNext
Loop
End With
Set DataGrid1.DataSource = ar
Exit Sub
err_proc:
'//////出错处理
End Sub