gleznov
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is good to know that my answer could help you
ASKER
JP