avadhutd2
12-01-2009, 03:37 AM
Hi,
I have a query about Multi-Column Listbox property. There are 3 columns in the listboxes that I use.
The column no 3 in my listboxes is a ColID field which is numeric - like 1, 2, 3 ....
Just to give you some picture...The Multi-Column Listbox may look like:
Col1 Col2 Col3(ColID)
Item1 Typ1 1
Item2 Typ2 2
Item3 Typ3 3
While fetching from database I populate the data using SQL Query in the listbox1 with order of ColID field in ascending manner.
Next I use the entries in listbox1 to get transferred to listbox2. (For example item# 1 in the listbox 1 which has a ColId as 1 transferred to listbox2 using a button).
Now when I transfer back the same item back to listbox1 I get that added to listbox1 but not at the same place as it was earlier.
Is there any way that we can sort the items in a listbox in ascending manner by a column?
For example - in my case I need to always sort listbox1 by column# 3 (ColID) as I need the items arranged for ColID in order 1, 2, 3 ....etc
Kindly let me know...
Thanks!
I have a query about Multi-Column Listbox property. There are 3 columns in the listboxes that I use.
The column no 3 in my listboxes is a ColID field which is numeric - like 1, 2, 3 ....
Just to give you some picture...The Multi-Column Listbox may look like:
Col1 Col2 Col3(ColID)
Item1 Typ1 1
Item2 Typ2 2
Item3 Typ3 3
While fetching from database I populate the data using SQL Query in the listbox1 with order of ColID field in ascending manner.
Next I use the entries in listbox1 to get transferred to listbox2. (For example item# 1 in the listbox 1 which has a ColId as 1 transferred to listbox2 using a button).
Now when I transfer back the same item back to listbox1 I get that added to listbox1 but not at the same place as it was earlier.
Is there any way that we can sort the items in a listbox in ascending manner by a column?
For example - in my case I need to always sort listbox1 by column# 3 (ColID) as I need the items arranged for ColID in order 1, 2, 3 ....etc
Kindly let me know...
Thanks!