Populating Combo boxes from HUGE datasource (help & ideas!)

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

We have many many systems (accounts) which we need to search on. What my
initial Idea is to have a ComboBox1 populated w/ a list of all systems at
load (from Oracle table). Done and quick

But, step two, I want to populate ComboBox2 depending on the System
selection from ComboBox1 . But, the problem is, I can load the list of
'Systems' data into a dataset in just a few seconds. I did a quick test and
filled a dataset selecting everything from accounts , and it took a long
while..

Any ideas on how to proceed other than filling the DS first w/ EVERYTHING at
load..


ComboBox1 > SQLServer12345

Comboxbox2 > Account1
 
We have many many systems (accounts) which we need to search on.  What my
initial Idea is to have a ComboBox1 populated w/ a list of all systems at
load (from Oracle table).  Done and quick

But, step two, I want to populate ComboBox2 depending on the System
selection from ComboBox1 .  But, the problem is, I can load the list of
'Systems' data into a dataset in just a few seconds.  I did a quick test and
filled a dataset selecting everything from  accounts , and it took a long
while..

Any ideas on how to proceed other than filling the DS first w/ EVERYTHINGat
load..

ComboBox1 > SQLServer12345

Comboxbox2 > Account1
                       > Account2
                       > Account3
Click to expand...

If all you're doing is populating a combobox, why not use a datareader
instead of a dataset?
 
Back
Top