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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?Q2hyaXM=?=
    #1

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

    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
    Account2
    Account3
    Tags: None
    • zacks@construction-imaging.com
      #2
      Re: Populating Combo boxes from HUGE datasource (help & ideas!)

      On Sep 29, 12:42 pm, Chris <Ch...@discussi ons.microsoft.c omwrote:
      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
      If all you're doing is populating a combobox, why not use a datareader
      instead of a dataset?

        Comment

        • =?Utf-8?B?Q2hyaXM=?=
          #3
          Re: Populating Combo boxes from HUGE datasource (help &amp; ideas!)

          Would you happen to have any examples w/ datareader. I'm looking into it now.

          Thanks!

          "zacks@construc tion-imaging.com" wrote:
          On Sep 29, 12:42 pm, Chris <Ch...@discussi ons.microsoft.c omwrote:
          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
          Account2
          Account3
          >
          If all you're doing is populating a combobox, why not use a datareader
          instead of a dataset?
          >

            Comment

            Previous template Next
            Working...