如何读取CSV数据到DataTable中

最新推荐文章于 2024-07-02 17:23:25 发布

dong0037

最新推荐文章于 2024-07-02 17:23:25 发布

阅读量1.1k

点赞数

分类专栏： Code 文章标签： C#

本文链接：https://blog.csdn.net/dong0037/article/details/8928532

版权

Code 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

public class DataTableUtil
{
public static DataTable GetDataTableFromCSV(string path, bool isFirstRowHeader)
{
string header = isFirstRowHeader ? "Yes" : "No";
string pathOnly = Path.GetDirectoryName(path);
string fileName = Path.GetFileName(path);
string sql = @"SELECT * FROM [" + fileName + "]";
using (OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly + ";Extended Properties=\"Text;HDR=" + header + "\""))
using (OleDbCommand command = new OleDbCommand(sql, connection))
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
DataTable dataTable = new DataTable();
dataTable.Locale = CultureInfo.CurrentCulture;
adapter.Fill(dataTable);
return dataTable;
}
}
}