title: Merging 2 datatables in to 1 datatable with same number of rows.
body: <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>