Merging 2 datatables in to 1 datatable with same number of rows.
<p>How can i merge two Datatables into the same row. I am using different stored procedures to get data into datasets. In asp.net using c#, i want to merge them so there are same number of rows as table 1 with an added column from table 2.</p>

<p>For example:</p>

<pre><code>DataTable table1 = dsnew.Tables[0];
DataTable table2 = dsSpotsLeft.Tables[0];
table1.Merge(table2);
</code></pre>

<p>This is fetching me 4 rows instead of 2 rows. What am i missing here? Thanks in advance!! </p>
