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 ?:sign0085:

 

[Erel]

You should add ORDER BY to your query:

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

 

[giannimaione]

You should add ORDER BY to your query:

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

or

cmd.CommandText = "SELECT col1 ORDER BY col1 [B]DESC[/B]"