Re: How many DataReader can be associated a one Connection?

[Jean-Francois Mathieu]

The difference is that a recordset get (i think) all the data at one time like the dataset. The datareader start giving you back the data after the first record.

If you whant multiple query on the same connection you have to use datatable ou dataset ou commande beacause they read all/execute the data at a time.

So if you whan you can load in a dataset and loop with a for each instead of a datareader that keep the connection open.

Load Myds
For each row in Myds_table_rows
mycomande.executequery =""
Next

And by the way the dataset is fill by a datareader.

hope it help