Formatting Money

[croydon]

I am reading from a SQL Server table and displaying a money amount in a label on the webpage.

I cannot get this to format correctly.

For example I can see a record with a money amount of 1245.0000 but when I display this in the label I cannot get to to show as 1,245.00

Any assistance would be appreciated. Thanks.

 

[jbenson001]

Use the front end app to format the value.

 

[jbenson001]

whoops sorry ignore that.. I thought I was in the sql server forum

 

[jbenson001]

A label doesn't have formatting masks, so you would have to do this manually. Or, you can get a third party control that will format and/or mask the data for you.

Jim

 

[croydon]

I have tried the following for example:

lblTotalAmountReal.Text = Format(dr
("amountReal"), "##0.00")

The result is 12450000.00

This should be 1245.00

As mentioned earlier, I can see this as a money value in the table as 1245.0000

 

[tperri]

lblTotalAmountReal.Text = Format(dr
("amountReal"), "{0:C}")

 

[jbenson001]

Try this as a test:

lblTotalAmountReal.Text = Format(1245.0000, "#,##0.00")

 

[adamroof]

this may not be the best way performance wise...but you have a couple options...

create a UDF (User Definded Function) in SQL..

CREATE FUNCTION [dbo].[FormatUSD] (@dollarValue DECIMAL(15, 2))
RETURNS VARCHAR(20)

AS

BEGIN

DECLARE @amount VARCHAR(20)

SET @amount = '$' + CONVERT(varchar(20),@dollarValue)

RETURN @amount

END


--usage
--SELECT id,dbo.FormatUSD(myMoney) FROM tblTable

or using the front end...

http://www.4guysfromrolla.com/aspfaqs/ShowFAQ.asp?FAQID=181

 

[ca8msm]

I would just use String.Format e.g.

        Dim l As Long = 1245.0
        Dim s As String = String.Format("{0:c}", l)

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[croydon]

Thanks for your suggestions.