More than one open DataReader against a Connection ?

[StevenK]

I have an active / open SqlConnection against a SQL Server database.

When I try to open a second DataReader using this connection I get the message "There is already an open DataReader associated with this Connection which must be closed first".

Am I restricted to 1 active DataReader against a connection ? Do I need seperate SqlConnections for each DataReader I might potentially need in the scope of my application ?

Thanks for any pointers / advice in advance

Steve

 

[xloop]

Steve

ADO.NET is designed to worked with in a disconnected mannor so personally i would suggest using a dataset, datasets can hold multiple resultsets.

If you used to ADO then you'll remember you can't open two recordsets with the same connection.

CHeers