sqldatareader connection

  • Thread starter Thread starter Miha Markic [MVP C#]
  • Start date Start date
M

Miha Markic [MVP C#]

Hi,

z. f. said:
Hi,

why is this error exist?

there is already an open datareader associated with this connection which
must be closed first


does the reader running on a server side cursor ? can't it work in a
disconnected fashion?
Click to expand...

Yes, reader is server side. Only one operation at the same time can be used
with connection.
Such an operation is using datareader.
If you want disconnected fashion then use dataadapter.Fill to fill a
datatable.
what should i do in order to run disconnected or when i want to make update
on each iteration of the reader, use data table?
Click to expand...

Sure, either use the approach above or create another connection instance
for your updates.
 
Hi,

why is this error exist?

there is already an open datareader associated with this connection which
must be closed first


does the reader running on a server side cursor ? can't it work in a
disconnected fashion?

what should i do in order to run disconnected or when i want to make update
on each iteration of the reader, use data table?

why is it implemented this way?

TIA, z.
 
Back
Top