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
