title: VB.Net DataGridView update query results
body: <p>I am currently working in converting an out of date Access application in to a .Net application. </p>
  
  <p>In Access we have a query on a form that contains a list of customers and vehicles where the users can edit the data as required.</p>
  
  <p>I followed the following guide to populate the data grid</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/fbk67b6z(v=vs.90).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/fbk67b6z(v=vs.90).aspx</a></p>
  
  <p>As you could expect I need to replicate this functionality in .Net, I have been able to populate a DataGridView with the results of a query joining the two tables however I have not been able to work out how to handle the update of the tables through the DataGridView. I understand the as the DataGridView contains the results of a query i need to manually code the UpdateCommand of the DataAdapter and this is where i am stuck.</p>
  
  <p>In Short i need to update two tables though a single data grid view.</p>
  
  <p>Kind Regards</p>