关于ado处理存储过程返回的多个记录集

[babystudio]

过去一直没考虑过这个问题，今日见到一贴相关所以请大虾们指教

CREATE PROCEDURE [dbo].[sp_babystudio]
AS
select * from table1
select * from table2
select * from table3
GO

一般的情况是在ADO中只能接收到第一个记录集，各位请指教一次获得三个记录集的方法

[ben988211]

关注

[pengdali]

哈哈我想起来了是：NextRecordset方法！！！！！！！

[pengdali]

Dim cmd As New ADODB.Command
Dim rs As ADODB.Recordset

Cmd.ActiveConnection = "DSN=MySamples;UID=sa"
Cmd.CommandText = "MyNextProc"
Cmd.CommandType = adCmdStoredProc

Set rs = Cmd.Execute()
While Not rs Is Nothing
If (Not rs.EOF) Then
Debug.Print rs(0)
End If
Set rs = rs.NextRecordset()
Wend

[babystudio]

呵呵，晕倒
送分了