How to bind values to checkboxes using the data in the database?

Database

• I have made use of the following table Hobbies with the schema as follows. Enable disabled CheckBoxField columns in GridView in ASP.Net

  

• I have already inserted few records in the table Enable disabled CheckBoxField columns in GridView in ASP.Net

• HTML Markup

Below is the HTML Markup of the ASP.net web page.

As you can see I have added a CheckBoxList and a Button that will allow the user to update the selections in the database.

<asp:CheckBoxList ID="chkHobbies" runat="server">
</asp:CheckBoxList>
<br />
<asp:Button ID="btnUpdate" runat="server" Text="Button" OnClick = "UpdateHobbies" />

The screenshot below describes how the User Interface looks

Populating the CheckBoxList from Database

The following method is used to populate the Hobbies CheckBoxList from the SQL Server Database C#

private void PopulateHobbies()
{
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager
                .ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select * from hobbies";
            cmd.Connection = conn;
            conn.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    ListItem item = new ListItem();
                    item.Text = sdr["Hobby"].ToString();
                    item.Value = sdr["HobbyId"].ToString();
                    item.Selected = Convert.ToBoolean(sdr["IsSelected"]);
                    chkHobbies.Items.Add(item);
                }
            }
           conn.Close();
        }
    }
}

The above method is called up in the page load event in the following way:-

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.PopulateHobbies();
    }
}

Saving the Selections in Database

The following method is called up on the Submit Button Click event and is used to save the user selections to the database

protected void UpdateHobbies(object sender, EventArgs e)
{
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager
                .ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "update hobbies set IsSelected = @IsSelected" +
                              " where HobbyId=@HobbyId";
            cmd.Connection = conn;
            conn.Open();
            foreach (ListItem item in chkHobbies.Items)
            {
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@IsSelected", item.Selected);
                cmd.Parameters.AddWithValue("@HobbyId", item.Value);
                cmd.ExecuteNonQuery();
            }
            conn.Close();
        }
    }
}

When program runs for the first time

After updating the values in checkbox.

I have solved the problem and here is the code.

            List<int> list = new List<int>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                list.Add(Convert.ToInt32(dr["Qulif_code"]));

            }
            int[] arr = list.ToArray();

            for (int i = 0; i < arr.Length; i++)
            {
                if (arr[i] == 1)
                {
                    ck_ol.Checked = true;
                }
                else if (arr[i] == 2)
                {
                    ck_al.Checked = true;
                }
                else if (arr[i] == 3)
                {
                    ck_dip.Checked = true;
                }
                else if (arr[i] == 4)
                {
                    ck_deg.Checked = true;
                }

            }          

I hope this might help to someone in future.