Decimal Truncation using SqlParameter

rick_gabel

Trying to store/retrieve records containing Decimal fields and the numbers are being rounded to a whole number. Using C#, ADO(MDAC 2.8), and SQL Server 2000. I am setting the Precision and Scale (18, 2) on the SqlParameter and having no luck with the retrieval or inserting numeric fields with a fractional value. Any ideas would be greatly appreciated. Thanks...

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

hcontreras21y ago
Resolved the issue on my own. Note: when I created a decimal datatype via SQL Server Enterprise Manager, I didn't realize that I had to set the Scale (the number of decimal places) myself. It doesn't assume 2 places. I set the Scale to 2, and didn't have to change my code at all.
hcontreras21y ago
Did you ever resolve this issue? HCinMiami
rick_gabel22y ago
Okay... I changed the datatype of the column to Money since I am using the field as a currency value. Retrival seems to work now but the insert is still causing a rounding problem (trying to insert 50.65 and 51 is stored, try to insert 12.34 and 12 is stored). Using SqlParameter("colName", SqlDbType.Money); Rick
rick_gabel22y ago
The SQL Server2000 column is defined as a decimal(18, 2). When creating the SqlCommand, I am adding a SqlParameter field that is defined as follows: parm = new SqlParameter("colname", SqlDbType.Decimal) parm.Precision = 18; parm.Scale = 2; parm.Direction = ParameterDirection.Output; After the query runs, assigning Value to the C# ref variable (defined as decimal).
miker22y ago
What data (data type and value) you supply there?