我想读一个CSV文件的内容，并创建一个数据集。 我想是这样的：

I would like to read the contents of a CSV file and create a dataset. I am trying like this:

var lines = File.ReadAllLines("test.csv").Select(a => a.Split(';'));
DataSet ds = new DataSet();
ds.load(lines);

但显然这是不正确的。

but apparently this is not correct.

推荐答案

您需要运行对CSV文件中的 SELECT 语句来填充数据集：

You need to run a SELECT statement against the CSV file to fill the dataset:

编辑：这里是从的http://carllbrown.blogspot.co.uk/2007/09/populate-dataset-from-csv-delimited_18.html

string FileName = ...
OleDbConnection conn = new OleDbConnection
       ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + 
         Path.GetDirectoryName(FileName) + 
         "; Extended Properties = "Text;HDR=YES;FMT=Delimited"");

conn.Open();

OleDbDataAdapter adapter = new OleDbDataAdapter
       ("SELECT * FROM " + Path.GetFileName(FileName), conn);

DataSet ds = new DataSet("Temp");
adapter.Fill(ds);

conn.Close();