Data Reader Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I am using two datareaders with one connection and geting the following
error:

"There is already an open DataReader associated with this Connection which
must be closed first"

Should I use 2 connections with 2 separate datareaders.Or can I use 2
datareaders with one connection

Any help much appreciated.
 
As you can see by the error message, you cannot have 2 open data readers on
the same connection. So your options are to close the first before opening
the second, or to use 2 connections. Either that, or switch to using
datasets/datatables for one or both of your readers.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataReader and DB Connection Closing 3
data reader question 1
Error when load testing web application: all pooled connections were in use or max pool size was rea 1
Should I use only one public DataReader, or multiple? 2
I've got doubt about MARS feature support in ASP.NET 2.0 and MSSQL 2.0 1
reader inside a reader 5
Urgent..Please Help... 3
Internal connection fatal error and other random db connection err 0

Back
Top