DataAdapter and multiple result sets

[Michael C#]

I have a SQL Server stored procedure that returns multiple recordsets (three
of them), in the same way that sp_helpdb does (try entering EXEC SP_HELPDB
'MASTER' in Query Analyzer for an example). I want to populate my DataSet
with all three recordsets, as System.Data.DataTables. I'm not sure how to
move to the second and third resultsets in this case. Normally, with an
DataReader I would use the .NextResult method, but I'm trying to avoid the
DataReader and just use the DataAdapter's Fill method. Is this possible?

Thanks in advance

 

[Yunus Emre ALPÖZEN [MCAD.NET]]

Use a dataset and fill dataset with data adapter. All result sets will be
placed in different data tables.

 

[Michael C#]

Thank you. I was doing that, but there was an error in the parameters I was
passing so the results were garbage - that's why it wasn't working. It's
all good now though. Thanks again!