Decimal Truncation using SqlParameter

Question

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...

hcontreras · Answer

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.

hcontreras · Answer

Did you ever resolve this issue? HCinMiami

rick_gabel · Answer

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_gabel · Answer

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).

miker · Answer

What data (data type and value) you supply there?