MySQL unable to convert MySQL datetime value to System.DateTime solution

Unable to convert MySQL date/time value to System.DateTime solution

This problem occurs in MySQL data has date type data, in C # query out when the type of time inconsistent and caused!

Looked online, found there are two kinds of solutions:

1. Add "Allow Zero datetime=true" to the connection string;

con = new Mysqlconnection ("server=localhost;database=test; charset=gb2312;pooling=false;port=3306; Uid=root; Pwd=pwd; Allow Zero datetime=true ");

This is a once and for all, a precautionary approach, added to the end of the tube.

2. When using a statement with query data, add cast (date as Char) to convert:

eg (for example): Select CAST (field name as Char) from Tbl_tes

MySQL unable to convert MySQL datetime value to System.DateTime solution