將DataSet匯出,格式為”CSV”

public static string ExportCSV(DataSet ds)
        {
            string data = "";
            foreach (DataTable tb in ds.Tables)
            {
                //寫出列名
                foreach (DataColumn column in tb.Columns)
                {
                    data += column.ColumnName + ",";
                }
                data += "\n";
                //寫出資料
                foreach (DataRow row in tb.Rows)
                {
                    foreach (DataColumn column in tb.Columns)
                    {
                        data += row[column].ToString() + ",";
                    }
                    data += "\n";
                }
                data += "\n";
            } return data;
        }

                string data = Export.ExportCSV(ds);
                Response.Clear();
                Response.Buffer = true;
                Response.Charset = "GB2312";
                Response.AppendHeader("Content-Disposition", "attachment;filename=資料匯出.csv");
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//設定輸出資料流為簡體中文
                Response.ContentType = "application/csv";
                Response.Write(data);
                Response.End();