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.
Thanks Jx_Man,
I have done just that.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.