Solved

Format currency in ASp.Net

Posted on 2007-04-02
17
1,189 Views
Last Modified: 2008-01-09
I found this link and been trying to format the text displayed to currency but not getting the right format:
http://msconline.maconstate.edu/tutorials/ASPNET2/ASPNET07/aspnet07-01.aspx
I want:
$48,300.00, $615,23.00 , $0.80 , $39.00

This is what I have and what i've tried:
DataTextFormatString={0:#,#.##} -- 48300,00 --> 48.300
                                   615,23 -> remains the same
                                   0,80 --> ,8
                                   39,00 --> 39

Tried:{0:$#,#.##} : same results except it has $
Tried : {0:0.00} : goes back to orig #s that have commas . Ex: 48300,00
Tried : (0:C} . With this 48,300 shows as : 48.300,0

what to do?
0
Comment
Question by:Camillia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
17 Comments
 
LVL 67

Expert Comment

by:sirbounty
ID: 18836943
Why not use the function FormatCurrency?

txtValue.Text=FormatCurrency(YourCurrency, 2)
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837077
i'm binding to a gridview, If I want to use FormatCurrecny, I have to do it in itemdatabound event??
0
 
LVL 25

Accepted Solution

by:
dstanley9 earned 500 total points
ID: 18837085
What culture is the server using?  FormatCurrency will use the format defiend by the system's culture (presumably the same format that {0:C} uses.

Try

={0:'$'#,##0.00}

The zero placeholders will dispaly a 0 if there is no digit there, the # will not.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 25

Expert Comment

by:dstanley9
ID: 18837089
Also the $ will display the currency defined by the system.  If the system does not define a currency symbol, none will be used.
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837145
no, that didnt do it either. I think I have to use FormatString.

The culture in my browser is english-US.

I dont want to display the "$".  (i just realized it). I just want to display the value correctly:
12,999.89 for example..

I think I have to use FormatString...but in itemdatabound??
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837158
if I dont want the "$", I think i have to use FormatNumber...but again, in itemdatabound?
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18837171
It's the culture on the _server_ that is used, not in the browser.

If you don't  want the currency symbol, just use ={0:#,##0.00}
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18837205
You shouldn't have to use FormatNumber.  DataTextFormatString should format it the way you want if you use the right string.

FormatNumber will also use the settings in the _server's_ control panel.  So it will use commas instead of decimal points based on your examples above.
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837241
***************does NOT format it correctly. I just tried it: *****************

If you read my orig post, i've tried several things and still no.  *** I want to try FormatNumber but since i'm binding to gridview, I think i have to do the formatting in itemdatabound****

I tired your last suggestion :
48300,00  shows up at 48.300,00
39,00 still shows up as 39,00 instead of 39.00
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837259
just saw your other msg:

"FormatNumber will also use the settings in the _server's_ control panel"...where do I check that??
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18837604
Start-->Control Panel-->Regional and Language Options
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18837625
OK So the , and . placeholders must use the regional settings as well.  
0
 
LVL 7

Author Comment

by:Camillia
ID: 18837960
ah, this is what I see:

For currecny : $123,456,789.00
and for number : 123,456,789.00

Still dont understand why 48300,00  shows up as 48.300,00
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18838092
Hmm.  The site is not changing the culture of the thread someplece else, is it?
0
 
LVL 7

Author Comment

by:Camillia
ID: 18838180
I can step thru the code but i dont think so. I just get the total in the stored proc and bind it... this is what i used in the aspx page, in the gridview:
{0:#,##0.00}

just noticed it...that does have a "dot" in it...after the second zero and before the double zeros. is that why??
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 18839288
The format code tells .NET to use groupings of 3 separated by a comma (The ##0 between the comma and . define the grouping size.  The first zero says to make sure that at least one digit is displayed to the left of the decimal (even if it's a zero) and the two zeros on the right of the decimal tell it to always show two digits to the right of the decimal (even if one or both are zeros).

Something must be changing either the culture or the default NumberFormatInfo.  Double.ToString() Uses the default NumberFormatInfo to convert to a string.  You can look at System.Globalization.NumberFormatInfo.CurrentInfo
and System.Threading.Thread.CurrentCulture in the debugger and see what culture and separator characters are being used.
0
 
LVL 7

Author Comment

by:Camillia
ID: 18839388
i'll track it down and see what's going on. Will post back.
0

Featured Post

Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question