Handling multiple result sets

[aussie rules]

Hi,

I have a stored procedure that returns (in the one vb call) two sets of
data( ie the stored procedure does two select statements, and when run in an
isql session, to separate result tables are displayed).

Is it possible to handle these two results within a single call to the sql
server, as I do not want to have to do a second return trip to the server

Thanks.

Thanks

 

[Guest]

With a DataSet, the two result sets become two DataTables. If you use
TableMappings, you can give these tables real names. Otherwise, they are
Table and Table1.

With a DataReader, use NextResult to get to the next result set (much like
Next on a Recordset object in ADO).


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Sahil Malik]

Yes ---

DataAdapter will fill two datatables in a dataset.

DataReader will get two resultsets that can be browsed using the NextResult
method.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik