title: Moving Data from one table to another
body: <p>Hie frnds,</p>
  
  <p>I have two tables say "Orders" and "OrdersXML"</p>
  
  <p>now I wish to remove orders which are more than 7 days old to OrdersXML table which i have done using <strong>sql adapter</strong> update function over dataset, which do this job taking 100 rows at a time.
  I want to delete the rows from the orders table which have been moved to OrdersXML table
  How can i Achieve this?? I want to ensure that a row in Orders is only deleted after it has been inserted into OrdersXML. I don't want to loose any of the data.. not even by accident..</p>
  
  <p>Should I use trigger? or should i code it in C# itself?</p>
  
  <p>as m using data-adapter I cant get the ids which have been inserted if any exception comes in between.. can i??</p>