Format string by CultureInfo

Question

I want to show pound sign and the format 0.00 i.e £45.00, £4.10 . I am using the following statement:

<td style="text-align:center"><%# Convert.ToString(Convert.ToSingle(Eval("tourOurPrice")) / Convert.ToInt32(Eval("noOfTickets")), new System.Globalization.CultureInfo("en-GB")) %></td>

But it is not working. What is the problem.

Can any one help me???

adrianbanks · Accepted Answer · 2011-05-25T19:57:01.323

107

Use the Currency standard format string along with the string.Format method that takes a format provider:

string.Format(new System.Globalization.CultureInfo("en-GB"), "{0:C}", amount)

The CultureInfo can act as a format provider and will also get you the correct currency symbol for the culture.

Your example would then read (spaced for readability):

<td style="text-align:center">
    <%# string.Format(new System.Globalization.CultureInfo("en-GB"), 
                      "{0:C}", 
                      Convert.ToSingle(Eval("tourOurPrice")) 
                             / Convert.ToInt32(Eval("noOfTickets")))
    %>
</td>

edited May 25 '11 at 19:57

answered Aug 12 '09 at 13:30

adrianbanks

81,306
22
176
206

Does this actually work? Your are applying a culture to a string, which I don't think will have any affect. – Joe Cartano May 25 '11 at 17:58
This is what I tried: string foo = String.Format(new System.Globalization.CultureInfo("en-GB"), "{0:C}", Convert.ToString(3.01)); – Joe Cartano May 25 '11 at 19:23
@Joe: ah, I see what you're referring to now. I've updated my answer to correct it. – adrianbanks May 25 '11 at 19:55

Patrick McDonald · Answer 2 · 2009-08-12T13:27:08.990

3

How about

<%# (Convert.ToSingle(Eval("tourOurPrice")) / Convert.ToInt32(Eval("noOfTickets"))).ToString("C", New System.Globalization.CultureInfo("en-GB")) %>

edited Aug 12 '09 at 13:27

answered Aug 12 '09 at 13:21

Patrick McDonald

64,141
14
108
120

score 1 · Answer 3 · edited Nov 14 '12 at 15:55

1

Try specify exact currency format

String.Format(...CultureInfo("en-GB"), "{0:C}"....

edited Nov 14 '12 at 15:55

Steve Czetty

6,147
9
39
48

answered Aug 12 '09 at 13:20

Dewfy

23,277
13
73
121

score 1 · Answer 4 · answered Aug 12 '09 at 13:27

1

This should work:

<td style="text-align:center">
<%# String.Format( new System.Globalization.CultureInfo("en-GB"), "{0:c}", Convert.ToSingle(Eval("tourOurPrice")) / Convert.ToInt32(Eval("noOfTickets")) %>
</td>

answered Aug 12 '09 at 13:27

Phaedrus

8,351
26
28

score 1 · Answer 5 · answered Sep 27 '13 at 17:38

I wanted to add an additional related answer to show how to use a cloned CultureInfo object in a string.Format() or StringBuffer.AppendFormat(). Instead of currency though, my need was to format the AM/PM designator for my employer's style guide. Here is what I did:

var culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();
culture.DateTimeFormat.AMDesignator = "a.m.";
culture.DateTimeFormat.PMDesignator = "p.m.";
....
var msg = new StringBuilder();
msg.AppendFormat(culture,"Last modified: {0:M/d/yyyy h:mm tt}", ad.DateModified);

You can do the same thing with string.Format():

string strMsg = string.Format(culture, "Last modified: {0:M/d/yyyy h:mm tt}", ad.DateModified);

Format string by CultureInfo

5 Answers5

Linked

Related