web app - Sorting dropdownlists/datasets

Hi,

     I have:

1 dropdownlist called cmbSearchBy with two options: Nomenclature and Item ID
2 dropdownlists called cmbSearch1 and cmbSearch2, where 1 is bound to Nomenclature and 2 is bound to ID in the dataset that comes from the products table

Nomenclature (cmbSearch1) is in alphabetical order - when cmbSearchBy is used to choose Item ID, and cmbSearch1 disappears and cmbSearch2 appears, I want the Item IDs to all be listed in numerical order, and back to alphabetical when switched back.  I don't know how to do this - do I need to use something like a dataview?  If so, code?  Currently they both list by the way the select statement ordered the dataset (by nomenclature)

Thanks!

JP
gleznovAsked:
Who is Participating?
 
eozz_2000Connect With a Mentor Commented:
I would use 2 dataviews (one for each combo):

dim dv as new DataView(yourDataSet.Tables("TheNameOfYourTable"))

and then, set the sort property:

dv.Sort = "TheNameOfTheColumn"

and then set the dataSource property of your combos to the dataView and set the DislplayMember property (I can't remember wich is that property in the web, but if you see all of them you will recognize it)
0
 
gleznovAuthor Commented:
Thanks!  And thanks for the clarity of your answer :)

JP
0
 
eozz_2000Commented:
Is good to know that my answer could help you
0
All Courses

From novice to tech pro — start learning today.