Binding RadTimePicker to SQL 2008 Time Data Type

[AP]

How can I bind the RadTimePicker to a SQL Server 2008 Time field? It would see the logical choice of control, but when I do, I get the error:-

Cannot convert value of parameter 'Time' from 'System.DateTime' to 'Nullable<System.TimeSpan>'

Is there a work around,or plans to support this in the future? 

[AP]

I've solved the issue, but it's a hack. It would be much nicer to have the RadTimePicker support TimeSpans directly. Is this a planned update? If not, can it be requested?

The solution was to intercept teh form view insert, using the ItemInserting event, and change the datatype:-

protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e)
       {

           //turn datetime to timespan
           DateTime ds = (DateTime)e.Values["Time"];
           TimeSpan ts = ds.TimeOfDay;
           e.Values["Time"] = ts.ToString();
       }

[Vasil]

Hello AP,

You can see an example how to bind datepicker to database here:
http://demos.telerik.com/aspnet-ajax/calendar/examples/datepicker/databinding/defaultcs.aspx
Actually it uses pretty much the same workaround. But currently we are not planning to change this behavior. It is a general issue with binding nullable types from the database. The DatePicker itself uses DateTime type which is standard type in .Net. And this ensures that all users could easily manipulate with it and bind it to various datasources, even if sometimes they will need to cast it first.

Regards,
Vasil
the Telerik team