1         #region 将CSV文件的数据读取到DataTable中
 2         /// <summary>
 3         /// 将CSV文件的数据读取到DataTable中
 4         /// </summary>
 5         /// <param name="fileName">CSV文件路径</param>
 6         /// <returns>返回读取了CSV数据的DataTable</returns>
 7         public static DataTable OpenCSV(string filePath)
 8         {
 9             try
10             {
11                 Encoding encoding = Encoding.Default; //Encoding.ASCII;//
12                 DataTable dt = new DataTable();
13                 FileStream fs = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read);
14 
15                 //StreamReader sr = new StreamReader(fs, Encoding.UTF8);
16                 StreamReader sr = new StreamReader(fs, encoding);
17                 //string fileContent = sr.ReadToEnd();
18                 //encoding = sr.CurrentEncoding;
19                 //记录每次读取的一行记录
20                 string strLine = "";
21                 //记录每行记录中的各字段内容
22                 string[] aryLine = null;
23                 string[] tableHead = null;
24                 //标示列数
25                 int columnCount = 0;
26                 //标示是否是读取的第一行
27                 bool IsFirst = true;
28                 //逐行读取CSV中的数据
29                 while ((strLine = sr.ReadLine()) != null)
30                 {
31                     //strLine = Common.ConvertStringUTF8(strLine, encoding);
32                     //strLine = Common.ConvertStringUTF8(strLine);
33 
34                     if (IsFirst == true)
35                     {
36                         tableHead = strLine.Split(',');
37                         IsFirst = false;
38                         columnCount = tableHead.Length;
39                         //创建列
40                         for (int i = 0; i < columnCount; i++)
41                         {
42                             DataColumn dc = new DataColumn(tableHead[i]);
43                             dt.Columns.Add(dc);
44                         }
45                     }
46                     else
47                     {
48                         aryLine = strLine.Split(',');
49                         DataRow dr = dt.NewRow();
50                         for (int j = 0; j < columnCount; j++)
51                         {
52                             dr[j] = aryLine[j];
53                         }
54                         dt.Rows.Add(dr);
55                     }
56                 }
57                 if (aryLine != null && aryLine.Length > 0)
58                 {
59                     dt.DefaultView.Sort = tableHead[0] + " " + "asc";
60                 }
61 
62                 sr.Close();
63                 fs.Close();
64                 return dt;
65             }
66             catch (Exception ex)
67             {
68                 return null;
69             }
70         } 
71         #endregion