How to Format ItemTemplate True/False as Yes/No 1

[msmith425]

I'm reading information from a database and trying to format the boolean true/false as a yes/no.

Below is the code that I came up with but this is as far as I have gotten.

<aspataGrid id=&quot;DataGrid2&quot; runat=&quot;server&quot; AutoGenerateColumns=&quot;False&quot;>
<Columns>
<asp:BoundColumn DataField=&quot;JobNumber&quot; HeaderText=&quot;Job Number&quot;></asp:BoundColumn>
<asp:TemplateColumn HeaderText=&quot;Complete&quot;>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, &quot;Complete&quot %>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</aspataGrid>

How do I format the True/False as a Yes/No? Or is there another way that I have not heard of?

TIA
Marc

 

[Zarcom]

Make a function in your code behind. Call it FormatBoolean(arg as object). Cast the object to a boolean and check to see what it is. Depending on the value return a string of either &quot;Yes&quot; or &quot;No&quot;. In your aspx page finish off like so.
<%# FormatBoolean(DataBinder.Eval(Container.DataItem, &quot;Complete&quot) %>

Twill work like a charm. A charm I say.
That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[msmith425]

You know, it worked like a charm. A charm I tell you.

Much Thanks.

Marc