DataFormatString not working in GridView

[Alan Silver]

Hello,

I have a GridView control, and am unsuccessfully trying to format a
column to show costs. The (simplified) code is as follows...

<asp:GridView ID="grdCustomers" DataSourceID="dtaCustomers"
AutoGenerateColumns="false" runat="server">
<Columns>
<asp:BoundField DataField="Total" DataFormatString="&pound;{0:F2}" />
</Columns>
</asp:GridView>

As you can see, I have set the DataFormatString to "&pound;{0:F2}",
which should give them a Pound sign, followed by the value with two
decimal places (like you would expect a cost to look).

The problem is that the numbers are not being formatted correctly. I
have things like $23.9 (where I have changed the pound sign to a dollar
sign to ensure it shows up right in Usenet). This should show as $23.90,
with the extra zero.

Any ideas? TIA

 

[Darren Kopp]

try DataFormatString = &pound; {0:0.00}, but what you have should
work...

HTH,
Darren Kopp
http://blog.secudocs.com/

 

[Alan Silver]

try DataFormatString = &pound; {0:0.00}, but what you have should
work...

Thanks for the suggestion, but that didn't work either.

It worries me when you say what I have should work!! Is there anything
else I can check to see why it isn't. Thanks again

 

[Darren Kopp]

And you said that {0:c} gave you $23.90 right?

 

[Alan Silver]

And you said that {0:c} gave you $23.90 right?

No, it gave $23.9

 

[Darren Kopp]

What is the datatype of "Total" (.NET data type or Database data type)

-Darren

 

[Darren Kopp]

What is the datatype of "Total" (.NET data type or Database data type)

-Darren

 

[Alan Silver]

What is the datatype of "Total" (.NET data type or Database data type)

It's a computed field that comes from an SQL expression like...

select sum(priceeach*quantity) from siteorders...

where "priceeach" is a float and "quantity" is an int.

Thanks

 

[Darren Kopp]

Is the HtmlEncode property set to true for the field?

-Darren Kopp
http://blog.secudocs.com/

 

[Teemu Keiski]

That's the solution. here's also an explanation:

GridView & DataFormatString in post beta 2
http://aspadvice.com/blogs/joteke/archive/2005/09/25/12871.aspx

 

[Alan Silver]

Ah ha! That fixed it. Thanks for the reply.

That's the solution. here's also an explanation:

GridView & DataFormatString in post beta 2
http://aspadvice.com/blogs/joteke/archive/2005/09/25/12871.aspx

 

[Darren Kopp]

Cool, glad to hear that you got it working.

Happy .NETing
Darren Kopp,
http://blog.secudocs.com/

 

[Chop Hofilena]

Your DataFormatString should work just set HtmlEncode to false