default value for checkbox in a datagrid.

[Asha]

greetings,
i'm loading a datagrid and my gird has checkbox, i want these checkboxex to
be check based on the value from the db? can someone please show me the code
for it? thanks

[Ken Cox [Microsoft MVP]]

Depending on your data, you might be able to use an IIF statement inline to
indicate whether the checkbox is checked:

<asp:DataGrid id="DataGrid1" runat="server">
<Columns>
<asp:TemplateCo lumn HeaderText="Boo lean Value">
<ItemTemplate >
<asp:CheckBox id=match runat="server" onCheckedChange d="updateStatus "
Checked='<%# DataBinder.Eval (Container, "DataItem.Boole an") %>'
AutoPostBack="T rue">
</asp:CheckBox>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Boo lean Value">
<ItemTemplate >
<asp:CheckBox id="Checkbox1" runat="server"
onCheckedChange d="updateStatus " Checked='<%# IIF(DataBinder. Eval(Container,
"DataItem.Boole an"),"true","fa lse") %>' AutoPostBack="T rue">
</asp:CheckBox>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Boo lean Value">
<ItemTemplate >
<asp:Label id="Label1" runat="server"> <%#
IIF(DataBinder. Eval(Container, "DataItem.Boole an"),"Yes","No" )
%></asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>

Ken
MVP [ASP.NET]
"Asha" <As**@discussio ns.microsoft.co m> wrote in message
news:7F******** *************** ***********@mic rosoft.com...

greetings,
i'm loading a datagrid and my gird has checkbox, i want these checkboxex
to
be check based on the value from the db? can someone please show me the
code
for it? thanks

[Shiva]

Option 1 - Used the Checked attribute of the checkbox.
<ItempTemplat e>
<asp:Checkbox RunAt=Server Id="chkActive" Checked='<%# DataBinder.Eval
(Container.Data Item, "<col_name> ") %>' />
</ItempTemplate>
Here, checkbox is checked based on the <col_name> column

Option 2 - Use an utility function.
<ItempTemplat e>
<asp:Checkbox RunAt=Server Id="chkActive" Checked='<%#
IsActive(DataBi nder.Eval (Container.Data Item, "<col_name> ")) %>' />
</ItempTemplate>
IsActive is a protected method (can be any name) in the page returning True
or False based on the parameter passed.

Well, the 3rd option is to use ItemDateBound event of the grid.

HTH.

"Asha" <As**@discussio ns.microsoft.co m> wrote in message
news:7F******** *************** ***********@mic rosoft.com...
greetings,
i'm loading a datagrid and my gird has checkbox, i want these checkboxex to
be check based on the value from the db? can someone please show me the code
for it? thanks