1、 Dim Cmd AS NEW ADODB.Command Dim Rs AS NEW ADODB.Recordset Cmd.ActiveConnection = g_StrCon '自己定义 Cmd.CommandType = adCmdText Cmd.CommandText = strSQL '自己定义 Set Rs = Cmd.Execute ' If NOT Rs.EOF Then Set MSH1.DataSource = Cmd.Execute LblCount = "符合条件的记录共有:" & MSH1.Rows - 1 Else MSH1.Clear MSH1.Rows = 2 LblCount = "" End If2、 Dim Rs AS NEW ADODB.Recordset Rs.Open strSQL, g_StrCon, adOpenStatic, adLockOptimistic If Not Rs.EOF THEN Set MSH1.DataSource = Rs EndIF Rs.Close
Dim Cmd AS NEW ADODB.Command
Dim Rs AS NEW ADODB.Recordset
Cmd.ActiveConnection = g_StrCon '自己定义
Cmd.CommandType = adCmdText
Cmd.CommandText = strSQL '自己定义
Set Rs = Cmd.Execute
'
If NOT Rs.EOF Then
Set MSH1.DataSource = Cmd.Execute
LblCount = "符合条件的记录共有:" & MSH1.Rows - 1
Else
MSH1.Clear
MSH1.Rows = 2
LblCount = ""
End If2、
Dim Rs AS NEW ADODB.Recordset
Rs.Open strSQL, g_StrCon, adOpenStatic, adLockOptimistic
If Not Rs.EOF THEN
Set MSH1.DataSource = Rs
EndIF
Rs.Close
.recordset
rst.Open csql,con,adOpenKeyset,adLockOptimistic