«

Hi,

How do you set the checked property for checkbox column in a datagrid? The
SimpleYn is a bit column value in the database. When I try it, I'm getting a
cast error. Thanks.

<asp:TemplateColumn HeaderText="Sample">
<ItemTemplate>
<asp:CheckBox ID="Sample"
Checked='<%# DataBinder.Eval(Container.DataItem, "SampleYn")%>'
runat="server" />
</ItemTemplate>
</asp:TemplateColumn>

call a function there
try this
<asp:CheckBox ID="Sample" Checked='<%#
ToBool(DataBinder.Eval(Container.DataItem, "SampleYn")) %>' runat="server"
/>

and create function ToBool that will convert the bit value to bool. Or try
to onvert it inline Cnvert.ToBool(DataBinder.Eval(Container.DataItem,
"SampleYn")).

Hope this helps.

"Dave" <> wrote in message
news:5F2B38D1-3A96-4DAE-A168-...
> Hi,
>
> How do you set the checked property for checkbox column in a datagrid?
> The
> SimpleYn is a bit column value in the database. When I try it, I'm
> getting a
> cast error. Thanks.
>
> <asp:TemplateColumn HeaderText="Sample">
> <ItemTemplate>
> <asp:CheckBox ID="Sample"
> Checked='<%# DataBinder.Eval(Container.DataItem, "SampleYn")%>'
> runat="server" />
> </ItemTemplate>
> </asp:TemplateColumn>