DataFormatString for currency?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kat - 09 Jul 2007 05:08 GMT

I have tried to set a gridview column to have a dataformatstring of {0:c2},
{0:c},{0:d2, {0:d}, none of which work, my values are still displaying as
19.0000. I want it to be 19.00 like any normal currency. Thank you for
your help.

Reply to this Message

martin marinov - 09 Jul 2007 08:53 GMT

Hello Kat,

Are you sure that your seetings for the currency use dot for delimiter?

Martin

> I have tried to set a gridview column to have a dataformatstring of
> {0:c2}, {0:c},{0:d2, {0:d}, none of which work, my values are still
> displaying as 19.0000. I want it to be 19.00 like any normal
> currency. Thank you for your help.

Reply to this Message

Kat - 09 Jul 2007 15:10 GMT

Not sure what you mean, when I use currency formats in other programs, such
as Excel, it works fine. What should I check?

> Hello Kat,
>
[quoted text clipped - 6 lines]
>> displaying as 19.0000. I want it to be 19.00 like any normal
>> currency. Thank you for your help.

Reply to this Message

marss - 10 Jul 2007 08:04 GMT

> Not sure what you mean, when I use currency formats in other programs, such
> as Excel, it works fine. What should I check?

You did everything right. But there is a feature that is poorly
described in guides. If you want to use DataFormatString then you have
to set
HtmlEncode to false.

<asp:BoundField .... HtmlEncode="False" DataFormatString="${0:C2}"/>

Regards, Mykola
http://marss.co.ua

Reply to this Message

DataFormatString for currency?

Free Magazines