ASP .NET - Save copy of existing data before updating in GridView
<p>I want to ensure that the websites users don't mess up the primary data table so before each update the non-updated data should be stored into a history table.</p>

<p>I am thinking of using the 'RowUpdating' event on the GridView to do this.  </p>

<p>How do I manually run a insert query using my existing SQLDataSource?</p>

<p>Overall flow would work like this:</p>

<ol>
<li>gridview shows
field1 field2
test   1234</li>
<li>user edits gridview values
field1 field2
test    3333
3a. user selects 'update' button
3b.  system records that data was test,1234</li>
</ol>
