将txt转为dataset

   private System.Data.DataTable CSVtoDataTable(string csvFilePath)
        {
            System.Data.DataTable dt = new System.Data.DataTable();

         
           // using (StreamReader sr = File.OpenText(csvFilePath))

            if (!File.Exists(csvFilePath))
            {
                //MessageBox.Show("123");
                errorMSG("不存在");
                return dt;
            }
            StreamReader sr = new StreamReader(csvFilePath, System.Text.Encoding.Default);
          
                string line;
              
                line = sr.ReadLine();
                dt.Columns.Add("A", typeof(string));
                dt.Columns.Add("B", typeof(string));
                dt.Columns.Add("C", typeof(string));
                dt.Columns.Add("D", typeof(string));
                dt.Columns.Add("E", typeof(string));
                dt.Columns.Add("F", typeof(String));
                dt.Columns.Add("G", typeof(string));
                dt.Columns.Add("H", typeof(string));
                dt.Columns.Add("I", typeof(string));
                dt.Columns.Add("J", typeof(string));
                dt.Columns.Add("K", typeof(string));
                dt.Columns.Add("L", typeof(string));
                dt.Columns.Add("M", typeof(string));
                dt.Columns.Add("N", typeof(string));
                dt.Columns.Add("O", typeof(string));
                dt.Columns.Add("P", typeof(string));
                dt.Columns.Add("Q", typeof(string));
                while ((line = sr.ReadLine()) != null)
                {

                    string[] data = line.Split(',');

                    DataRow row = dt.NewRow();
                    row.ItemArray = data;
                    dt.Rows.Add(row);
                }

                sr.Close();

            return dt;
        }