How to read a CSV file into a .NET Datatable
.net, c#, csv, datatable
Solution
Here's an excellent class that will copy CSV data into a datatable using the structure of the data to create the DataTable:
A portable and efficient generic parser for flat files
It's easy to configure and easy to use. I urge you to take a look.
Problem
How can I load a CSV file into a `System.Data.DataTable`, creating the datatable based on the CSV file? Does the regular ADO.net functionality allow this?