How to sort a list box in descending order

[acjeff]

There is a sort property for list box in VB. When it's true, it sorts in asending order. Is there a simpliest way to sort it in descending order?

Jeff

 

[Swi]

What are you populating the list box from? A text file, database table, etc...?

Swi

 

[acjeff]

A database table. Can be a thousand (or more) items into the list box.

 

[Swi]

Use the ORDER BY clause in your SQL statement:

http://www.devguru.com/Technologies/jetsql/quickref/order_by.html

Swi

 

[acjeff]

Sorry, I made a confusion. There are 2 listboxes. Data is loaded from a database table into the first listbox in descending order. So far it's fine. Then users select data and add them to the second list box. At this point, I also want the second listbox in descending order no matter what sequence of data the users select. I don't want to use a looping code to sort the second box every time a new data is added because it will be slow. That's why I asked about descending sorting.

 

[Swi]

Look into the listview control. It has a sortorder property.

Swi