How to show hierarchial data in a dropdownlist.
- by vaibhav
I have a table in sqlserver 2005.
I want to show all domain name in a dropdownlist maintaing the same hierarchy. i.e
Law
Engineering
--civil
--Mechanical
Medical
--Dental
----Cavity
--MBBS
I need to append '--' according to the domain level. Is it possible using a sql query.
or alternatively can I have any other control to show this data.