Failed to convert parameter value from a TimeSpan to a DateTime

Question

Hi,

I am using SQL Server 2008.

First I gave SqlDbType.Time for System.TimeSpan to the parameter type for Insert and Update.

I works successfully.

Now I changed to DbType.Time instead of SqlDbType.Time. Which gave me the error message "Failed to convert parameter value from a TimeSpan to a DateTime" which didn't call the "Procedure"

Thanks,

Babu Kumarasamy

Answer 1

This is a confirmed bug in the current version of ADO.Net. Until, the next release, you need to use SqlDbType.Time.