Sort Date in Grid

[Former Member]

Hi All,

   How to Sort Date Column in Grid?

Code:

oGrid.Columns.Item(ColIndex).TitleObject.Sortable = True

It works fine ,not for Date Column,

In Date Col

01/10/2015

10/10/2015

02/10/2015

03/10/2015

04/10/2015

05/10/2015

06/10/2015

07/10/2015

08/10/2015

09/10/2015

But  i need like this  when I click Date Column Header.

01/10/2015

02/10/2015

03/10/2015

04/10/2015

05/10/2015

06/10/2015

07/10/2015

08/10/2015

09/10/2015

10/10/2015

Please how to solve this?

[former_member241304]

Hi Lakshmi Narayanan,

-when we load the data in grid Automatically we will get the date in Order only right.  

-or else through  sql means go through the below link

sql - Order by descending date - month, day and year - Stack Overflow 

Regards,

P.Pallavi

[Former Member]

Hi Pallavi,

I already check this , I used it. but it is only loading time. But I need to Click Header of Date column, I need it.

   How to do this.? Please help me.

[Former Member]

HI Lakshmi,

Data are coming from which dataobject (DataTable?)?

You're sure data type of column is Date, not string?

Regards,

Eric

[Former Member]

Hi ERIC,

  thanks for reply. Yes

It is a DAtATABLE.

DataType is a Date Column .

please help me.How to Solve this