How to Fill CheckBoxList from Sql Server table in asp.net

How to Fill CheckBoxList from Sql Server table in asp.net


ntroduction: In one of my previous article i  explained  Fill CheckBoxList based on DropDownList selection in asp.net(C#, VB)  and How to get CheckBoxList selected items in comma separated format in asp.net(C#,VB)  and How to validate CheckBoxList using JavaScript in Asp.net(C#, VB) and  How to fill DropDownList from Sql server database in asp.net    Now in this article I am going to explain how to dynamically fill CheckBoxListwith the data from the Sql Server table. It  is one of very common requirement while working on asp.net application.

 

• In the design page(.aspx) place a DropDownList and a CheckBoxList control as:

         <asp:CheckBoxList ID="cblCourses" runat="server" RepeatColumns="2">

        </asp:CheckBoxList> 

• Create a connectionstring in the web.config file under configuration tag as:

<configuration>

<connectionStrings>

                                <add name="MyDbCon" connectionString="Data Source=LALIT;Initial Catalog=MyDataBase;Integrated Security=True"/>

</connectionStrings>

</configuration>

•  Create a table in sql server and name it  Qualification_Tb:

• Now in the code behind file(.aspx.cs) write the code as

 C#.NET

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

 

protected void Page_Load(object sender, EventArgs e)

    {

if (!Page.IsPostBack)

        {         

            FillQualCheckBoxList();

        }

    }

private void FillQualCheckBoxList()

    {

        SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["MyDbCon"].ConnectionString);

        SqlCommand cmd = new SqlCommand("Select * from Qualification_Tb", con);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);

        DataTable dt = new DataTable();

        adp.Fill(dt);

        cblCourses.DataSource = dt;

        cblCourses.DataTextField = "Qualification";

        cblCourses.DataValueField = "Qualification_Id_Pk";

        cblCourses.DataBind();       

    }