Hello VB Experts,

Can anyone show me how I can sort items in a datalist alphabetically?
I bounded the data using ADODC and Microsoft Jet 4.0 ole db connecting string.
I would appreciate it much if anyone could help me solve this problem.

Thanks in advance

Hi Shouvi,
thanks for your quik respons, I will try that and get back to you

use order by clause in your sql.

like ,
select * from <table name> order by <field name>

Hi Shouvi,
thanks for your quik respons, I will try that and get back to you

You can also add AFTER ORDER BY <field name> ASCENDING or DESCENDING

ASCENDING is default for DESCENDING you need to specify DESC after the field name.

Should have specidied, u're right, sorry.

Hello Folks,

Thanks so much, I tried it and it worked perfectly, I am very grateful

on below of last post you can see a link "mark as solved", click on it to make this thread solved.

This question has already been answered. Start a new discussion instead.