我的存储过程中有如下3个语句:
select * from tableA
select * from tableB
select * from tableC
如果我想得到tableB的数据付到我的窗体中,怎么取?
Public Function Fy() As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim cmd As ADODB.Command
Set rs2 = New ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = 连接字符串
cmd.CommandText = "存储过程名"
cmd.CommandType = adCmdStoredProc
Set rs2 = cmd.Execute
Set Fy = rs2.NextRecordset这句是获得第2个记录集
Set cmd = Nothing
Set rs2 = Nothing
End Function