读取 csv文件 到DataTable

 private DataTable getDataTable(string filePath, string fileName)
    {
        DataTable dt = new DataTable();
        string strConnCSV = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='TEXT;HDR=Yes;FMT=Delimited;'";
        System.Data.OleDb.OleDbConnection objConn = new OleDbConnection(strConnCSV);
        objConn.Open();
        string strSql = "SELECT * FROM " + fileName;

        System.Data.OleDb.OleDbDataAdapter odbcCSVDataAdapter = new OleDbDataAdapter(strSql, strConnCSV);
        odbcCSVDataAdapter.Fill(dt);
        return dt;
    }

//调用

//file.csv在Files文件夹下

DataTable dt=getDataTable(Server.MapPath(@"Files/"), "file.csv")