title: How to combine data from datatables
body: <p>I have filled my dataset from multiple xml files in C#.Net.
  As a result I have a dataset which contains multiple DataTables in it. All of them are having two columns each namely "ID" and "Name". These data tables can contain rows for same ids actoss all the tables.</p>
  
  <p>For Example:</p>
  
  <pre><code>DataTable 1
  ------------
  ID  Name1
  1   S1
  2   S2
  4   S4
  
  DataTable 2
  ------------
  ID  Name2
  1   D1
  2   D2
  3   D3
  </code></pre>
  
  <p>My objective is to combine all the data into one datatable as shown below</p>
  
  <pre><code>FinalTable
  -----------
  ID  Name1  Name2
  1   S1     D1
  2   S2     D2
  3          D3
  4   S4       
  </code></pre>
  
  <p>Is there any way to achieve this? May be using relations, DataViews... just guessing.</p>
  
  <p>Thanks in advance..</p>