Decimal Numbers get changed to Integers

jdonahoe

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(conn2,CommandType.StoredProcedure,strCmd,sqlParms); 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?

4 Replies

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

hcontreras21y ago
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.
0
swilder22y ago
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.
0
p.jones22y ago
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.
0
swilder22y ago
We are having the same problem with singles and doubles. Were you able to solve this problem?
0