Decimal Numbers get changed to Integers

Question

I am using the Data Access Application Block for a data interface tier in my application. All data goes to and from the database (MSDE) without a problem except for decimal numbers which get stored as integers. I can set the numbers to decimal values using the Server Explorer but the next time I save them they are converted to integers again. I use the following command to update the database: SqlHelper.ExecuteNonQuery(conn2CommandType.StoredProcedurestrCmdsqlParms); The decimal numbers are passed into the method as follows: sqlParms[5] = new SqlParameter(@WeightPerPiece SqlDbType.Decimal 8); sqlParms[5].Value = 7.5; This is always stored as 8. What is wrong?

hcontreras · Answer

I resolved this by setting the database column's Scale to 2. Apparently when you create a decimal datatype SQL Server Enterprise Manager doesn't assume at least 2 decimal places. You have to set the Scale value in the bottom half of the window. Note setting it just in the code won't do.

swilder · Answer

We figured out that the data adaptor was incorrectly set to integer. The database column the data adapter and data set all have to be set to the same data types.

p.jones · Answer

You must first look in the database itself to ensure that the column is defined as decimal and with an adequate number of decimal places although there I would have expected truncation rather than rounding.

swilder · Answer

We are having the same problem with singles and doubles. Were you able to solve this problem?