Converting bit false to string No in Datagrid column

[stuart]

Hi there

I have a dataset bound to a datagrid and the dataset/datagrid has a column bound to a bit field in a sql server database
The problem I'm having is the datagrid is displaying 'True' and 'False', where I want it to display 'Yes' and 'No'. How can I do this?
If this is not possible, how do I bind this column to a list of checkbox controls within the datagrid

Cheers

 

[Ken Cox [Microsoft MVP]]

Hi Stuart,

You might be able to change the text in the label like this:

<asp:TemplateColumn HeaderText="Boolean Value">
<ItemTemplate>
<asp:Label id="Label1" runat="server"><%#
IIF(DataBinder.Eval(Container, "DataItem.Boolean"),"Yes","No")
%></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>

Does this help?

Ken
Microsoft MVP [ASP.NET]

 

[Ken Cox [Microsoft MVP]]

Glad to help!

Hi Ken,

You rock my world.....

Both of the suggestions you gave me were spot on!

Thanks

Hi Stuart,

You might be able to change the text in the label like this:

<asp:TemplateColumn HeaderText="Boolean Value">
<ItemTemplate>
<asp:Label id="Label1" runat="server"><%#
IIF(DataBinder.Eval(Container, "DataItem.Boolean"),"Yes","No")
%></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>

Does this help?

Ken
Microsoft MVP [ASP.NET]