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.
