This template column should show forecolor as red when the bit
datafield 'SIG' is true.


<asp:TemplateColumn HeaderText="Area">
<ItemStyle HorizontalAlign="left"></ItemStyle>
<ItemTemplate>
<asp:HyperLink runat="server" ForeColor='<%#
IIf(DataBinder.Eval(Container.DataItem, "SIG"), "red","black") %>'
Text='<%# DataBinder.Eval(Container, "DataItem.AREA_NAME") %>'
ID="Hyperlink1">
</asp:HyperLink>
</ItemTemplate>
</asp:TemplateColumn>

I've checked the data - no nulls, error msg is : specified cast is not
valid. Definately the forecolor since if I remove it it runs fine.
Thanks for all help !

You are limited in data binding expressions. You can bind to any public
field or property on the containing page or on the server control's
immediate naming container available as Container.DataItem. IIf statement is
neither of them.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


"dodgeyb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This template column should show forecolor as red when the bit
> datafield 'SIG' is true.
>
>
> <asp:TemplateColumn HeaderText="Area">
> <ItemStyle HorizontalAlign="left"></ItemStyle>
> <ItemTemplate>
> <asp:HyperLink runat="server" ForeColor='<%#
> IIf(DataBinder.Eval(Container.DataItem, "SIG"), "red","black") %>'
> Text='<%# DataBinder.Eval(Container, "DataItem.AREA_NAME") %>'
> ID="Hyperlink1">
> </asp:HyperLink>
> </ItemTemplate>
> </asp:TemplateColumn>
>
> I've checked the data - no nulls, error msg is : specified cast is not
> valid. Definately the forecolor since if I remove it it runs fine.
> Thanks for all help !
>

I'm always using the iif function in datagrid template cols ?!, and
this is the first prob I've encoutered. How do you do conditional
formatting ?
Thanks & regards
Chris

Ok, I am not good with VB.

What is the type of the "SIG" field? Apparently, IIf expects the first
parameter to be boolean and DataBinder.Eval(Container.DataItem, "SIG")
doesn't not evaluate to a boolean.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


"dodgeyb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm always using the iif function in datagrid template cols ?!, and
> this is the first prob I've encoutered. How do you do conditional
> formatting ?
> Thanks & regards
> Chris
>