Not sure-- Sqlserver? ASP.NET?

shaileshmark · August 7th, 2004, 09:01 PM

Guys, this is a simple question for you able programmers.
I have 4 decimal data type variables in my asp.net page:
amount, tax, shipping, total.
what is happening is that when tax is calculated as (amount * 6/100) and if the amount is 4.25, it calculates tax = .255 and if the shipping amount chosen was 2.50, the total amount comes to 7.005.

What I would like to be able to do is limit the tax result to 2 digits after the decimal so that .255 is .26 and 7.005 is 7.01. In fact .26 and 7.01 are what is displayed in my asp.net page as I have applied string formatting {0:c}. The trouble is in the database, .26 is stored as .255 and 7.01 as 7.005 and these values get passed on to my order processor that deems 7.005 as "invalid amount".

The database columns storing these values are of type money, 8. Is there any way I can manipulate the precision or scale of the values stored in these columns programmatically when they are calculated in the asp.net page? Thanks. Much appreciated -- I have learned a lot in this forum.

shaileshmark · August 7th, 2004, 09:55 PM

I think I will try the decimal.Round method. Hopefully, it will work. Let me know if you have any other ideas.

happygv · August 7th, 2004, 10:17 PM

Hi Shailesh,

You cannot alter Money datatype for to have only 2 digits after decimal. Instead you can use decimal datatype there - decimal(n,2)

OR

Code:

select cast(7.005 as decimal(5,2))

But, if you are specific about using money datatype there, you got to convert it when you retrieve it from the database.

Code:

DECLARE    @myVar money
SELECT    @myVar = 7.005
SELECT    CONVERT(varchar(10), @myVar, 1)

OR

Code:

SELECT CONVERT(varchar(10), MoneyColumn, 1) from YourTable

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

shaileshmark · August 9th, 2004, 02:37 PM

Hi Vijay:

Thanks for replying. In fact, the decimal.Round method seems to be working. I calculate tax first like tax = amount * 6/100 and then round off the result in the next line as tax = decimal.Round(tax, 2). so if in the first line tax is 2.555, the next line make it 2.6 and then inserts it as such in the database. I am using the same method in the amount calculation as well & it seems to be working -- basically, I just round it off before I make the call to store it in the database.

Thanks again for replying. It is all working now -- much appreciated.
Shailesh.

levitymn · July 7th, 2006, 10:52 AM

Decimal.Round() seems to have changed in .Net 2.0. The second parameter is no longer a specification of decimal places but an enumeration specifying how it will round to an integer. The MSDN documentation (http://msdn2.microsoft.com/en-us/lib...l_members.aspx) on the function states that the function is new in .net 2.0. So you should use System.Math.Round() to round your decimal values.

bonnythalli · August 9th, 2006, 08:33 AM

Ihave a display screen consisting of values ie : 93 that are not in decimals.
but when we wish to edit the button we find the values in decimal ie : 93.10
when we save the data value saved in database is in decimal ie: 93.10.

But the problem is.....

1...i want the value as 93 when edited.
2... i want the value stored in database as 93.10

here when the value is rounded from 93.10 to 93 the data is changed in database...

will u please solve me this problemmm...its very urgent.

in asp

bonny