hi all
is it possible to use 2 datareaders at the same time with the same
connection ????
how ???
if not ? how can i do a clone from a connection ????

thks
JSB

Hi JSB,

cloning is certainly not an option. In the upcoming .NET Framework 2.0,
there will almost certainly be support for "multiple active result sets"
(MARS) - until then, you're constrained to one active data reader per
connection. Thus, your only option is to use two concurrent connections
(which isn't bad when connection pooling is used, which it is by default at
least for the MSSQL ADO.NET provider).

Show quoteHide quote

Excel ADO question
Updating a Dataset: How the Adapter works inside ?
OleDbReader and select query problem
DataReader - RowsAffected property
Suppress finalize in dataset constructor???