title: Union tables of dataset in a single datatable
body: <p>I have a DataSet with many similar tables in it. I need to union all datatables in a single table. So for this example; I need a datatable with 20 rows. How can I do that?</p>
  
  <pre><code>DataSet SampleDS = new DataSet();
  
  DataTable SampleTbl1 = new DataTable();
  SampleTbl1.Columns.Add("Product", typeof(string));
  SampleTbl1.Columns.Add("Value", typeof(int));
  for (int i = 0; i &lt; 10; i++)
  {
      SampleTbl1.Rows.Add("Product " + i, i);
  }
  
  SampleDS.Tables.Add(SampleTbl1);
  
  DataTable SampleTbl2 = new DataTable();
  SampleTbl2.Columns.Add("Product", typeof(string));
  SampleTbl2.Columns.Add("Value", typeof(int));
  for (int i = 0; i &lt; 10; i++)
  {
      SampleTbl2.Rows.Add("Product " + i, i*2);
  }
  
  SampleDS.Tables.Add(SampleTbl2);
  </code></pre>