Formatting a GridBoundColumn

[David]

Hi,

I was wondering if it is to possible to make some "advance" formatting on a GridBoundColumn. In fact, I want to show a number with always and only one digit (ex : 197,1 - 197,0 - 197,8). The best I come to is to show a digit if this digit isn't a 0 (so, it look like 197,1 - 197 - 197,8). I try with a GridNumericColumn,but no luck. So, here is my code 

<telerik:GridBoundColumn DataField="test" HeaderText="test" UniqueName="test"
DataFormatString="{0:$###.#}" />

Is anyone may help me please ?

Thank you,
David

PS: I'm now wondering if it is a better solution if I just override the DataFormatString propriety, cause I'm now using a override GridTemplateColumn, so I will just have to plug the override propriety in. So, if anyone know how to correctly override DataFormatString, please let's me know how.

[Vasil]

Hello David,

DataFormatString should work fine for formatting the value. If you have some problems, you could test it with DataBinder.Eval in a template column. If it works with Eval, then we could surch for problems with non-applying the format string from DataFormatString property.

<telerik:GridTemplateColumn>
    <ItemTemplate>
        <%# Eval("test", "value of 'test' is: {0:f2} ")%>
    </ItemTemplate>
</telerik:GridTemplateColumn>

Also make that database field is correct type. It should be decimal or real

Kind regards,
Vasil
the Telerik team

[David]

Hey,

Thank you