Format to currency an unbound value in a Gridview.

Question

3.00/5 (1 vote)

See more:

Just wondering how to format an unbound value in a Gridview to currency?
The numbers I want to format are derived from client side script.

Posted 29-Jan-12 13:47pm

Andrew Chambers

Updated 29-Jan-12 15:00pm

v2

Add a Solution

Comments

daniele.arrighi 29-Jan-12 20:04pm

What do you mean with "unbound value"?

Sergey Alexandrovich Kryukov 29-Jan-12 20:17pm

We know what is it, don't worry :-)
The question is correct and appropriate.
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2012-01-29T14:12:00

Please see the part of MSDN documentation of numeric format string: http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx[^].

Locate the section "The Currency ("C") Format Specifier" and search by the keyword "currency" through all of this text for code samples, specification and related information.

Also, pay attention for dependency on the culture, which can be defined by a current thread culture or specified explicitly. Please see:
http://msdn.microsoft.com/en-us/library/system.string.format.aspx[^],
http://msdn.microsoft.com/en-us/library/1ksz8yb7.aspx[^].

In the second of the articles mentioned above, pay attention for using of CultureInfo which implements the interface IFormatProvider; for the usage, see the code samples.

[EDIT]

As with currency formatting always depends on particular cultures, see also:
http://msdn.microsoft.com/en-us/library/ie/c6zyy3s9.aspx[^].

For thread culture, see:
http://msdn.microsoft.com/en-us/library/system.threading.thread.currentculture.aspx[^],
http://msdn.microsoft.com/en-us/library/system.threading.thread.currentuiculture.aspx[^].

—SA

Wonde Tadesse · Accepted Answer · 2012-01-29T14:27:00

Solution 2

I'm not sure what did you mean by "unbound value in Gridview", but one option to format fields in UI side will be to use DataFormatString property of BoundField[^]. For example

HTML

<asp:BoundField HeaderText="Price/Unit"
                DataField="UnitPrice" SortExpression="UnitPrice"
                DataFormatString="{0:c}">

will format UnitPrice field of the GridView to Currency. For lists of different DataFormatString ,have a look at this[^] MSDN article.

Posted 29-Jan-12 14:27pm

Wonde Tadesse

Comments

thatraja 29-Jan-12 21:15pm

Right, 5!

Wonde Tadesse 29-Jan-12 21:29pm

Thanks

Sergey Alexandrovich Kryukov 29-Jan-12 22:03pm

Sure, a 5. And I actually explained where to get format strings in my answer.
--SA

Wonde Tadesse 29-Jan-12 22:18pm