aspx 通用的GridView 导出 Excel--保存或打开

#region Excel 输出     protected void btnExcel_Click(object sender, ImageClickEventArgs e)     {         this.GridView1.Visible = true;         PrepareGridViewForExport(GridView1);         string attachment = "attachment; filename=download.xls";         Response.ClearContent();         Response.AddHeader("content-disposition", attachment);         Response.ContentType = "application/ms-excel";         StringWriter sw = new StringWriter();         HtmlTextWriter htw = new HtmlTextWriter(sw);         GridView1.RenderControl(htw);         Response.Write(sw.ToString());         Response.End();         GridView1.Visible = false;     }

    public override void VerifyRenderingInServerForm(System.Web.UI.Control control)     {     }

    private void PrepareGridViewForExport(System.Web.UI.Control gv)     {         LinkButton lb = new LinkButton();         Literal l = new Literal();         string name = String.Empty;         for (int i = 0; i < gv.Controls.Count; i++)         {

            if (gv.Controls[i].GetType() == typeof(LinkButton))             {

                l.Text = (gv.Controls[i] as LinkButton).Text;

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            else if (gv.Controls[i].GetType() == typeof(DropDownList))             {

                l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            else if (gv.Controls[i].GetType() == typeof(System.Web.UI.WebControls.CheckBox))             {

                l.Text = (gv.Controls[i] as System.Web.UI.WebControls.CheckBox).Checked ? "True" : "False";

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            if (gv.Controls[i].HasControls())             {

                PrepareGridViewForExport(gv.Controls[i]);

            }

        }

    }     #endregion

 

注:

设计源代码部分 加上 EnableEventValidation="false"

如:<%@ Page Language="C#" MasterPageFile="~/Admin/Admin.master" AutoEventWireup="true" CodeFile="QueryResource.aspx.cs" Inherits="Admin_QueryResource" Title="Untitled Page" EnableEventValidation="false"%>

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值