CSharp Bind Data Source To Asp:Checkboxlist – ADO.Net Database

<%@ Page Language="VB" %>
<script runat="server">
        Function AllPublishers() As System.Data.SqlClient.SqlDataReader
            Dim connectionString As String = "server='(local)\NetSDK'; trusted_connection=true; Database='pubs'"
            Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
 
            Dim queryString As String = "SELECT [publishers].* FROM [publishers]"
            Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
 
            sqlConnection.Open
            Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
 
            Return dataReader
        End Function
 
    Sub Page_Load(sender As Object, e As EventArgs)
      Page.DataBind()
    End Sub</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <p>
            <asp:CheckBoxList id="CheckBoxList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:CheckBoxList>
        </p>
        <p>
            <asp:RadioButtonList id="RadioButtonList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:RadioButtonList>
        </p>
        <p>
            <asp:DropDownList id="DropDownList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:DropDownList>
        </p>
        <p>
            <asp:ListBox id="ListBox1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:ListBox>
        </p>
        <p>
            <asp:Repeater id="Repeater1" runat="server" DataSource="<%# AllPublishers() %>">
                <headerTemplate>
                    <b>Publisher List:</b>
                    <br />
                </headerTemplate>
                <itemTemplate>
                    <%# DataBinder.Eval(Container.DataItem, "pub_name") %> (ID: <%# DataBinder.Eval(Container.DataItem, "pub_id") %>) <font size="-1"><i> <%# DataBinder.Eval(Container.DataItem, "city") %>, <%# DataBinder.Eval(Container.DataItem, "state") %>, <%# DataBinder.Eval(Container.DataItem, "country") %>
                    <br />
                    </i></font>
                </itemTemplate>
            </asp:Repeater>
        </p>
        <p>
            <asp:DataList id="DataList1" runat="server" DataSource="<%# AllPublishers() %>">
                <itemTemplate>
                    <p>
                        ID:
                        <asp:Label id="Label6" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "pub_id") %>'></asp:Label>
                        &nbsp;Name:
                        <asp:Label id="Label7" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "pub_name") %>'></asp:Label>
                    </p>
                    <p>
                        Address:
                        <asp:Label id="Label8" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "city") %>'></asp:Label>
                        ,
                        <asp:Label id="Label9" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "state") %>'></asp:Label>
                        ,
                        <asp:Label id="Label10" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "country") %>'></asp:Label>
                    </p>
                </itemTemplate>
                <headerTemplate>
                    <asp:Label id="Label1" runat="server" Font-Names="Tahoma" Font-Italic="True">List of publishers:</asp:Label>
                    <hr />
                </headerTemplate>
                <footerTemplate>
                    <hr />
                </footerTemplate>
                <separatorTemplate>
                    <hr />
                    <span style="WIDTH: 100%; HEIGHT: 100%">
                    <div contenteditable="true" style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; PADDING-BOTTOM: 8px; WIDTH: 100%; PADDING-TOP: 8px; HEIGHT: 100%"></div>
                    </span>
                </separatorTemplate>
            </asp:DataList>
        </p>
    </form>
</body>
</html>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.