title: DataGridView Save Changes On Row Change
body: <p>I am attempting to save a record after leaving the row in a <code>DataGridView</code>.</p>
  
  <p>I have seen solutions use the <code>RowValidated</code> event, however, when the rows are sorted then the record gets resorted before the <code>RowValidation</code> event is fired. I also attempted to get the row using the <code>BindingSource</code> Current property, but the current property is already changed. Same applies to RowLeaving I believe.</p>
  
  <p>I have tried using the <code>RowChanged</code> event on the datatable directly and that does work OK.</p>
  
  <p>I ended up using the <code>RowValidation</code> event and getting the changes from the datatable (<code>GetChange())</code>, but this doesn’t seem idea.</p>
  
  <p>In addition for deletes I used the <code>UserDeletingRow</code> event, but again this doesn’t seem idea.</p>
  
  <p>What is the best way for saving records after leaving the row?</p>