title: C# DataBound DataGridView with extra column - changes in this column are lost upon sort?
body: <p>I use a DataGridView which is data-bound over a binding source. Additionally I create one CheckBoxCol on the very left for the user. Checking boxes in there and then re-sorting makes all checks disappear. Has anyone an idea how to avoid that?</p>
  
  <p>Here's some code so we're on the same page ;):</p>
  
  <pre><code>    dtZg_Betr = new DataTable(); // DataTable object
      // [...] SQL SELECT and so on, I cut that stuff a bit
      adapter.Fill(dtZg_Betr); // OleDbAdapter -&gt; fill the table with the SQL SELECT results
      // [...]
      bsZg_Betrn = new BindingSource(); // BindingSource object
      bsZg_Betrn.DataSource = dtZg_Betr;
      dgvZg_Betr.DataSource = bsZg_Betr; // bind data to DataGridView
      DataGridViewCheckBoxColumn dgvCheckBox = new DataGridViewCheckBoxColumn();
      dgvZg_Betr.Columns.Insert(0, (DataGridViewColumn)dgvCheckBox); // add additional checkbox column
  
  
      // Later on somewhere else:
      adapter.Update(dtZg_Betr); // OleDbAdapter -&gt; update DB with table's changes
  </code></pre>
  
  <p>The DataGridView has no further code as such to get filled, later on of course checkbox clicks and such are handled but that should not be relevant for the issue.</p>
  
  <p>Kinds regards!</p>