GridView data format (w/ HtmlEncode="false")

[tfowler]

I have no idea why my GridView fields are ignoring my data format string. As you can see, Ive tried both a TemplateField and a BoundField, and neither will show the data as formatted:

[VB]
<form id="form1" runat="server">
<asp:GridView ID="gvWafer" runat="server" Font-Size="XX-Small"
AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="13">
<ItemTemplate>
<asp:LabelID="lblCol13"runat="server"
Text=<%# bind("col13", "{0:n0}") %>>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundFieldDataField="col14"DataFormatString="{0:n0}"
HeaderText="14"HtmlEncode="False"/>
</Columns>
</asp:GridView>
</form>
[/VB]

The DataSet is filled from the following XML file:

[size=2][color=#0000ff]<?[/color][/size][size=2][color=#a31515]xml[/color][/size][size=2][color=#ff0000]version[/color][/size][size=2][color=#0000ff]=[/color][/size][size=2]"[/size][size=2][color=#0000ff]1.0[/color][/size][size=2]"[/size][size=2][color=#ff0000]standalone[/color][/size][size=2][color=#0000ff]=[/color][/size][size=2]"[/size][size=2][color=#0000ff]yes[/color][/size][size=2]"[/size][size=2][color=#0000ff]?>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#a31515]WaferMap[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#a31515]Map[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]	 <[/color][/size][size=2][color=#a31515]col13[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]53.0744[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col13[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]	 <[/color][/size][size=2][color=#a31515]col14[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]56.0382[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col14[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]	 <[/color][/size][size=2][color=#a31515]col15[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]59.3042[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col15[/color][/size][size=2][color=#0000ff]>
[size=2][/size]	 <[/color][/size][size=2][color=#a31515]col16[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]63.2966[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col16[/color][/size][size=2][color=#0000ff]>
[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]Map[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]<[/color][/size][size=2][color=#a31515]Map[/color][/size][size=2][color=#0000ff]>[/color][/size][/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]	 <[/color][/size][size=2][color=#a31515]col13[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2][color=#000000]54.6394[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col13[/color][/size][size=2][color=#0000ff]>
[size=2][color=#0000ff][size=2][color=#0000ff][/color][/size][/color][/size]	 <[/color][/size][size=2][color=#a31515]col14[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2][color=#000000]57.8624[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col14[/color][/size][size=2][color=#0000ff]>
[size=2][color=#0000ff][size=2][color=#0000ff][/color][/size][/color][/size]	 <[/color][/size][size=2][color=#a31515]col15[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2][color=#000000]61.3318[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col15[/color][/size][size=2][color=#0000ff]>
[size=2][color=#0000ff][size=2][color=#0000ff][/color][/size][/color][/size]	 <[/color][/size][size=2][color=#a31515]col16[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2][color=#000000]65.6252[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]col16[/color][/size][size=2][color=#0000ff]>
[/color][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#a31515]Map[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]					:[/color][/size]
[size=2][color=#0000ff]					:
[/color][/size][/color][/size][size=2][color=#0000ff]<[/color][/size][size=2][color=#a31515]WaferMap[/color][/size][size=2][color=#0000ff]>[/color][/size]

Thanks for any help,

Todd

 

[MrPaul]

Bad format string?

If the data is being displayed, but not formatted correctly, then obviously the fields are being bound correctly, but there may be a problem with the actual format string. I expect the curly braces notation is unnecessary here, and would recommend you try just "n0".

Good luck

 

[tfowler]

You are correct that the data is being displayed, but not formatted.

Thanks for your suggestion, but using DataFormatString="n0", gives me exactly that...the "n0" string is displayed in all of the cells in the column.

This is extremely annoying. Formatting data in a grid column should be a simple request. I know Ive had this work in the past. I did install the Visual Studio 2005 SP1 Beta...I wonder if it has anything to do with it? I doubt it, but I havent been able to find anything else that would cause the problem.

Thanks,

Todd