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
(where DATECOLUMN is a DATE or DATETIME Mysql Type, SOMEOTHERFIELD can be
(instantiate connector, command, and dataadapter and fill datatable with
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
For example, The dates:
Will appear IN THAT ORDER, instead of the more logical (and expected):
(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.