title: DataTable importRow() into empty table
body: <p>I've been trying to merge an excel document with many sheets into a Datatable so that I can display said sheet in my winform app.</p>
  
  <p>From reading around, I figured that Datatable.import(DataRow row) is my best bet. Thus my code looks as follows:</p>
  
  <pre><code>DataTable returnSet = new DataTable();
  foreach (DataTable datTab in ds.Tables) // ds is extracted excel sheets in a dataset
  {
    foreach (DataRow datRow in datTab.Rows) 
    {
      if (datRow.IsNull(0)) //if empty first col go on to next sheet
      {
        break;
      }
      else
      {
        returnSet.ImportRow(datRow);
      }
    }
  }
  </code></pre>
  
  <p>When debugging, it shows that datRow/datTab is what I expected it to be, however after each ImportRow, returnSet is still an empty 1x1 cell. Any insight as to what I am doing wrong / missing would be greatly appreciated.</p>