title: Update DataBase on button click, after editing gridview (not automatically saving in DB, but after confirming on any event) within using transactions
body: <p>0  vote down  star</p>
  
  <p>I am using GridView in asp .net and editing data with edit command field property (as we know after updating the edited row, we automatically update the database), and I want to use transactions (with begin to commit statement - including rollback) to commit this update query in database, after clicking in some button (after some events for example), not automatically to insert or update the edited data from grid directly to the DB...so I want to save them somewhere temporary (even many edited rows - not just one row) and then to confirm the transaction - to update the real tables in database...</p>
  
  <p>I've used some good links, but very helpful, like: </p>
  
  <p><a href="http://www.asp.net/learn/data-access/tutorial-63-cs.aspx" rel="nofollow noreferrer">http://www.asp.net/learn/data-access/tutorial-63-cs.aspx</a> </p>
  
  <p><a href="http://www.asp.net/learn/data-access/tutorial-66-cs.aspx" rel="nofollow noreferrer">http://www.asp.net/learn/data-access/tutorial-66-cs.aspx etc...</a>
  etc...</p>