getting records alphabetically

[gjoisa]

I have developed a program with a sql database . I have added all records to a table first . then i added the records with required keyword to a list box . Here i am experincing the problem . Records displaying not in alphabetical order . how to display records in a listbox with alphabetical order ?

[Erel]

You should add ORDER BY to your query:

cmd.CommandText = "SELECT col1 ORDER BY col1 ASC"

[giannimaione]

Originally Posted by Erel

You should add ORDER BY to your query:

cmd.CommandText = "SELECT col1 ORDER BY col1 ASC"

or

cmd.CommandText = "SELECT col1 ORDER BY col1 DESC"