DataFormatString for Boolean column

Question

I have a gridview with dynamic datasource.

I add column in codebehind .

BoundField col=new BundField(); 
col.DataField="Active";
col.DataFormatString=//DataFormatString;
gridview1.Columns.Add(col);

How do set yes/no for boolean column ?

Answer 1

I use this code for VB:

<asp:TemplateField HeaderText="Active" SortExpression="Active">
    <ItemTemplate><%#IIf(Boolean.Parse(Eval("Active").ToString()), "Yes", "No")%></ItemTemplate>
</asp:TemplateField>

And this should work for C# (untested):

<asp:TemplateField HeaderText="Active" SortExpression="Active">
    <ItemTemplate><%# (Boolean.Parse(Eval("Active").ToString())) ? "Yes" : "No" %></ItemTemplate>
</asp:TemplateField>