Hi,
I have a problem with binding data to dropdownlist from database in alphabetical order.
My database contains some fields like All,Air,Airline,Books,Cars etc.
There are 2 dropdown lists one dropdown contains A to Z list like A,B,C,D..Z.
2nd list contains above items like All,Air,Books.Now I want that when I select A from A-Z list it will display A items in alphabetical order and the Top item should be "All" after that remaining items.But if I display items in alphabetical order All is displaying like Air,Airline,All.Can anybody help me to resolve the problem.
Thanks in advance
Pavani