title: Compare between two datatables and merge into new datatable
body: <p>Suppose i have two data table contain same column name, But record may or may not be the same. My question is how to compare between two data table and marge into new one.
  example:</p>
  
  <p><strong>datatable 1</strong></p>
  
  <pre>
  Name     value
  A           1
  B           2
  C           3   
  D           4
  </pre>
  
  <p><strong>datatable 2</strong></p>
  
  <pre>
  Name    value
  A        9
  B        2
  D        1
  </pre>
  
  <p><strong>New datatable(Compare based on datatable 1)</strong></p>
  
  <pre>
  Name    value(From1)   value(From2)
  A             1            9
  B             2            2
  C             3 
  D             4            1
  
  </pre>
  
  <p>If a record present in <code>datatable1</code> is not present in <code>datatable2</code> then add blank. Here the datatable generate from XML. I am using vb.net 2008 express.</p>