title: DataGridView skip Column from Updating
body: <p>Is there any possibility to skip or delete specific column of <code>DataGridView</code> from updating to the database?</p>
  
  <p>I need to prevent column from updating to the database, because the column values is encrypted and when I decrypt, the decrypted values updated to the database.</p>
  
  <p>I used this code before, but this really slows the grid.</p>
  
  <pre><code>private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  {
       if (hide == false &amp;&amp; e.ColumnIndex == 2 &amp;&amp; e.RowIndex != this.dataGridView1.NewRowIndex)
       {
           e.Value = Decrypt(e.Value.ToString());
       }
  }
  </code></pre>
  
  <p>Updating values with this code:</p>
  
  <pre><code>private void dataGridView1_RowValidated(object sender, DataGridViewCellEventArgs e)
  {
      DataTable changes = ((DataTable)dataGridView1.DataSource).GetChanges();
  
      if (changes != null)
      {
          MySqlCommandBuilder mcb = new MySqlCommandBuilder(mySqlDataAdapter);
          ((DataTable)dataGridView1.DataSource).AcceptChanges();
          mySqlDataAdapter.UpdateCommand = mcb.GetUpdateCommand();
  
          mySqlDataAdapter.Update(changes);
      }
  }
  </code></pre>