sorting of dates in ascending order

Question

0.00/5 (No votes)

See more:

Dear FRIENDS,

am working on ASp.NET, C#, SQLSERVER2005.

I have a GRIDVIEW on my Webpage and a dropdownlist. I have a column in that GRidview as Date Valid From

I used to SORT the DATES in Ascending Order from 2011 - 2012

My columns is as displays

DateValidFrom
===============================

01\01\2011
01\01\2011
01\02\2011
03\02\2011
03\04\2012 -
05\04\2012 -
03\03\2011
01\02\2011
03\02\2011
03\04\2012 -
05\04\2012 -
03\03\2011
04\04\2011

I need to arrange it in Ascending order. it should display from 2011 - 2012. when date validfrom ITEM Selected from dropdownlist.

Please help.

Posted 5-Aug-12 22:03pm

Ubaid ur Rahman IT

Add a Solution

Comments

dimpledevani 6-Aug-12 4:06am

If you are using datatable as a datasource to your gridview then use the dataview's sort method and try it

2 solutions

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)

AshishChaudha · Answer 1 · 2012-08-05T22:26:00

Solution 2

You can sort your date by using query itself..try simple sql query.
[updated]

SQL

select * from [table name] order by convert(nvarchar,DateValidFrom,103)

Thanks
Ashish

Posted 5-Aug-12 22:26pm

AshishChaudha

Updated 5-Aug-12 22:32pm

v2

Comments

Ubaid ur Rahman IT 6-Aug-12 4:31am

what is datefrom here

Ubaid ur Rahman IT 6-Aug-12 4:31am

is it column name ?

AshishChaudha 6-Aug-12 4:33am

its your column name..I have updated

Ubaid ur Rahman IT 6-Aug-12 4:53am

This is my query

SqlDataAdapter dad3 = new SqlDataAdapter("select ClearanceNumber, CodeFlightId, DateLastChange, DateValidFrom,"
+ "DateValidTo, ReservationNo, AircraftType, CityCode, Days from Flight order by DateValidFrom", con);

Please help

AshishChaudha 6-Aug-12 4:54am

SqlDataAdapter dad3 = new SqlDataAdapter("select ClearanceNumber, CodeFlightId, DateLastChange, DateValidFrom," + "DateValidTo, ReservationNo, AircraftType, CityCode, Days from Flight order by convert(nvarchar,DateValidFrom,103)", con);

Ubaid ur Rahman IT 6-Aug-12 4:54am

how to write your query in my query ......please help.

Ubaid ur Rahman IT 6-Aug-12 5:56am

My dear Friend, this is not sorting.........First it displays 2012 records and while paging on another pages 2011, 2012.....its not sorted....Please help

AshishChaudha 6-Aug-12 6:08am

First clarify your question. Have you defined paging in your gridview????? According to you please tell me what sorting means????

Ubaid ur Rahman IT 6-Aug-12 6:55am

yes, i have defined paging in my GRIDVIEW. I need dates in ascending order I have lot of 2011 and 2012 records in my GRIDVIEW.

also I have a dropdownlist above GRIDVIEW, when i select Datevalidfrom from dropdownlist.......... DATEVALIDFROM column must be Sorted

Please Please Please help.

Thanks in ADVANCE.

Ubaid ur Rahman IT 6-Aug-12 6:59am

First Display 2011 records and then 2012 records.....see this, I need Exactly like this

01\01\2011
01\01\2011
02\01\2011
16\01\2011
26\01\2011
31\01\2011
02\01\2012 -
05\01\2012
06\01\2012
11\01\2012
15\01\2012
11\02\2012

AshishChaudha 6-Aug-12 8:07am

SqlDataAdapter dad3 = new SqlDataAdapter("select ClearanceNumber, CodeFlightId, DateLastChange, DateValidFrom," + "DateValidTo, ReservationNo, AircraftType, CityCode, Days from Flight order by year(DrpDatevalidfrom.SelectedText.Trim())", con);

It will surely work..

AshishChaudha 7-Aug-12 2:50am

Is this issue solved???

Sangramsingh Pawar · Answer 2 · 2012-08-05T22:18:00

Solution 1

why don't you get sorted data from database ?

add

SQL

order by date

to your select query

Posted 5-Aug-12 22:18pm

Sangramsingh Pawar

Updated 5-Aug-12 22:19pm

v2

Comments

Ubaid ur Rahman IT 6-Aug-12 4:26am

already i have use dataviews sort method.........but its not sorting

Sangramsingh Pawar 6-Aug-12 4:37am

use this in your database query it will work.