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

"Mr. X." <(E-Mail Removed)> wrote in message
news:i1errq$aj3$(E-Mail Removed)...
> 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

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." <(E-Mail Removed)> wrote in message
news:i1errq$aj3$(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:4c3c03b0$0$14131$(E-Mail Removed)...
> 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." <(E-Mail Removed)> wrote in message
> news:i1errq$aj3$(E-Mail Removed)...
>> 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
>

Actual

"Mr. X." <(E-Mail Removed)> wrote in message
news:i1k4fk$ri3$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:4c3c03b0$0$14131$(E-Mail Removed)...
>> 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." <(E-Mail Removed)> wrote in message
>> news:i1errq$aj3$(E-Mail Removed)...
>>> 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
>>
>

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.


--
Armin