DataReader versus bindingSource

[Mr. X.]

Hello.
I am using DataReader.
Also using bindingSource.
At mySql.
When using DataReader, I realize that I cannot open more then one DataReader
at a time - Can I overcome this problem ?
When using BindingSource, I am using filter, but when datatable is big,
does the : MySqlDataAdapter.fill(datatable) actually do the whole select
command (select * from big|Table) and fills (for big tables, it last too
long) - I connect it to bindingSource object ?

Thanks

 

[Cor]

You are comparing apples and computers.

DataBinding has to do how items in a collection are bound to items in a UI.

A datareader is an feature that is to retrieve data from a database by
instance into a collection.

Some put the data from a datareader direct in the controls, but that is in
my opinion 20th century style developing.

Cor

 

[Cor]

I forgot (or probably better to answer it in two replies because it are
apples and computers),

The dataadapter uses the datareader, if you don't open and close a
connection, the dataadapter does that intrinsic for you.

 

[Mr. X.]

For the dataAdapter.fill -
If I have millions of records in db : are all the millions of records loaded
to the dataset.
or dataAdapter.fill is only logical ?

Thanks

 

[Cor]

Actual

For the dataAdapter.fill -
If I have millions of records in db : are all the millions of records
loaded to the dataset.
or dataAdapter.fill is only logical ?

Thanks

 

[Armin Zingler]

Am 14.07.2010 12:45, schrieb Mr. X.:

For the dataAdapter.fill -
If I have millions of records in db : are all the millions of records loaded
to the dataset.
or dataAdapter.fill is only logical ?

Only without a Where clause in the SQL.