Merge 2 Datatables
<p>I have a Datatable D1 with</p>

<pre><code>DataTable 1
------------
ID  Name1
1   S1
2   S2
4   S4


DataTable 2
------------
ID  Name2
1   D1
2   D2
3   D3

Result:

FinalTable
-----------
ID  Name1  Name2
1   S1     D1
2   S2     D2
3          D3
4   S4 
</code></pre>

<p>I tried the merge  ds1.Merge(dt2, true, MissingSchemaAction.Add);
This adds additional columns instead </p>

<p>Thanks
Sun</p>
