I hope I am not asking simple one.
Library or Data
I have the data to display in a DropDownList control shown as above. There is a distinct category Type(example Support Services) and Category Name i.e., Computing Services.
I do not want to hard code the values into DropDownList control. I like to get the data from database to display as shown in above Table. Note that Category Type should be displayed in Bold and Category Name in normal Text.
In order to achieve the above,
1. How many database Tables and relationships between them
2. Query the data to display in the above format in drop down
3. how should be the code behind i.e, DataTextValue and DataValueField for DropDownList.
Please provide with useful code snippets or references.
View Complete Post