RE: Handling multiple result sets
From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 01/17/05
- Next message: Cowboy (Gregory A. Beamer) - MVP: "RE: Metadata-driven data retrieval"
- Previous message: Paul Clement: "Re: When parsing CSV using OleDbConnection, trailing spaces are trimmed"
- In reply to: aussie rules: "Handling multiple result sets"
- Next in thread: Sahil Malik: "Re: Handling multiple result sets"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 Jan 2005 08:51:05 -0800
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! *************************** "aussie rules" wrote: > 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 > > >
- Next message: Cowboy (Gregory A. Beamer) - MVP: "RE: Metadata-driven data retrieval"
- Previous message: Paul Clement: "Re: When parsing CSV using OleDbConnection, trailing spaces are trimmed"
- In reply to: aussie rules: "Handling multiple result sets"
- Next in thread: Sahil Malik: "Re: Handling multiple result sets"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
