title: DataTable events and row state
body: <p>I am allowing my users to add / edit / delete data in a DataGridView that is bound to a DataTable. That all works fine. The data gets updated back to the database fine. However, I have some fields in the DataTable that I do not want to be visible in the DataGridView, such as CreatedOn and CreatedBy. I need to write values to these columns based on the state of the row before they get updated to the data adapter. 
  In this case, should I wire up some event handlers for TableNewRow and RowChanged in the datatable and manipulate the row columns that way before the data adapter is updated and AcceptChanges has occured?</p>
  
  <p>Thanks for any thoughts.</p>
  
  <p>Ryan</p>