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 ?

Yes.

David
 
Back
Top