[FIXED] How to read a CSV file into a .NET Datatable

Issue

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?

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.

Answered By - Jay Riggs

Answer Checked By - Mary Flores (PHPFixing Volunteer)