Databinder.Eval passed as argument is choking

[TJ]

I have a datagrid that has a boolean column. The sql data is a bit stored
as a 1 or 0. Doing a straight up DataBinder.Eval(Container.DataItem,
"MyColumn") displays a "True" or "False" in the grid. No problems here.

What I want is for it to display a "Yes" or "No". So I'm using a
TemplateColumn instead of a BoundColumn so I can pass the value into a
function and return a string that says Yes or No. My problem is that the
function won't take the value seemingly no matter how I cast or don't cast
the argument when I send or in the receiving mechanism of the function.

In the aspx page:

<asp:TemplateColumn HeaderText="Approved">
<ItemTemplate>
<%# FormatYesOrNo(DataBinder.Eval(Container.DataItem, "MyBitColumn")) %>
</ItemTemplate>
</asp:TemplateColumn>

In the code behind:
public string FormatYesOrNo(bool x)
{
string z = "Yes";
if (x != true)
z = "No";
return z;
}

I tried casting the late bound info the aspx to a bool (e.g.
(bool)DataBinder.Eval...), but that didn't work. I tried changing the
FormatYesOrNo(bool x) in the code behind to FormatYesOrNo(string x) and
changing the guts accordingly, but that didn't work.

Any help appreciated.

-TJ

[Elton Wang]

Try following:

<asp:TemplateColumn HeaderText="Approved">
<ItemTemplate>
<%# (DataBinder.Eval(Container.DataItem, "MyBitColumn")) ? "Yes" : "No" %>
</ItemTemplate>
</asp:TemplateColumn>

HTH

"TJ" <teejay@newsgroups.nospam> wrote in message
news:%23Mtyo7azFHA.3408@TK2MSFTNGP09.phx.gbl...

>I have a datagrid that has a boolean column. The sql data is a bit stored
>as a 1 or 0. Doing a straight up DataBinder.Eval(Container.DataItem,
>"MyColumn") displays a "True" or "False" in the grid. No problems here.
>
> What I want is for it to display a "Yes" or "No". So I'm using a
> TemplateColumn instead of a BoundColumn so I can pass the value into a
> function and return a string that says Yes or No. My problem is that the
> function won't take the value seemingly no matter how I cast or don't cast
> the argument when I send or in the receiving mechanism of the function.
>
> In the aspx page:
>
> <asp:TemplateColumn HeaderText="Approved">
> <ItemTemplate>
> <%# FormatYesOrNo(DataBinder.Eval(Container.DataItem, "MyBitColumn")) %>
> </ItemTemplate>
> </asp:TemplateColumn>
>
> In the code behind:
> public string FormatYesOrNo(bool x)
> {
> string z = "Yes";
> if (x != true)
> z = "No";
> return z;
> }
>
> I tried casting the late bound info the aspx to a bool (e.g.
> (bool)DataBinder.Eval...), but that didn't work. I tried changing the
> FormatYesOrNo(bool x) in the code behind to FormatYesOrNo(string x) and
> changing the guts accordingly, but that didn't work.
>
> Any help appreciated.
>
> -TJ
>
>
>
>
>

[TJ]

I get this now:
"CS0029: Cannot implicitly convert type 'object' to 'bool'"

Seems closer. Thought it was a bool to begin with. I'm just reading a bit
datatype column from a SQL Server 2K table.

"Elton Wang" <elton_wang@hotmail.com> wrote in message
news:%23gLpaQbzFHA.3892@TK2MSFTNGP12.phx.gbl...

> Try following:
>
> <asp:TemplateColumn HeaderText="Approved">
> <ItemTemplate>
> <%# (DataBinder.Eval(Container.DataItem, "MyBitColumn")) ? "Yes" : "No" %>
> </ItemTemplate>
> </asp:TemplateColumn>
>
> HTH
>
> "TJ" <teejay@newsgroups.nospam> wrote in message
> news:%23Mtyo7azFHA.3408@TK2MSFTNGP09.phx.gbl...

>>I have a datagrid that has a boolean column. The sql data is a bit stored
>>as a 1 or 0. Doing a straight up DataBinder.Eval(Container.DataItem,
>>"MyColumn") displays a "True" or "False" in the grid. No problems here.
>>
>> What I want is for it to display a "Yes" or "No". So I'm using a
>> TemplateColumn instead of a BoundColumn so I can pass the value into a
>> function and return a string that says Yes or No. My problem is that the
>> function won't take the value seemingly no matter how I cast or don't
>> cast the argument when I send or in the receiving mechanism of the
>> function.
>>
>> In the aspx page:
>>
>> <asp:TemplateColumn HeaderText="Approved">
>> <ItemTemplate>
>> <%# FormatYesOrNo(DataBinder.Eval(Container.DataItem, "MyBitColumn")) %>
>> </ItemTemplate>
>> </asp:TemplateColumn>
>>
>> In the code behind:
>> public string FormatYesOrNo(bool x)
>> {
>> string z = "Yes";
>> if (x != true)
>> z = "No";
>> return z;
>> }
>>
>> I tried casting the late bound info the aspx to a bool (e.g.
>> (bool)DataBinder.Eval...), but that didn't work. I tried changing the
>> FormatYesOrNo(bool x) in the code behind to FormatYesOrNo(string x) and
>> changing the guts accordingly, but that didn't work.
>>
>> Any help appreciated.
>>
>> -TJ
>>
>>
>>
>>
>>

>
>

[TJ]

Nevermind...got it:

((bool)DataBinder.Eval(Container.DataItem, "AJGApproved")) ? "Yes" : "No"

Just had to add the final casting touch. : )

Thank you so much!



"Elton Wang" <elton_wang@hotmail.com> wrote in message
news:%23gLpaQbzFHA.3892@TK2MSFTNGP12.phx.gbl...

> Try following:
>
> <asp:TemplateColumn HeaderText="Approved">
> <ItemTemplate>
> <%# (DataBinder.Eval(Container.DataItem, "MyBitColumn")) ? "Yes" : "No" %>
> </ItemTemplate>
> </asp:TemplateColumn>
>
> HTH
>
> "TJ" <teejay@newsgroups.nospam> wrote in message
> news:%23Mtyo7azFHA.3408@TK2MSFTNGP09.phx.gbl...

>>I have a datagrid that has a boolean column. The sql data is a bit stored
>>as a 1 or 0. Doing a straight up DataBinder.Eval(Container.DataItem,
>>"MyColumn") displays a "True" or "False" in the grid. No problems here.
>>
>> What I want is for it to display a "Yes" or "No". So I'm using a
>> TemplateColumn instead of a BoundColumn so I can pass the value into a
>> function and return a string that says Yes or No. My problem is that the
>> function won't take the value seemingly no matter how I cast or don't
>> cast the argument when I send or in the receiving mechanism of the
>> function.
>>
>> In the aspx page:
>>
>> <asp:TemplateColumn HeaderText="Approved">
>> <ItemTemplate>
>> <%# FormatYesOrNo(DataBinder.Eval(Container.DataItem, "MyBitColumn")) %>
>> </ItemTemplate>
>> </asp:TemplateColumn>
>>
>> In the code behind:
>> public string FormatYesOrNo(bool x)
>> {
>> string z = "Yes";
>> if (x != true)
>> z = "No";
>> return z;
>> }
>>
>> I tried casting the late bound info the aspx to a bool (e.g.
>> (bool)DataBinder.Eval...), but that didn't work. I tried changing the
>> FormatYesOrNo(bool x) in the code behind to FormatYesOrNo(string x) and
>> changing the guts accordingly, but that didn't work.
>>
>> Any help appreciated.
>>
>> -TJ
>>
>>
>>
>>
>>

>
>