title: How to properly commit bindingSource changes to source DB?
body: <p>I setup DataGridView and other UI components to allow user to edit data from SQLite DB. But these changes (even they are properly shows in application) doesn't saves to DB. I have tried this code</p>
  
  <pre><code>aBindingSource.EndEdit();
  dbDataSetA.GetChanges();
  aTableAdapter.Update(dbDataSetA.Accounts);   
  </code></pre>
  
  <p>but there are concurrency exception: </p>
  
  <blockquote>
    <p>System.Data.DBConcurrencyException was unhandled   Message=Concurrency
    violation: the UpdateCommand affected 0 of the expected 1 records.  </p>
  </blockquote>
  
  <p>So how should I commit bindingsource changes to DB, guys?</p>
  
  <hr>
  
  <p><strong>POST EDIT</strong>
  I got this exception when I start the program, then click on second row in DataGridView and then on third and this time program raise a concurrency exception. Hope his help get this issue more detailed.</p>
  
  <p>Thanks in advance, guys!</p>