ASP.Net Label show Yes or No for a bit field and handle nulls

I have an page that displays the answers to questions. The data is in a SQL Server 2008 database as a bit field. If the answer is true, I want to display "Yes" and false show "No". What I have is below:
<asp:label ID="test" runat="server" Text='<%# Eval("Field").ToString() == "True" ? "Yes":"No" %>'
This shows either Yes or No, but the problem is that if the field is not answered (it's null), then it shows No. I want it to display nothing. Can this be done? I'm using C# and VS 2008. Thanks.
Who is Participating?
Fernando SotoConnect With a Mentor RetiredCommented:
Hi dodgerfan;

Try it like this see it works.

<asp:label ID="test" runat="server" Text='<%# Eval("Field").ToString() == "True" ? "Yes": Eval("Field").ToString() == "False" ? "No" : "" %>'

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.