从 CSV 文件填充数据集 [英] Populating a dataset from a CSV file

问题描述

我想读取 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);

但显然这是不正确的.

推荐答案

您需要对 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();

这篇关于从 CSV 文件填充数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！