Re: What changed with MySqlDbType.Datetime?

[Chris Cline]

From what I can gather the new DateTime type is causing the following not to function as it should.

This assumes you have a table that has a DateTime column and your using 4.1 Mysql with the 1.0.2 .Net Connector.

Calling DataAdapter.Fill() causes an casting exception.

or setting DataTable.Columns["yourcolun"].defaultvalue = DataTime.Today; causes a casting exception

or using parameters and passing a valid System.DateTime value into it gets an exception.

I have even seen this problem if I fill a datatable, bind it to a datagrid and try to update the datetime column.

It might be all related to the same thing...no idea unless a go digging around in the code.