Combo Box Speed Question

[Vayse]

I have a databound form, bound to AssetsDataSet.
There are 8 combo boxes on the form. Each of these looks up a different
table, and each has a binding source and table adapter.
The form is a bit slow to load, and I'm worried it will slower as more data
is added.
Some questions
1) Does each additional binding source and table adapter make the form
slower to load?
2) If this was Access, I would base the combo boxes on read only queries. Is
there an equivalent in .net that I should be doing?

Thanks
Vayse

[shiv_koirala]

Are using datareader...forward only speedy...

Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/

[Vayse]

Could you clarify? I don't get what you mean.

<sh**********@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Are using datareader...forward only speedy...

Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/

[Peter Huang [MSFT]]

Hi Vayse,

I think shiv means to use a DataReader class but not the Adapter to fill
all the dataset.
If you program logic is to complete the databinding and then display the
form(e.g. you fill dataset in the form_load), then the form will be shown
until the fill complete.
So that may take time to display the form.

While DataReader will read data one by one according to your logic, that
will save the time according to load the whole dataset.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.