Multiple DataReaders

[SqlJunkies User]

Hi,

I need to have two DataReader in one connection, for example In DataReader one the Authors Info and DataReader two the Pubs. I read DataReader use exclusive the connection, i can do anything without use DataSet??? Thanks

 

[Marina]

That's correct.

You can either
1) Have 2 connections
2) Use a datatable/dataset for at least one of your record sets.

Hi,

I need to have two DataReader in one connection, for example In DataReader

one the Authors Info and DataReader two the Pubs. I read DataReader use
exclusive the connection, i can do anything without use DataSet??? Thankssupports Post Alerts, Ratings, and Searching.

 

[Miha Markic [MVP C#]]

That's correct.

You can either
1) Have 2 connections
2) Use a datatable/dataset for at least one of your record sets.

3) wait for whidbey (in the case of sql server)