Data in Alphabetical order

[amit2011]

i am working on Visual Studio 2005 n SQL server 2005.i have written some data value in random order in a table,now i want that,when i access that table in a DropDownList then those values should appear in ALPHABETICAL ORDER... kindly help..thanx a lot..

[Ashfield]

From memory, the dropdown list has a sort property? Or maybe use ORDER BY in your select?

Bob Ashfield Consultants Ltd

[Vimalsoft Pty Ltd]

You can do it from SQl with select ColumnName from my_table Order by ColumnName Asc Or you can do what is suggested by the other guy here. Hope this helps

Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

[leckey 0]

History of posting same question in multiple forums and not using Google for basic questions.

Blog link to be reinstated at a later date.