DataFormatStrin g in GridView does not work??

[Hardy Wang]

Hi, I have a GridView control in my web form (ASP.NET 2.0)

<asp:GridView ID="gvReport" runat="server" AllowSorting="T rue"
AutoGenerateCol umns="False"
Width="100%">
<HeaderStyle CssClass="ItemC aption" />
<RowStyle CssClass="Line" />
<AlternatingRow Style CssClass="AltLi ne" />
<Columns>
<asp:BoundFie ld DataField="Item Name" HeaderText="Ite m
Name" SortExpression= "ItemName" />
<asp:BoundFie ld DataField="Purc haseDate"
DataFormatStrin g="{0:F}" HeaderText="Pur chase Date"
SortExpression= "PurchaseDa te" />
<asp:BoundFie ld DataField="Cost "
DataFormatStrin g="{0:c}" HeaderText="Cos t"
SortExpression= "Cost" />
<asp:BoundFie ld DataField="Unit Price"
DataFormatStrin g="{0:c}" HeaderText="Uni t Price"
SortExpression= "UnitPrice" />
<asp:BoundFie ld DataField="Quan tity"
HeaderText="Qua ntity" SortExpression= "Quantity" />
</Columns>
</asp:GridView>

I want to format the output of "Cost" and "UnitPrice" columns to display in
currency format, thus I added DataFormatStrin g="{0:c}" to column
declaration. Does it suppose to show the result of these two columns like
"$1,000.00" , "$0.99"? But actually what I can get is all "1000.0000" ,
"0.9900"!
I created a dummy function in this web page to run string s =
cost.ToString(" C"); the output is currect.
Anything wrong with GridView?
Regards
Hardy

[Hardy Wang]

OK, I found solution, I must set HtmlEncode="fal se" to enable formatting.
"Hardy Wang" <ha*******@hotm ail.com> wrote in message
news:eq******** *****@TK2MSFTNG P10.phx.gbl...

Hi, I have a GridView control in my web form (ASP.NET 2.0)

<asp:GridView ID="gvReport" runat="server" AllowSorting="T rue"
AutoGenerateCol umns="False"
Width="100%">
<HeaderStyle CssClass="ItemC aption" />
<RowStyle CssClass="Line" />
<AlternatingRow Style CssClass="AltLi ne" />
<Columns>
<asp:BoundFie ld DataField="Item Name" HeaderText="Ite m
Name" SortExpression= "ItemName" />
<asp:BoundFie ld DataField="Purc haseDate"
DataFormatStrin g="{0:F}" HeaderText="Pur chase Date"
SortExpression= "PurchaseDa te" />
<asp:BoundFie ld DataField="Cost "
DataFormatStrin g="{0:c}" HeaderText="Cos t"
SortExpression= "Cost" />
<asp:BoundFie ld DataField="Unit Price"
DataFormatStrin g="{0:c}" HeaderText="Uni t Price"
SortExpression= "UnitPrice" />
<asp:BoundFie ld DataField="Quan tity"
HeaderText="Qua ntity" SortExpression= "Quantity" />
</Columns>
</asp:GridView>

I want to format the output of "Cost" and "UnitPrice" columns to display
in currency format, thus I added DataFormatStrin g="{0:c}" to column
declaration. Does it suppose to show the result of these two columns like
"$1,000.00" , "$0.99"? But actually what I can get is all "1000.0000" ,
"0.9900"!
I created a dummy function in this web page to run string s =
cost.ToString(" C"); the output is currect.
Anything wrong with GridView?
Regards
Hardy