C# 从DataTable读取数据, 导出到CSV

找了很多不是很完善，自己记录一下吧

 /// <summary>
 /// DataTable数据写入CSV文件
 /// </summary>
 /// <param name="dt"></param>
 /// <param name="fullPath"></param>
 public static void SaveCSV(DataTable dt, string fileName)//table数据写入csv
 {
     FileStream fs;
     StreamWriter sw;
     string data = null;

     //判断文件是否存在,存在就不再次写入列名
     if (!File.Exists(fileName))
     {
         fs = new FileStream(fileName, FileMode.Create, FileAccess.Write);
         sw = new StreamWriter(fs, Encoding.UTF8);

         //写出列名称
         for (int i = 0; i < dt.Columns.Count; i++)
         {
             data += dt.Columns[i].ColumnName.ToString();
             if (i < dt.Columns.Count - 1)
             {
                 data += ",";//中间用，隔开
             }
         }
         sw.WriteLine(data);
     }
     else
     {
         fs = new FileStream(fileName, FileMode.Append, FileAccess.Write);
         sw = new StreamWriter(fs, Encoding.UTF8);
     }

     //写出各行数据
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         data = null;
         for (int j = 0; j < dt.Columns.Count; j++)
         {
             string str = dt.Rows[i][j].ToString();

             str = str.Replace(",", ";");
             str = str.Replace("\r", "");
             str = str.Replace("\n", "");

             data += str;
             if (j < dt.Columns.Count - 1)
             {
                 data += ",";//中间用，隔开
             }
         }
         sw.WriteLine(data);
     }
     sw.Close();
     fs.Close();
 }

 /// <summary>
 /// 读取CSV文件到DataTable
 /// </summary>
 /// <param name="filePath"></param>
 /// <returns></returns>
 public static DataTable OpenCSV(string filePath)//从csv读取数据返回table
 {
     DataTable dt = new DataTable();
     FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
     StreamReader sr = new StreamReader(fs, Encoding.UTF8);

     //记录每次读取的一行记录
     string strLine = null;
     //记录每行记录中的各字段内容
     string[] arrayLine = null;

     //判断，若是第一次，建立表头
     bool isFirst = true;

     //列的个数
     int dtColumns = 0;

     //逐行读取CSV文件
     while ((strLine = sr.ReadLine()) != null)
     {

         strLine = strLine.Trim();//去除头尾空格

         arrayLine = strLine.Split(',');//分隔字符串，返回数组

         if (isFirst)  //建立表头
         {
             dtColumns = arrayLine.Length;//列的个数
             for (int i = 0; i < dtColumns; i++)
             {
                 dt.Columns.Add(arrayLine[i]);//每一列名称
             }
             isFirst = false;
         }
         else   //表内容
         {
             DataRow dataRow = dt.NewRow();//新建一行
             for (int j = 0; j < dtColumns; j++)
             {
                 if (!string.IsNullOrEmpty(arrayLine[j].ToString()))
                 {
                     dataRow[j] = arrayLine[j];
                 }
                 else
                 {
                     dataRow[j] = DBNull.Value;
                 }
             }
             dt.Rows.Add(dataRow);//添加一行
         }
     }
     sr.Close();
     fs.Close();

     return dt;
 }