title: Ways to increase performance of DataTable.Load()?
body: <p>I currently use a custom CSV class from Codeproject to create a CSV object. I then use this to populate a DataTable. Under profiling this is taking more time than I would like and I wonder if there is a more efficient way of doing it?</p>
  
  <p>The CSV contains approximately 2,500 rows and 500 columns.</p>
  
  <p>The CSV reader is from: <a href="http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader" rel="nofollow">http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader</a></p>
  
  <pre><code>StreamReader s = new StreamReader(confirmedFilePath);
  CsvReader csv = new CsvReader(s, true);
  DataTable dt = new DataTable();
  dt.Load(csv);
  </code></pre>
  
  <p>I came across a google search suggesting a DataAdapter, but it was only one reference to this? I searched further but didn't find any collaboration.</p>