Handling multiple result sets

  • Thread starter Thread starter aussie rules
  • Start date Start date
A

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
 
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!
***************************
 
Back
Top