By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,710 Members | 1,613 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,710 IT Pros & Developers. It's quick & easy.

sorting issue

P: n/a
I have several datagirds that allow sorting on two date columns. The sorting
works but its not showing the newest date first when I sort. For example

if I have dates in my column as

01/01/2008
12/01/2007
12/08/2007
02/02/2007
when I sort, I get it like
12/08/2007
12/01/2007
02/02/2007
01/01/2008
or like this:
01/01/2008
02/02/2007
12/08/2007
12/01/2007

what could be causing the sort to work as such? If I don't have a date such
as 01/01/2008, the sorting works correclty, its when the date is 01/01/2008
that its not sorting correctly. Any ideas on what may be causing this?
Jan 11 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Mike" <Mi**@yahoo.comwrote in message
news:uI**************@TK2MSFTNGP05.phx.gbl...
what could be causing the sort to work as such?
It's treating the date columns as pieces of text... This would be expected
behaviour if you are doing the sorting client-side, because it won't know
natively that the data to be sorted is a textual representation of a date
type...

How have you configured your DataGrid(s), specifically the column(s) in
question?

How are you doing the sorting?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 11 '08 #2

P: n/a
We're doing the sorting within the datagrid_sorting() method in the code
behind. The sorting has been working correctly, its just now with the
01/01/2008 dates in there, its not sorting correctly


"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:OL**************@TK2MSFTNGP05.phx.gbl...
"Mike" <Mi**@yahoo.comwrote in message
news:uI**************@TK2MSFTNGP05.phx.gbl...
>what could be causing the sort to work as such?

It's treating the date columns as pieces of text... This would be expected
behaviour if you are doing the sorting client-side, because it won't know
natively that the data to be sorted is a textual representation of a date
type...

How have you configured your DataGrid(s), specifically the column(s) in
question?

How are you doing the sorting?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 11 '08 #3

P: n/a
"Mike" <Mi**@yahoo.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>How are you doing the sorting?

We're doing the sorting within the datagrid_sorting() method in the code
behind.
Please post your code...
The sorting has been working correctly, its just now with the 01/01/2008
dates in there, its not sorting correctly
Almost certainly just a coincidence...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 11 '08 #4

P: n/a
I found it, the developer that created the stored procedures is passing all
the dates as text fields and not date fields.
I fixed it now.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:OX**************@TK2MSFTNGP03.phx.gbl...
"Mike" <Mi**@yahoo.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>How are you doing the sorting?

We're doing the sorting within the datagrid_sorting() method in the code
behind.

Please post your code...
>The sorting has been working correctly, its just now with the 01/01/2008
dates in there, its not sorting correctly

Almost certainly just a coincidence...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 11 '08 #5

P: n/a
"Mike" <Mi**@yahoo.comwrote in message
news:eM*************@TK2MSFTNGP06.phx.gbl...
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:OX**************@TK2MSFTNGP03.phx.gbl...
>"Mike" <Mi**@yahoo.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>>How are you doing the sorting?

We're doing the sorting within the datagrid_sorting() method in the code
behind.

Please post your code...
>>The sorting has been working correctly, its just now with the 01/01/2008
dates in there, its not sorting correctly

Almost certainly just a coincidence...

I found it, the developer that created the stored procedures is passing
all the dates as text fields and not date fields.
Aha... :-)
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 11 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.