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

Question

Hi, i have a table in mysql database with with a column for date. It was working when i initially set it up. Using custom format in my form in visual studio. But i deleted all the columns in my table and then reordered them but the same columns. After then i start getting the error: {"Unable to convert MySQL date/time value to System.DateTime"}. I have set convert to zero time=true, yet it is still showing i have also change the default column value to NULL yet it is still showing. Please help me. Thanks