0

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

5
Contributors
11
Replies
12
Views
9 Years
Discussion Span
Last Post by sammy_eyison
0

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>

0

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

0

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

Should have specidied, u're right, sorry.

0

Hello Folks,

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

0

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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.