Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'

[Dan Reese]

I'm using a MySql SqlDataSource with the Rad Scheduler.

I loaded the page with the scheduler and clicked to add a new event, clicked insert and when the page reloaded I got this error:

Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.

I looked in the database and it inserted everything properly, but it looks like it cannot convert my start_time, end_time columns for the select of the Scheduler. 

Any ideas on how to make this work?

[Dimitar Milushev]

Hi Dan Reese,

Can you please open a support ticket and send us a sample project (along with a database) that reproduces the issue? This will greatly aid us in diagnosing the problem and providing a solution sooner.

Thank you for your understanding.

Kind regards,
Dimitar Milushev
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Dan Reese]

I realized that the column type was "timestamp" I changed to "DateTime" but now I am getting an error that it cannot convert MySql.DateTime to System.DateTime.

[Peter]

Hello Dan,

Here are some online aricles which discuss the problem and suggest possible workarounds:

http://www.tjitjing.com/blog/2007/04/unable-to-convert-mysql-datetime-value.html

http://lists.mysql.com/dotnet/295

http://mdid.org/mdidwiki/index.php?title=Talk:Unable_to_convert_MySQL_date/time_value_to_System.DateTime_exception



All the best,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center