DataReader versus bindingSource

  • Thread starter Thread starter Mr. X.
  • Start date Start date
M

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 :)
 
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
 
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.
 
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 :)
 
Actual

Mr. X. said:
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 :)
Click to expand...
 
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 ?
Click to expand...

Only without a Where clause in the SQL.
 
Back
Top