String was not recognized as a valid TimeSpan.

[pmourfield]

Good morning everyone. I am trying to use a RadTimePicker to insert a time into a database column with data type of time(7). However, when I try to do this, I get the following error "String was not recognized as a valid TimeSpan." Any ideas?

[pmourfield]

I have found the answer. In the parameters for the sql data source I was using DbType="Time". I switched this from "Time" to "String" type and everything is inserting fine.

[ihsojsakiv]

Hey I am using Sqlserver 2008 R2 and using  time(7) to store time format.

its working proper in my apps. try to use it.

Attendance.EarlyIn = Convert.ToDateTime(CheckInTime.Duration().ToString()).TimeOfDay;

Cheers
Vikas Joshi
Software Engineer