Results 1 to 5 of 5

Thread: alphabetize a dbcombo

  1. #1

    Thread Starter
    Addicted Member DKasler's Avatar
    Join Date
    Jan 2005
    Location
    Brooklyn, NYC
    Posts
    177

    alphabetize a dbcombo

    I have a dbcombo box that I allow users to add new items to which are then saved to the db... but even after a refresh the dbcombo is not alphabetized.

    How can I make it Auto-alphabetize?
    -----MY SITES-----
    BayRidgeNights.Com - NYC Nightlife Forums

    Fight Communism - Rate Posts!

  2. #2
    Frenzied Member sciguyryan's Avatar
    Join Date
    Sep 2003
    Location
    Wales
    Posts
    1,763

    Re: alphabetize a dbcombo

    Quote Originally Posted by DKasler
    I have a dbcombo box that I allow users to add new items to which are then saved to the db... but even after a refresh the dbcombo is not alphabetized.

    How can I make it Auto-alphabetize?
    After you refresh, try setting the Sorted Property to true again

    Cheers,

    RyanJ
    My Blog.

    Ryan Jones.

  3. #3

    Thread Starter
    Addicted Member DKasler's Avatar
    Join Date
    Jan 2005
    Location
    Brooklyn, NYC
    Posts
    177

    Re: alphabetize a dbcombo

    It would seem that the DBcombo doesnt have a sorted property.

    Though standard combo boxes do.
    -----MY SITES-----
    BayRidgeNights.Com - NYC Nightlife Forums

    Fight Communism - Rate Posts!

  4. #4
    Frenzied Member sciguyryan's Avatar
    Join Date
    Sep 2003
    Location
    Wales
    Posts
    1,763

    Re: alphabetize a dbcombo

    Quote Originally Posted by DKasler
    It would seem that the DBcombo doesnt have a sorted property.

    Though standard combo boxes do.
    Hmm, in that case you will have to do it manually.
    Load the list into an array, sort them and then write them back into the combobox... Thats about the only method I can think of.

    The best sorting algorithm is the Quick sort which can be found in the Code bank

    Cheers,

    RyanJ
    My Blog.

    Ryan Jones.

  5. #5

    Thread Starter
    Addicted Member DKasler's Avatar
    Join Date
    Jan 2005
    Location
    Brooklyn, NYC
    Posts
    177

    Re: alphabetize a dbcombo

    thanks RyanJ
    -----MY SITES-----
    BayRidgeNights.Com - NYC Nightlife Forums

    Fight Communism - Rate Posts!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width