What's the recommended way of using to SqlDataReaders in a loop?

[Rico Alexander]

When the original has to be open to use its values as a parameter for the
second reader? Is it still possible to use one Connection?

 

[Kevin Spencer]

No. DataReaders cannot share a Connection.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

 

[Rico Alexander]

Thanks, Kevin. I'll try replacing one with a dataset.

 

[William Ryan]

Why don't you just use the first reader and load the variable(s) you need
into an arraylist or similar structure. THen, close the reader. Open up
the second one and you already have your value.