title: Catching and Handling concurrency violations on TableAdapter
body: <p>I am using a <code>TableAdapter</code> to connect to my database table.</p>
  
  <p>When I perform an <code>Update</code> and someone else has updated the same row I get a concurrency violation error. As expected. </p>
  
  <p>So at this point I give the user the option to Save regardless or Cancel changes</p>
  
  <p>If they cancel I can just performs a <code>Fill</code> to get an updated copy of the data but what if they want to overwrite? How do I actually force a save of the data overwriting the data held in the database?</p>