Bind asp:SqlDataSource with CheckBoxList and RadioButtonList (VB.net) : SqlDataSource « ADO.net Database « ASP.NET Tutorial

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="CheckAndRadio.aspx.vb" Inherits="CheckAndRadio" %>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource 
             ID="SqlDataSource1" 
             runat="server" 
             ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT * FROM [Books]"></asp:SqlDataSource>
    
    </div>
        CheckBoxList:
        <asp:CheckBoxList ID="CheckBoxList1" 
                          runat="server" 
                          DataSourceID="SqlDataSource1"
                          DataTextField="Title" 
                          DataValueField="BookID">
        </asp:CheckBoxList><br />
        RadioButtonList:<br />
        <asp:RadioButtonList ID="RadioButtonList1" 
                             runat="server" 
                             DataSourceID="SqlDataSource1"
                             DataTextField="Title" 
                             DataValueField="BookID">
        </asp:RadioButtonList><br />
        <asp:Button ID="Button1" runat="server" Text="Click Me!" />
        <br />
        <br />
        <asp:Label ID="results" runat="server"></asp:Label>
    </form>
</body>
</html>


File: CheckAndRadio.aspx.vb

Partial Class CheckAndRadio
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        results.Text = String.Empty

        For Each li As ListItem In CheckBoxList1.Items
            If li.Selected Then
                results.Text &= li.Text & "<br/>"
            End If
        Next

        results.Text &= "<br/><br/><hr/>"


        If RadioButtonList1.SelectedItem IsNot Nothing Then
            results.Text &= RadioButtonList1.SelectedItem.Text
        End If
    End Sub
End Class

18.8.SqlDataSource
	18.8.1.	Connection to a mdf file
	18.8.2.	Connecting to Microsoft SQL Server
	18.8.3.	asp:SqlDataSource select command with parameters
	18.8.4.	Specify column from asp:SqlDataSource
	18.8.5.	Use connection string in asp:SqlDataSource and set the DeleteCommand and SelectCommand
	18.8.6.	Configure two asp:SqlDataSource with different SelectCommand
	18.8.7.	Executing Stored Procedures
	18.8.8.	Filtering Database Rows
	18.8.9.	Retrieves the records from the database by using a DataReader
	18.8.10.	Handling SQL Command Execution Errors
	18.8.11.	Handle the exception at the level of a DataBound control.
	18.8.12.	Canceling Command Execution when Deleting, Filtering, Inserting, Selecting, Updating
	18.8.13.	Using ASP.NET Parameters with the SqlDataSource Control
	18.8.14.	Declare each of the parameters used when executing the update command.
	18.8.15.	Using the ASP.NET ControlParameter Object to represent the value of a control property.
	18.8.16.	Show Page Control Parameter
	18.8.17.	Using the ASP.NET CookieParameter Object
	18.8.18.	Using the ASP.NET FormParameter Object
	18.8.19.	Using the ASP.NET ProfileParameter Object
	18.8.20.	Using the QueryStringParameter Object
	18.8.21.	Using the SessionParameter Object
	18.8.22.	Caching Database Data with the SqlDataSource Control
	18.8.23.	Link asp:GridView with asp:SqlDataSource
	18.8.24.	Bind asp:SqlDataSource with CheckBoxList and RadioButtonList (VB.net)
	18.8.25.	Link asp:DropDownList with asp:SqlDataSource
	18.8.26.	SqlDataSource with dynamic parameter