CheckBoxList check all

[prk72]

I'm not sure if this should be posted in the VB forum, the .NET forum or here. I know how to create a CheckBoxList, add items and have them checked or unchecked but my problem is I'm pulling the items from a database and don't know how to have them automatically checked. Can someone help with this? Thanks.

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<script runat="server">
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="Name" AutoPostBack="True"></asp:CheckBoxList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT DISTINCT [Name] FROM [tblName]"></asp:SqlDataSource>
</asp:Content>
 

[prk72]

Here is the answer:

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<script runat="server">
    Protected Sub CheckBoxList1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs)
        For Each item As ListItem In CheckBoxList1.Items
            item.Selected = True
        Next item
    End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:CheckBoxList ID="CheckBoxList1" runat="server"  AutoPostBack="true" DataSourceID="SqlDataSource1" 
                                                                             DataTextField="Name" 
                                                                             DataValueField="Name" 
                                                                             OnDataBound="CheckBoxList1_DataBound" />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT DISTINCT [Name] FROM [tblName]"></asp:SqlDataSource>
</asp:Content>