How to Sort the DateTime Column in DataGridview

Question

0.00/5 (No votes)

See more:

Hi Guys , i was spent more on these requirement, but i doesn't get the answer.

I Have a DataGrid with columns Like BENCHMARKNO ,BENCHMARKNAME ,CLIENTCODE ,NOFILES ,REFERENCENO ,NORESOURCES ,STARTDATE, FINISHDATE, AUTHORIZEDBY.

Except STARTDATE and FINISHDATE Columns , Remaining all columns are sorted successfully.

I am getting the Date Formats like these

01-March-2010

05-February-2009

13-January-2009

07-July-2013

I Want like these :

13-January-2009
05-February-2009

01-March-2010

07-July-2013

Please any one help me.

Posted 20-Mar-13 1:32am

CH Guravaiah

Updated 20-Mar-13 1:33am

v2

Add a Solution

Comments

ZurdoDev 20-Mar-13 9:02am

Please post the relevant code for the sorting and your aspx columns of the datagrid.

Prasad Khandekar 20-Mar-13 17:22pm

Check whether startdate & finishdate columns in database are of correct data type and You have also specified the correct data type of respective columns in DataGridView. The error you are facing mostly occurs because of incorrect data type or a string value in column.

José Amílcar Casimiro 20-Mar-13 17:23pm

You get this order result, because the ordering of dates is being done by string type.
Sort for a different data type, or format the date in a way that the ordering is correct.

CH Guravaiah 21-Mar-13 2:48am

Starttime and finishtime are DateTime Datatype

José Amílcar Casimiro 21-Mar-13 5:55am

Probably the sorting operation is done by javascript (client-side), right ? This way your code is sorting the date column as string.

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)

Maciej Los · Answer 1 · 2013-03-21T11:00:00

I'm not sure what about you're asking for...

You can sort data in 2 methods:
1) using DataGridView properties: Sorting Data in WinForms DataGridView Control[^]
or
2) sorting its datasource:

SQL

SELECT Field1, Field2, ...
FROM YourDataBase
ORDER BY StartDate, EndDate

Date format has nothing to do with it.

Bob Murphy · Answer 2 · 2015-08-11T14:55:00

I did a lot of looking and then used something really easy. I added a hidden column, and put in a string date in the following format:
File.GetLastWriteTime(fl).ToString("yyyyMMddhhmm") and sorted the hidden column.
While I am using a file time there is no reason that any date/time should not work.

How to Sort the DateTime Column in DataGridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0