title: DataTable from TextFile?
body: <p>I have taken over an application written by another developer, which reads data from a database, and exports it.</p>
  
  <p>The developer used DataTables and DataAdaptors.</p>
  
  <p>So,</p>
  
  <pre><code> _dataAdapter = new SqlDataAdapter("Select * From C....", myConnection);
  </code></pre>
  
  <p>and then</p>
  
  <pre><code>ExtractedData = new DataTable("CreditCards");
  _dataAdapter.Fill(ExtractedData);
  </code></pre>
  
  <p>ExtractedData is then passed around to do different functions.</p>
  
  <p>I have now been told that I need to, in addition to this, get the same format of data from some comma separated text files. The application does the same processing - it's just getting the data from two sources.</p>
  
  <p>So, I am wondering if I can get the data read into a DataTable, as above, and then ADD more records from a CSV file. </p>
  
  <p>Is this possible?</p>