title: How to append one DataTable to another DataTable
body: <p>I would like to append one DataTable to another DataTable. I see the DataTable class has two methods; &quot;Load(IDataReader)&quot; and &quot;Merge(DataTable)&quot;.  From the documentation, both appear to 'merge' the incoming data with the existing DataTable if rows exist. I will be doing the merge in a data access layer.</p>
  <p>I could use an <code>IDataReader</code> and use the Load method to merge the DataTables. Or I could load a DataSet using the <code>IDataReader</code>, get the DataTable from the DataSet, and then use the Merge method to merge the DataTables.</p>
  <p>I was wondering if someone could tell me which is the proper method to use?</p>
  <p>Alternatively, let me know if you have a different suggestion on how to accomplish this task.</p>