Multiple DataReaders

  • Thread starter Thread starter SqlJunkies User
  • Start date Start date
S

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
 
That's correct.

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

SqlJunkies User said:
Hi,

I need to have two DataReader in one connection, for example In DataReader
Click to expand...
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.
 
Marina said:
That's correct.

You can either
1) Have 2 connections
2) Use a datatable/dataset for at least one of your record sets.
Click to expand...
3) wait for whidbey :) (in the case of sql server)
 
Back
Top