...
- DataReader is more efficient at pulling out data and displaying it, as it just reads one row at a time out of the database and doesn't keep anything in memory.
- DataTables still have uses beyond those provided by DataReader, so sometimes they are still needed to filter, sort or otherwise manipulate the data before populating the workbook.
Downloads
You can download the code for the best performance samples as a Visual Studio solution.
- (Link to code goes here.)
Time Related Performance Issues
...