Display alternate text in datagrid

[Jason .]

I have a datagrid that has a boundcolumn to my database:

<asp:BoundColumn DataField="IndustryPercentile" HeaderText="Industry"
DataFormatString="{0:###}%">
</asp:BoundColumn>

When a IndustryPercentile value is not available, the data returned is
-1. I would like to display "n/a" when the IndustryPercentile is -1.
How can I do this?

 

[Eliyahu Goldin]

Handle ItemDataBound event. If the cell text = "-1", replace it with "n/a".

Eliyahu