sqlConnection

  • Thread starter Thread starter dan182
  • Start date Start date
D

dan182

if i open a connection and then open a datareader off that
connection.

then loop through the datareader attempting to perform
updates through the same connection, then i get an error

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

oh and the there is a transaction based on the connection.

should i maybe use a dataset ?

dan
 
dan182 said:
if i open a connection and then open a datareader off that
connection.

then loop through the datareader attempting to perform
updates through the same connection, then i get an error

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

oh and the there is a transaction based on the connection.

should i maybe use a dataset ?
Click to expand...

Yes.

David
 
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

Explicitly close DataReader if I close the underlying connection?" 2
There is already an open DataReader associated with this Command which must be closed first 13
Will this close/dispose properly? 5
DAL technique - which is better 4
Calling Dispose instead of close, clear, .... 20
DataReader Question 2
dbDataReader 5
DataReader versus bindingSource 5

Back
Top