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+"]";//sql语句

             //操作数据库的流程

             using (OleDbConnection con=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly +";Extended Properties=\"Text;HDR=" + header + "\""))

             {

                 using (OleDbCommand cmd=new OleDbCommand(sql,con))

                 {

                     using (OleDbDataAdapter adapter=new OleDbDataAdapter(cmd))

                     {

                         DataTable dt=new DataTable();

                         dt.Locale=CultureInfo.CurrentCulture;

                         adapter.Fill(dt);

                         return dt;

                     }

                 }

             }

         }

         public static DataTable ConvertCsvToDataTable(string fileName)

         {

             DataTable dt=new DataTable();

             using (StreamReader sr=new StreamReader(fileName,Encoding.UTF8))

             {

                 string[] headers = sr.ReadLine().Split(',');//处理头部标题

                 foreach (string header in headers)

                 {

                     dt.Columns.Add(header);

                 }

                 while (!sr.EndOfStream)

                 {

                     string[] rows = sr.ReadLine().Split(',');

                     DataRow dr = dt.NewRow();

                     for (int i = ; i < headers.Length; i++)

                     {

                         dr[i] = rows[i];

                     }

                     dt.Rows.Add(dr);

                 }

             }

             return dt;

         }

         private void btnGet_Click(object sender, EventArgs e)

         {

             //打开文件对话框

             OpenFileDialog ofd=new OpenFileDialog() {Filter = "Csv文件|*.csv|Excel文件|*.xls|所有文件|*.*", InitialDirectory = @"C:\Users\LWP1398\Desktop",RestoreDirectory = true};

             if (ofd.ShowDialog()==DialogResult.OK)

             {

                 string fileName = ofd.FileName;

                 //dgv.DataSource = GetDataTableFromCsv(fileName, true);

                 dgv.DataSource = ConvertCsvToDataTable(fileName);

             }

             MessageBox.Show("ok");

         }