Next recordset

[simonZ]

I have sqlProcedure which returns 2 recordsets.

First recordset I put into sqldatareader:
SqlDataReader rdr;
SqlDataReader rdr1;

rdr = oCmd.ExecuteReader()

This works. But how can I get next recordset?

In past(ASP), I could use method rs.NextRecordset.
How this can be done in ado.net?

Something like:
rdr1=oCmd.MoveNextRecordset

regards,S

 

[sloan]

Check my blog:
http://spaces.msn.com/sholliday/ 5/24/2006 entry

It has what you're looking for. and a complete downloadable example too.

The (IDataReader.NextResult() is what you're looking for.

 

[tdavisjr]

The datareader has a NextResult() method.

 

[sloan]

For some reason, my post didnt go through.

(IDataReader.NextResult() is what you're looking for.


I have a complete example at:
http://spaces.msn.com/sholliday/ 5/24/2006 entry

it uses the NorthWind database, so its easy to download and run the example.

(The download link is near the bottom of the blog entry)




news:[email protected]...