DataAdapter and multiple result sets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael C# - 10 May 2005 18:22 GMT

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

Reply to this Message

Yunus Emre ALPÖZEN [MCAD.NET] - 10 May 2005 18:33 GMT

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

Signature

Thanks,
Yunus Emre ALPÖZEN
BSc, MCAD.NET

>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
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message

Michael C# - 10 May 2005 19:05 GMT

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!

> Use a dataset and fill dataset with data adapter. All result sets will be
> placed in different data tables.
[quoted text clipped - 9 lines]
>>
>> Thanks in advance

Reply to this Message

Rate this thread:

DataAdapter and multiple result sets

Free Magazines