listing 8 in aspnet 2 0 professional is trying to execute two data readers simultaniuosly and I assume that if the outhors did it ,it should work.

the program starts with reading registers of one table using OrdersReader = Command.ExecuteReader()
and then for each record it reads (with the same connection) anothe table using OrderDetailReader = Command.ExecuteReader()
with out closing the first one.
when the program come to execute the second datareader I get the error message about having to close the first one.


Dim DBCon As SqlConnection
Dim OrdersReader As SqlDataReader


Dim OrderDetailReader As SqlDataReader
Command.Connection = DBCon
OrderDetailReader = Command.ExecuteReader()

I remember getting an error similar to this. I got around the problem with something like this...

if (databaseConnection) {
// we still have the connection - good to go
} else {
// code to create a new connection
}

I was able to get three queries going, and I think that's the code that did it. If not let me know, and I'll check the code.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.