Hello Friends,
I want to know if it is possible to open two datareaders in same connection. If yes, How can we do it? What's the code?

Thank you,
Gaurav Jain.

__________________
Gaurav

Hi Gaurav,

Yes u can create more than one DataReaders associated with one connection Becouse DataReader depends upon your Command object. At a perticuler time, u can associate only one DataReader with one Command object bcoz u can execute only command at a time with Command object.
As u can creae more than Command object with one Connection, so u can create more than one DataReaders also. In a simple way, u can say that Connection object gives u the path(Road) to travel & at a time, u can travel more than one vehicle.
I think, now u hav a clear idea about it!!!!!!!!!!!

Unfortunately, what anujrathi describes here is not true.

With .NET 1.x you can only have one data reader open at the time. This can be problematic if, for example, you want to present related data. To continue anujrathi's analogy, a connection is a narrow street, that only allows one car in one direction....

To overcome this problem, simply open up another connection and execute your reader against that connection.

In .NET 2 and SQL Server 2005 you can use MARS (Multiple Active Result Sets) that does allow you to have two readers open against a single connection.

Google for MARS and SQL Server 2005 and you'll find plenty of hits, describing how to set up and use MARS.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Hi,

No, you can't. The DataReader represents only one database record at a time. We must call the Read() method to fetch each new record from the underlying database table into the memory.

For it to work, the DataReader must remain connected to a database table. We can't cache a DataReader in your server's memory, so that we cannot use it on the multiple pages or over multiple requests to the same page. If we simply need to grab some database records and quickly display them on a web page, a DataReader is useful.

Regards
bhar
http://www.vkinfotek.com