title: how to insert multiple checkbox list values into database in single column using c#
body: <p>i use this to select one checkbox to isselected column 
  how i convert this to multi checkboxlist to single column
  i use many ways more than 3 days without success</p>
  
  <pre><code> private void BindCheckBoxList()
      {
          DataTable dt = new DataTable();
          SqlConnection connection = new SqlConnection(GetConnectionString());
          try
          {
              connection.Open();
              string sqlStatement = "SELECT * FROM boby";
              SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
              SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
  
              sqlDa.Fill(dt);
              if (dt.Rows.Count &gt; 0)
              {
                  CheckBoxList1.RepeatColumns = 4; // set the number of columns in the CheckBoxList
                  CheckBoxList1.DataSource = dt;
                  CheckBoxList1.DataTextField = "Name"; // the items to be displayed in the list items
                  CheckBoxList1.DataValueField = "Name"; // the id of the items displayed
                  CheckBoxList1.DataBind();
  
                  //Setting the Selected Items in the ChecBoxList based from the value in the database
                  //to do this, lets iterate to each items in the list
                  for (int i = 0; i &lt; dt.Rows.Count; i++)
                  {
                      if (!string.IsNullOrEmpty(dt.Rows[i]["IsSelected"].ToString()))
                      {
                          CheckBoxList1.Items[i].Selected = Convert.ToBoolean(dt.Rows[i]["IsSelected"]);
                      }
                  }
              }
  
          }
          catch (System.Data.SqlClient.SqlException ex)
          {
              string msg = "Fetch Error:";
              msg += ex.Message;
              throw new Exception(msg);
          }
          finally
          { 
              connection.Close();
          }
      }
  
      private void Update(string name, bool isSelected)
      {
          SqlConnection connection = new SqlConnection(GetConnectionString());
          SqlCommand cmd;
          string sqlStatement = string.Empty;
          try
          {
              connection.Open();
              sqlStatement = "UPDATE handymen SET IsSelected = @IsSelected WHERE Name = @BizName";
              cmd = new SqlCommand(sqlStatement, connection);
              cmd.Parameters.AddWithValue("@Name", name);
              cmd.Parameters.AddWithValue("@IsSelected", isSelected);
              cmd.CommandType = CommandType.Text;
              cmd.ExecuteNonQuery();
          }
          catch (System.Data.SqlClient.SqlException ex)
          {
              string msg = "Insert/Update error";
              msg += ex.Message;
              throw new Exception(msg);
  
          }
          finally
          {
              connection.Close();
          }
      }
  
      protected void Page_Load(object sender, EventArgs e)
      {
          if (!Page.IsPostBack)
          {
              BindCheckBoxList();
          }
      }
      protected void Button1_Click(object sender, EventArgs e)
      {
          string str = string.Empty;
  
          for (int i = 0; i &lt; CheckBoxList1.Items.Count; i++)
          {
              if (CheckBoxList1.Items[i].Selected)
              {
                  str = CheckBoxList1.Items[i].Text;
                  Update(str, CheckBoxList1.Items[i].Selected);
              }
          }
          //ReBind the List to retain the selected items on postbacks
  
          BindCheckBoxList();
      }
  </code></pre>