Slide 11.7: Creating a dynamic checkbox list (cont.)

Creating a Dynamic Checkbox List (Cont.)

This example contains one page, WebForm1.aspx, which includes the following tools:

Two TextBoxes with IDs “title” and “studentName,”
Two Buttons with IDs “Add” and “Reset,”
One SqlDataSource with the ID “enrollment” to connect to the database,
One CheckBoxList with ID “courseList” and one ListItem inside the CheckBoxList, and
One Label with ID “Result” to show the course selection.

Note that the CheckBoxList is different from CheckBox, which has no DataSourceID property, so it is not able to receive data from a database. The following is a simplified source code of the WebForm1.aspx:

(Simplified) WebForm1.aspx

01<%@ Page Language="C#" AutoEventWireup="true"
02  CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication3.WebForm1" %>
03<!DOCTYPE html>
04<html xmlns="http://www.w3.org/1999/xhtml">
05 <body>
06  <form id="form1" runat="server">
07 
08   Dynamic Checkboxes
09   <asp:Label ID="Label2" runat="server" Text="Course title:"></asp:Label>
10   <asp:TextBox ID="title" runat="server" Width="203px"></asp:TextBox>
11   <asp:Button ID="Add" runat="server" OnClick="Add_Click" Text="Add" />
12   <asp:Label ID="Label3" runat="server" Text="Student name:"></asp:Label>
13   <asp:TextBox ID="studentName" runat="server" Width="159px"></asp:TextBox>
14   <asp:Label ID="Label4" runat="server" Text="Course list:"></asp:Label>
15   <asp:Button ID="Reset" runat="server" Text="Reset" />
16 
17   <asp:SqlDataSource ID="enrollment" runat="server"
18    ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
19    ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
20    SelectCommand="SELECT [title] FROM [Courses] ORDER BY [title]">
21   </asp:SqlDataSource>
22 
23   <asp:CheckBoxList ID="courseList" runat="server" DataSourceID="enrollment"
24    DataTextField="title" DataValueField="title" AutoPostBack="True">
25    <asp:ListItem></asp:ListItem>
26   </asp:CheckBoxList>
27 
28   <asp:Label ID="Result" runat="server"></asp:Label>
29  </form>
30 </body>
31</html>