ASP.NET

sorting date column in gridview RSS

4 replies

Last post Jan 08, 2013 03:09 PM by sarathi125

‹ Previous Thread|Next Thread ›

- Reply
ujjwaladatta

Member

229 Points

59 Posts

sorting date column in gridview

Jan 08, 2013 11:55 AM|LINK

sorting functionality of the Date Column in Grid View is done alphanetical instead of chronologically,

Hot to sort in chronologically,

How have others achieved this?

Ujjwala Datta Kalluri
http://www.ujjwaladatta.wordpress.com
- Reply
aptbid2002

Member

244 Points

52 Posts

Re: sorting date column in gridview

Jan 08, 2013 12:22 PM|LINK

My guess is that you are using a text field with a string value for your column. Change the column type to date.
- Reply
kszymaniak

Member

205 Points

112 Posts

Re: sorting date column in gridview

Jan 08, 2013 01:29 PM|LINK

please check Column format in gridview but at first if you get date records from database check format column in database
- Edited by kszymaniak on Jan 08, 2013 01:33 PM
- Edited by kszymaniak on Jan 08, 2013 01:33 PM
- Reply
oned_gk

All-Star

31511 Points

6431 Posts

Re: sorting date column in gridview

Jan 08, 2013 02:42 PM|LINK
make sure the sort expression come from field that using datetime datatype, not from formated datetime

Programming to simplify, dont look for hard way
- Edited by oned_gk on Jan 08, 2013 02:44 PM
- Marked as answer by decker dong - msft on Jan 14, 2013 05:48 AM
- Reply
sarathi125

Star

13599 Points

2691 Posts

Re: sorting date column in gridview

Jan 08, 2013 03:09 PM|LINK

Hi,

Check this link

http://stackoverflow.com/questions/4104912/sort-on-date-column-gridview

Parthasarathi,
Remember to click Mark as Answer on the post that helps to others.

My Blog :MyAspSnippets