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
--
Alan Silver
(anything added below this line is nothing to do with me)

[Darren Kopp]

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

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

[Alan Silver]

In article <11**********************@g47g2000cwa.googlegroups .com>,
Darren Kopp <da********@gmail.com> writes

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

--
Alan Silver
(anything added below this line is nothing to do with me)

[Darren Kopp]

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

[Alan Silver]

In article <11*********************@o13g2000cwo.googlegroups. com>,
Darren Kopp <da********@gmail.com> writes

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

No, it gave $23.9

--
Alan Silver
(anything added below this line is nothing to do with me)

[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]

In article <11**********************@o13g2000cwo.googlegroups .com>,
Darren Kopp <da********@gmail.com> writes

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

--
Alan Silver
(anything added below this line is nothing to do with me)

[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/ar.../25/12871.aspx

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke
"Darren Kopp" <da********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Is the HtmlEncode property set to true for the field?

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

[Alan Silver]

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

In article <#A**************@TK2MSFTNGP09.phx.gbl>, Teemu Keiski
<jo****@aspalliance.com> writes

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

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

--
Alan Silver
(anything added below this line is nothing to do with me)

[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
*** Sent via Developersdex http://www.developersdex.com ***