display descending order column in datagridview. ?

Question

3.50/5 (2 votes)

See more:

hi experts

how to display descending order in datagridview, the order must start from after last character.
this is my column in datagridvie
ex: 1)ap20aa4779
2)ap09ss9999
3)se06ps1136
my desendeing order must start from after last character, im getting values from db.

it's like this
1)ap09ss9999
2)ap20aa4779
3)se06ps1136

thanks in advance

Posted 12-Jun-12 1:04am

sandeep nagabhairava

Updated 12-Jun-12 1:16am

v2

Add a Solution

Comments

Prasad_Kulkarni 12-Jun-12 7:06am

Why you don't do it in your database?

sandeep nagabhairava 12-Jun-12 7:14am

how can i do that. im using msAccess2007 accdb. can u please send quary?

Vani Kulkarni 12-Jun-12 7:10am

I second Prasad. This needs to be done in database.

2 solutions

Solution 1

Please get table from database in descending order

Query select * from tablename order by coloumname desc

Posted 12-Jun-12 1:25am

Upniwesh

Comments

sandeep nagabhairava 12-Jun-12 7:28am

i need descending order after last character in a string..
ap09ss9999
ap20aa4779
se06ps1136

Upniwesh 12-Jun-12 7:46am

select * from tablename order by reverse(Coloumnname) desc
Try this

sandeep nagabhairava 12-Jun-12 7:52am

select TokenNo,VehicleNo,InTime from ScooterInOut where TokenStatus=0
my quarry was like this .how can i get those order..

Upniwesh 12-Jun-12 7:54am

for which column based you want sorting...........

sandeep nagabhairava 12-Jun-12 9:26am

vehicleNo

Upniwesh 12-Jun-12 9:29am

select TokenNo,VehicleNo,InTime from ScooterInOut order by reverse(vehicleNo) desc where TokenStatus=0

sandeep nagabhairava 14-Jun-12 1:51am

this query working grate while working with sql,but it's not working on ms accesses.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Upniwesh · Accepted Answer · 2012-06-12T01:45:00

Solution 2

select * from tablename order by reverse(Coloumnname) desc

Posted 12-Jun-12 1:45am

Upniwesh