Combo Box Speed Question

  • Thread starter Thread starter Vayse
  • Start date Start date
V

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

databinding combobox to a bindingsource - value of '0' is not valid for 'selectedindex' 0
Clearing a combo box 1
Access Control on subform / combo box requesting parameter 0
Combo Box Binding problems 10
Value violates the MaxLength - from combo box 6
Two combo box with same data adapter in same dataset. 1
Binding a combo box 3
Question on databinding windows control to dataset in another project... 2

Back
Top