title: should data be up-to-date, when sending a record from datagridview to an editing form?
body: <p>i have a windows form with a <strong>datagridview</strong> control and some input fields. when the form loads it will load about 100 rows to the grid. and these records were fetched from 3 db tables. Keep in mind that the application also must handle optimistic concurrency violations at update. The user double clicks on a record and sends them to the input fields of the form for editing. This is where my problem is.  If this is a busy application, some one might change this record while i'm viewing it. So when i double click to send the record to the input fields for editing, should i re-fetch that record from the database and set the new values to input fields rather than setting with the value that is visible in the <strong>datagridview</strong>?</p>
  
  <p>In this situation what would an industry level application do?</p>
  
  <p>thanks</p>