Solved

Format currency in ASp.Net

Posted on 2007-04-02
17
1,163 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C#, asp.net MVC, sql server, LINQ 3 31
Please explain the parts of these 2 LINQ expressions 3 26
VB.NET 2008 Publish Error 2 24
location of a form 2 10
Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now