title: How to get data from one table and add into another table in C# DataSet?
body: <p>I have a complex xml file and I read the xml and stored the data into DataSet object. The DataSet holds the following DataTable </p>
  
  <pre><code>1.Customer
  2.Operation 
  3.Account 
  4.Card
  </code></pre>
  
  <p><b>Customer</b> DataTable has many column with CustomerId and SerialNo. Others DataTable has SerialNo column common. I need to Add CustomerId Column value into others (Operation,Account and card) DataTable according to SerialNo and need to Store all table data into database. How can I do this, please advise me with example. </p>