Skip to main content

How to populate a CheckBoxList from SqlDataSource in asp.net c#

Populate a CheckBoxList from SqlDataSource
CheckBoxList is an asp.net web server control that provides a multi-selection CheckBox group. CheckBoxList control support data binding. so we can populate CheckBoxList with items from a data source control. To bind CheckBoxList control to a data source, first, asp.net developers need to create a data source control such as ObjectDataSource, LinqDataSource, SqlDataSource control, etc.

DataSource control contains the items to display in the CheckBoxList. After creating the DataSource control, developers can call the CheckBoxList DataBind method to bind the DataSource to the CheckBoxList control. This method allows developers to programmatically (dynamically) data bind CheckBoxList control at run time.

CheckBoxList control's DataTextFiled and DataValueFiled properties specify which field in the data source to bind to the Text and Value properties of each list item in CheckBoxList control. ChecBoxList ListItem object contains Text and Value properties. Text property text is displayed in the CheckBoxList control and the Value property is associated with the ListItem object and hidden in the web browser.

We also can use the CheckBoxList DataSourceID property to specify DataSource control using declarative syntax. Declarative syntax also supports DataTextField and DataValueField properties.

The following asp.net c# example code demonstrates to us how can we data bind a CheckBoxList with SqlDataSource control to display CheckBoxList items from database data.
CheckBoxListSqlDataSource.aspx

<%@ Page Language="C#" %>

<!DOCTYPE html>

<script runat="server">
    protected void Button1_Clicked(object sender,System.EventArgs e) {
        Label1.Text = "You Selected:<br/>";
        foreach (ListItem li in CheckBoxList1.Items){
            if (li.Selected == true){
                Label1.Text += li.Text + "<br/>";
            }
        }
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>CheckBoxList example: how to populate CheckBoxList from SqlDataSource in asp.net</title>
    </head>

    <body>
        <form id="form1" runat="server">
            <div>
                <asp:Label ID="Label1" runat="server"></asp:Label>
                <hr />
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>" SelectCommand="SELECT [ProductName] FROM [Products]">
                </asp:SqlDataSource>
                <asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="ProductName" RepeatColumns="4" BorderStyle="Solid" BorderColor="Red" BorderWidth="1px">
                </asp:CheckBoxList>
                <asp:Button ID="Button1" runat="server" Text="Vew Selected Products" OnClick="Button1_Clicked" />

            </div>
        </form>
    </body>
</html>
Labels:

Popular posts from this blog

Restricting Jetpack Compose TextField to Numeric Input Only

Jetpack Compose has revolutionized Android development with its declarative approach, enabling developers to build modern, responsive UIs more efficiently. Among the many components provided by Compose, TextField is a critical building block for user input. However, ensuring that a TextField accepts only numeric input can pose challenges, especially when considering edge cases like empty fields, invalid characters, or localization nuances. In this blog post, we'll explore how to restrict a Jetpack Compose TextField to numeric input only, discussing both basic and advanced implementations. Why Restricting Input Matters Restricting user input to numeric values is a common requirement in apps dealing with forms, payment entries, age verifications, or any data where only numbers are valid. Properly validating input at the UI level enhances user experience, reduces backend validation overhead, and minimizes errors during data processing. Compose provides the flexibility to implement ...
Read more

jetpack compose - TextField remove underline

Compose TextField Remove Underline The TextField is the text input widget of android jetpack compose library. TextField is an equivalent widget of the android view system’s EditText widget. TextField is used to enter and modify text. The following jetpack compose tutorial will demonstrate to us how we can remove (actually hide) the underline from a TextField widget in an android application. We have to apply a simple trick to remove (hide) the underline from the TextField. The TextField constructor’s ‘colors’ argument allows us to set or change colors for TextField’s various components such as text color, cursor color, label color, error color, background color, focused and unfocused indicator color, etc. Jetpack developers can pass a TextFieldDefaults.textFieldColors() function with arguments value for the TextField ‘colors’ argument. There are many arguments for this ‘TextFieldDefaults.textFieldColors()’function such as textColor, disabledTextColor, backgroundColor, cursorC...
Read more

jetpack compose - Image clickable

Compose Image Clickable The Image widget allows android developers to display an image object to the app user interface using the jetpack compose library. Android app developers can show image objects to the Image widget from various sources such as painter resources, vector resources, bitmap, etc. Image is a very essential component of the jetpack compose library. Android app developers can change many properties of an Image widget by its modifiers such as size, shape, etc. We also can specify the Image object scaling algorithm, content description, etc. But how can we set a click event to an Image widget in a jetpack compose application? There is no built-in property/parameter/argument to set up an onClick event directly to the Image widget. This android application development tutorial will demonstrate to us how we can add a click event to the Image widget and make it clickable. Click event of a widget allow app users to execute a task such as showing a toast message by cli...
Read more