由Datatable生成 csv 文件

 public void ExportToCsv(System.Data.DataTable dt, string strFileName)
        {
            //strFileName，"d:\test\test.csv"
            CommonF cf = new CommonF();
            //string strPath = Server.MapPath(strFileName).ToString();
            string strPath = strFileName;
            //Response.Write(strPath);
            //Response.End();
            if (File.Exists(strPath))
            {
                File.Delete(strPath);
            }
            //else {
            //    Response.Write("Hello");
            //    return;
            //}
            //Export Head
            StringBuilder strColu = new StringBuilder();
            StringBuilder strValue = new StringBuilder();
            int i = 0;
            try
            {
                StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("iso-8859-1"));

                for (i = 0; i <= dt.Columns.Count - 1; i++)
                {
                    strColu.Append(dt.Columns[i].ColumnName);
                    
                    strColu.Append(",");
                }
                strColu.Remove(strColu.Length - 1, 1);//Remove last ','
                strColu = cf.StringReplace_Out(strColu, site);
                sw.WriteLine(strColu);
               
                foreach (DataRow dr in dt.Rows)
                {
                    strValue.Remove(0, strValue.Length);//remove

                    for (i = 0; i <= dt.Columns.Count - 1; i++)
                    {
                        strValue.Append(dr[i].ToString());
                        strValue.Append(",");
                    }
                    strValue.Remove(strValue.Length - 1, 1);//Remove last ','
                    sw.WriteLine(strValue);
                }

                sw.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            System.Diagnostics.Process.Start(strPath);
        }