Database 导出CSV格式

 public void ExportCSV(DataSet ds)
    {
        try
        {
            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";
            }
            Response.ContentEncoding = Encoding.GetEncoding("gb2312");
            string rename = HttpUtility.UrlEncode("通讯录", Encoding.GetEncoding("utf-8"));
            Response.ClearHeaders();
            Response.AppendHeader("Content-disposition", string.Format("attachment;filename={0}.csv", rename));
            Response.Write(data);
            Response.End();
        }
        catch
        { }
    }