format Boundcolumn as Percentage

[RobbRoss]

I have a datagrid with Boundcolumns. I have a number in the db that represents a percentage. I want the datagrid column to output the percentage and not the number. For example instead of 0.82 I want 82%.

 

[Ken Cox [Microsoft MVP]]

You can use a custom format with "p".

<Columns>
<asp:BoundColumn DataField="Percentvalue" ReadOnly="True"
HeaderText="Percentvalue" DataFormatString="{0}"></asp:BoundColumn>
</Columns>

See also here:

http://www.datawebcontrols.com/faqs/CustomizingAppearance/FormatNumericData.shtml

Ken
Microsoft MVP [ASP.NET]

 

[Jos]

I have a datagrid with Boundcolumns. I have a number in the db that

represents a percentage. I want the datagrid column to output the
percentage and not the number. For example instead of 0.82 I want 82%.

Set the DataFormatString property for the BoundColumn to {0:##.00%}
like this:
<asp:BoundColumn DataField="MyNumberField" DataFormatString="{0:##.00%}">

More formatting options here:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconnumericformatstrings.asp

Jos