title: MySql Change DataGridView Information
body: <p>I wrote a simple program that populates a Datagrid from <code>MySQL</code>.</p>
  
  <p>In one of my columns I have a Boolean (0 or 1)</p>
  
  <p>Once the Datagrid populates with the query I have check boxes for the boolean.</p>
  
  <p>Does anyone know how to use a function when you check the check boxes for the boolean? (This is to send an update of just the boolean of the column.)</p>
  
  <p>To sum up, When the check-box is checked it changes the boolean value from 0 to 1 in the <code>MySQL</code> database.</p>
  
  <p>The reason I am having an issue with this is simply because the Datagrid does not populate until I run the application. Therefore, I cannot figure out how to change it while in visual studio.</p>
  
  <p><strong>How the DGV is populated:</strong></p>
  
  <pre><code>MySqlConnection conn = new MySqlConnection(dbConnection);
  conn.Open();
  MySqlCommand cmd = new MySqlCommand();
  
  cmd.Connection = conn;
  MySqlDataAdapter da = new MySqlDataAdapter();
  
  //SQL Query String
  string sqlSelectAll = "SELECT * FROM `Tasks` WHERE `Completed` = 0";
  da.SelectCommand = new MySqlCommand(sqlSelectAll, conn);
  
  DataTable table = new DataTable();
  da.Fill(table);
  
  BindingSource bSource = new BindingSource();
  bSource.DataSource = table;
  
  dataGridView1.DataSource = bSource;
  </code></pre>
  
  <p>Any Help would be grateful.</p>
  
  <p><strong>Note:</strong> </p>
  
  <p>I've tried using the data configuration manager in VS2015, which resulted in a completely different error that has nothing to do with this. So that's out of the question.</p>