请将Convert Zero Datetime = True和Allow Zero Datetime = True添加到连接字符串。

Hi


In my application i have inserted ''Date'' into MySql database in MySql datetime(yyyyMMdd) format. Now in another application, i wants to select that date and some other fields and bind it to the datalist control. But it shows me the following error, "Unable to convert MySql.DateTime to System.DateTime". How can i convert MySql.DateTime to System.DateTime.

Please add Convert Zero Datetime=True and Allow Zero Datetime=True to your connection string.