.xls .txt文件生成下载

最新推荐文章于 2024-10-14 22:42:36 发布

hsc880202

最新推荐文章于 2024-10-14 22:42:36 发布

阅读量461

点赞数 1

文章标签： string 数据库 session server

本文链接：https://blog.csdn.net/hsc880202/article/details/6770288

版权

//在点击事件里完成 .txt文件

Response.Clear();
            Response.ClearHeaders();
            Response.BufferOutput = true;
            //Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.ContentEncoding = System.Text.Encoding.UTF8;

            string filename = "IP21实时数据库" + Label1.Text + "标签点";
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;   filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".txt");
            // Response.Write(GetTagsString("\r\n"));
            DataTable b = new DataTable();
            b = (DataTable)Session["aa"];
            string value = "";
            for (int i = 0; i < b.Rows.Count; i++)
            {
                value += b.Rows[i][0].ToString() + "\r\n";

}

            Response.Write(value);
            Response.Flush();
            Response.End();

//在点击事件里完成 .xls文件

Response.Clear();
        Response.Charset = "utf-8";
        string filename = "IP21实时数据库"+Label1 .Text +"";
        HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;   filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".xls");
        //Response.AddHeader("content-disposition", "attachment;filename=IP21实时数据库" + Label1.Text + ".xls");
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

        ExtraGridView1.AllowPaging = false;
        DATA();
        ExtraGridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();
        ExtraGridView1.AllowPaging = true;
        DATA();

如果报“ ExtraGridView”的控件“ExtraGridView1”必须放在具有 runat=server 的窗体标记

则在后台文件中重载VerifyRenderingInServerForm方法,如:
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}