c#读取csv，各种报错

Question

将csv文件当成txt来读，用StreamReader对象读取即可。

Answer 1

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }        OleDbConnection OleCon = new OleDbConnection();
        OleDbCommand OleCmd = new OleDbCommand();
        OleDbDataAdapter OleDa = new OleDbDataAdapter();        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView1.DataSource = Csv();
        }        public DataSet Csv()
        {
            DataSet CsvData = new DataSet();
            OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"E:\test.csv" + ";Extended Properties='Text;FMT=Delimited;HDR=YES;'";
            OleCon.Open();
            OleCmd.Connection = OleCon;
            OleCmd.CommandText = "select * From " + @"E:\test.csv";
            OleDa.SelectCommand = OleCmd;
            try
            {
                OleDa.Fill(CsvData, "Csv");
                return CsvData;
            }
            catch
            {
                return CsvData;
            }
            finally
            {
                OleCon.Close();
                OleCmd.Dispose();
                OleDa.Dispose();
                OleCon.Dispose();
            }
        }
    }
代码直接在红色出报错了，说路径不对，但是我取芯路径是没问题的

Answer 2

参考，C#读写csv
http://www.cnblogs.com/Clin/archive/2013/03/14/2959022.html

Answer 3

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }        OleDbConnection OleCon = new OleDbConnection();
        OleDbCommand OleCmd = new OleDbCommand();
        OleDbDataAdapter OleDa = new OleDbDataAdapter();        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView1.DataSource = Csv();
        }        public DataSet Csv()
        {
            DataSet CsvData = new DataSet();
            OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"E:\test.csv" + ";Extended Properties='Text;FMT=Delimited;HDR=YES;'";
            OleCon.Open();
            OleCmd.Connection = OleCon;
            OleCmd.CommandText = "select * From " + @"E:\test.csv";
            OleDa.SelectCommand = OleCmd;
            try
            {
                OleDa.Fill(CsvData, "Csv");
                return CsvData;
            }
            catch
            {
                return CsvData;
            }
            finally
            {
                OleCon.Close();
                OleCmd.Dispose();
                OleDa.Dispose();
                OleCon.Dispose();
            }
        }
    }
代码直接在红色出报错了，说路径不对，但是我取芯路径是没问题的test.csv 这个文件放在一个文件夹里面，不要放在根目录下试试。