October 16th, 2012, 10:23 AM
Casting Time DateTime MySQL to C#
I have a MySQL data adapter and I am trying to query a table and place it in a DataSet. The problem I have is SOME of the time and DateTime values are being converted into C# TimeSpan variables rather than DateTime. I tried adding a CAST(timeVariable AS DATETIME) and the problem still exists. I tried to just import the Schema then change the data type in the dataset and this did not work either.
I am using the MySql.Data.MySqlClient objects to do the fill. Any Thoughts?
Tags for this Thread
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!