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

use order by clause in your sql.

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

answered by shouvik. try it friend.

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.

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

thanks for all replies.
if you really got ur answer then mark this thread solved.

regards
Shouvik

hello Shouvik,
how can I mark this thead as solved?
my problem is solved

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