List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:December 10 2004 3:26am
Subject:RE: MySqlDateTime in Datatables sorting by Text, not Date.
View as plain text  
I fixed this and marked the bug report closed.  Thanks!

> -----Original Message-----
> From: Barry Zubel [mailto:barry@stripped]
> Sent: Monday, December 06, 2004 3:43 AM
> To: dotnet@stripped
> Subject: MySqlDateTime in Datatables sorting by Text, not Date.
> 
> Okay, an odd one that I've probably managed to screw up myself (tee hee).
> 
> The following extracted code should reproduce the problem:
> (parts removed for brevity)
> 
> sSql = "SELECT DATECOLUMN, SOMEOTHERFIELD FROM YOURTABLE ORDER BY
> SOMEOTHERFIELD ASC"
> (where DATECOLUMN is a DATE or DATETIME Mysql Type, SOMEOTHERFIELD can be
> anything)
> 
> ...
> (instantiate connector, command, and dataadapter and fill datatable with
> results)
> ...
> 
> myDataGrid.DataSource = myDataTable
> 
> 
> Now the important thing is to have source data that spans several months.
> When the datagrid is displayed, simply click on the DATECOLUMN column
> header
> to resort by date ascending or descending.
> 
> I have found that the DataTable actually seems to text-sort, instead of
> date-sort.
> 
> For example, The dates:
> 
> 01/10/2004
> 01/11/2004
> 02/10/2004
> 02/11/2004
> 
> Will appear IN THAT ORDER, instead of the more logical (and expected):
> 
> 01/10/2004
> 02/10/2004
> 01/11/2004
> 02/11/2004
> 
> (Based on the UK date format, which is DD/MM/YYYY)
> 
> This has occurred since Beta 2, (I believe - I've not confirmed this yet)
> but I'd like someone else to verify that this is the case before I post
> something to the mysql bugzilla.
> 
> Ta muchly!
> 
> B.
> 
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1


Thread
MySqlDateTime in Datatables sorting by Text, not Date.Barry Zubel6 Dec
  • RE: MySqlDateTime in Datatables sorting by Text, not Date.Reggie Burnett10 Dec
    • RE: MySqlDateTime in Datatables sorting by Text, not Date.Barry Zubel10 Dec
      • Totally off topic -- Using Bitkeeper with SVGuy Platt10 Dec
        • RE: Totally off topic -- Using Bitkeeper with SVReggie Burnett10 Dec
      • RE: MySqlDateTime in Datatables sorting by Text, not Date.Reggie Burnett10 Dec