Double vs MSSQL Decimal
Posted on 2006-05-14
I seem to have a problem when inserting and updating data in an MSSQL database.
I have declared 3 variables:
Dim var1 as double
dim var2 as double
In the database there is a table named Table1 that has 3 coulumns
TID --> Integer (Primary Key)
C1 --> Decimal (Precision 2)
C2 --> Decimal (Precision 2)
Now when I try to insert or update those 2 doubles to the database I receive an error.
It seems that .NET updates a double like 11,24
MSSQL on his side only seems to accept the format 11.24
Can you help me with this?