How can I format a number column in a datagrid

[Arne]

I tried
<asp:BoundColumn DataField="Logins" HeaderText="Logins"
DataFormatString="{#,##.0}"></asp:BoundColumn>

But it blows up.
Is there a better way.

 

[Eliyahu Goldin]

http://msdn.microsoft.com/library/d...rolsBoundColumnClassDataFormatStringTopic.asp

Eliyahu

 

[Arne]

Eliyahu,
That didn't work for me.
Arne.

http://msdn.microsoft.com/library/d...rolsBoundColumnClassDataFormatStringTopic.asp

Eliyahu

 

[Eliyahu Goldin]

Then do it in code behind in either ItemDataBound or PreRender event. Get
the cell value and apply formatting string of your choice in ToString
method.
For formatting strings look at
http://msdn.microsoft.com/library/d...uide/html/cpconcustomnumericformatstrings.asp

Eliyahu

 

[Arne]

Eliyahu,
I had read the two above help files prior to posting my news item. After
having read you first post a second time I came up with
<asp:BoundColumn ItemStyle-HorizontalAlign="Right" DataField="Logins"
HeaderText="Logins" DataFormatString="{0:N0}"></asp:BoundColumn>
Arne