Rounding Issues

[mickeybaez]

Need Help! I am new to asp.net and I am having problems inserting proper data into SQL Server 2000. I have a field named salary with the datatype of decimal.

When I insert a value into the textbox (17.52) it rounds up (18) or down depending on value using bankers rounding. How do I get the 17.52 value inserted and retrieved into and from the database correctly. Do I have to do some special casting. I do not want to lose the cents neither up or down. Also, I tried using the currency datatype and it places 4 digits at the end of my number in the user interface. I only want to have it look like 17.52 not 17.5200.

I would appreciate any suggestions.

Thanks!

[Plater]

How did you declare your column?
Decimal(18,0) is equiv to an 18 digit integer
The format goes
Decimal( [total digits before and after the point], [max total digits after the decimal])

So if you wanted say money, you could use
Decimal(20,2) so you could have 18digits then a decimal point then 2 digits.

Try that?

[mickeybaez]

Need Help! I am new to asp.net and I am having problems inserting proper data into SQL Server 2000. I have a field named salary with the datatype of decimal.

When I insert a value into the textbox (17.52) it rounds up (18) or down depending on value using bankers rounding. How do I get the 17.52 value inserted and retrieved into and from the database correctly. Do I have to do some special casting. I do not want to lose the cents neither up or down. Also, I tried using the currency datatype and it places 4 digits at the end of my number in the user interface. I only want to have it look like 17.52 not 17.5200.

I would appreciate any suggestions.

Thanks!

I was able temporarily fix my problem by declaring the datatype as a float. I am able to see the proper formating in my grid as well as storing the proper number in my DB.

Thanks

[mickeybaez]

How did you declare your column?
Decimal(18,0) is equiv to an 18 digit integer
The format goes
Decimal( [total digits before and after the point], [max total digits after the decimal])

So if you wanted say money, you could use
Decimal(20,2) so you could have 18digits then a decimal point then 2 digits.

Try that?

Thanks for your help, I had it declared decimal (9,2) I fixed the problem by using the float datatype. It seems to be doing the trick both on the db and also on the user interface grids. Your example above is accurate. If you had scale to 0 then you would have a integer.