FN-FORUM: .Net Quezzie

date posted 10th January 2005 15:16

Hi All

Having a problem with .Net datatypes and am wondering if any of you good
folks can shed some light on the problemo for me.

I have a sql server stored procedure that accepts a parameter of type float.
I am using the Parameters collection of the Command object to pass this
value as SqlDbType.Float, and the corresponding variable in VB.net is of
type Double. However, I keep getting an error saying "Invalid Cast from
Double to DateTime" when I try to run the code to run the stored proc. The
value that is supposed to be inserted is 199.99.

Any ideas what the problem is? Do I need to do some data conversion prior to
running the stored proc?

Any help much appreciated.
Caz


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.9 - Release Date: 06/01/2005