【C#工具类】生成CSV文件

生成CSV：

 public static void CreateCSVWithCommaByDataTableAndFilePath(DataTable dt, string FilePath)
        {
            try
            {
                //HttpContext.Current.Response.Clear();
                //HttpContext.Current.Response.AddHeader(
                //    "content-disposition", string.Format("attachment; filename={0}", FileName));        
                //HttpContext.Current.Response.ContentType = "application/vnd.xls";
                //HttpContext.Current.Response.ContentEncoding = System.Text.UTF8Encoding.Default;  

                FileStream fileStream = new FileStream(FilePath, FileMode.OpenOrCreate
                    );
                StreamWriter sw = new StreamWriter(fileStream, System.Text.UTF8Encoding.Default);

                string colHeaders = "", ls_item = "";
                DataRow[] myRow = dt.Select();
                int i = 0;
                int cl = dt.Columns.Count;
                for (i = 0; i < cl; i++)
                {
                    if (i == (cl - 1))
                    {
                        colHeaders += dt.Columns[i].Caption.ToString() + "\r\n";
                    }
                    else
                    {
                        colHeaders += dt.Columns[i].Caption.ToString() + ",";
                    }
                }
                //HttpContext.Current.Response.Write(colHeaders);
                sw.Write(colHeaders);
                foreach (DataRow row in myRow)
                {
                    for (i = 0; i < cl; i++)
                    {
                        if (i == (cl - 1))
                        {
                            ls_item += row[i].ToString() + "\r\n";
                        }
                        else
                        {
                            ls_item += row[i].ToString() + ",";
                        }
                    }
                    //HttpContext.Current.Response.Write(ls_item);
                    sw.Write(ls_item);
                    ls_item = "";
                }
                //HttpContext.Current.Response.End();
                sw.Close();
                fileStream.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }