title: how to use gridview values to update another table in database using asp.net c#
body: <p>I have a <code>GridView</code> and it is bound to SQLdatasource. I edit it and the corresponding table in the database gets updated. 
  Once I finish editing all the rows in the <code>GridView</code>, On a button_click I want to read each and every row in the <code>GridView</code> which has entry and use the first column <strong>Location</strong> in my GridView in where clause and update another different table in the database.</p>
  
  <p>Kindly help. thank you in advance.</p>