title: Write bit value to database
body: <p>I'm trying to write a bit value (true or false) into my database in a field called "processed". i'm currently trying to do this by passing in bool values, but I get an error saying can't convert from type varchar to bit. Can anybody see what is going on in my logic?</p>
  
  <pre><code>       protected void CheckBoxProcess_CheckedChanged(object sender, EventArgs e)
      {
          bool update;
          bool trueBool = true;
          bool falseBool = false;
          string checkedString = "UPDATE SecureOrders SET processed = '%" + trueBool + "%' WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '% " + DefaultGrid.SelectedRow.Cells[3].Text + "%'";
          string uncheckedString = "UPDATE SecureOrders SET processed = '%" + falseBool + "%' WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '% " + DefaultGrid.SelectedRow.Cells[3].Text + "%'";
          CheckBox cb = (CheckBox)sender;
          GridViewRow gvr = (GridViewRow)cb.Parent.Parent;
          DefaultGrid.SelectedIndex = gvr.RowIndex;
          update = Convert.ToBoolean(DefaultGrid.SelectedValue);
  
          orderByString = orderByList.SelectedItem.Value;
          fieldString = searchTextBox.Text;
  
  
          System.Configuration.ConnectionStringSettings connectionString;
  
          connectionString = rootWebConfig.ConnectionStrings.ConnectionStrings["secureodb"];
  
  
  
          // Create an SqlConnection to the database.
          using (SqlConnection connection = new SqlConnection(connectionString.ToString()))
          {
              connection.Open();
              SqlCommand checkedCmd = new SqlCommand(checkedString, connection);
              SqlCommand uncheckedCmd = new SqlCommand(uncheckedString, connection);
              dataAdapter = new SqlDataAdapter("SELECT * FROM SecureOrders", connection);
  
              // create the DataSet
              dataSet = new DataSet();
              // fill the DataSet using our DataAdapter               
              dataAdapter.Fill(dataSet, "SecureOrders");
  
              DataView source = new DataView(dataSet.Tables[0]);
              DefaultGrid.DataSource = source;
  
  
              if (cb.Checked == true)
              {
                  checkedCmd.ExecuteNonQuery();
  
              }
              else
              {
                  uncheckedCmd.ExecuteNonQuery();
              }
  
              connection.Close();
          }
  
  
  
  
  
  
      }
  </code></pre>