export GridView to excel

最近开始整理GridView绑定数据的方法

刚好在网上看到一支GridView数据写入excel的方法

故而将传好的数据使用打开excel

却卡了一下午也没有debug成功。。。

下面附上代码：

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.IO;
using System.Globalization;

public partial class GridView_GridView : System.Web.UI.Page
{
        string source = WebConfigurationManager.ConnectionStrings["KPRCSConnectionString"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
                GridBind();
        }
        protected void GridBind()
        {
                SqlConnection conn = new SqlConnection(source);
                conn.Open();
                string select = "select * from Relabel";
                SqlDataAdapter da = new SqlDataAdapter(select, conn);
                DataSet ds = new DataSet();
                da.Fill(ds);
                GV1.DataSource = ds;
                GV1.DataBind();
        }
        protected void GV1_pageIndexChanging(object sender, GridViewPageEventArgs e)
        {
                GV1.EditIndex = -1;
                GV1.PageIndex = e.NewPageIndex;
                GridBind();
        }
        public override void VerifyRenderingInServerForm(Control control)
        {
                //注释掉下面的代码，否则在asp.net2.0下会报错（注：GridView是asp.net 2.0下的控件，1.1下一些控件也可以导出成Excel或者Word）
                //base.VerifyRenderingInServerForm(control);
        }

        protected void expExcel_Click(object sender, EventArgs e)
        {
                Response.Clear();
                Response.BufferOutput = true;
                Response.Charset = "GB2312";
                Response.AppendHeader("Content-Dispositio", "p_w_upload;filename=FileName.xls");
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
                Response.ContentType = "application/ms-excel";
                EnableViewState = false;
                CultureInfo cultureInfo = new CultureInfo("ZH-CN", true);
                StringWriter stringWriter = new StringWriter(cultureInfo);
                HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter);
                GV1.RenderControl(textWriter);
                Response.Write(textWriter.ToString());
                Response.End();
        }
}

 

错误如下：RegisterForEventValidation 只能在 Render(); 期間呼叫

根据搜索找到的问题解决方法如下：

1：在.aspx的页面题头<%Page ...>的地方添加EnableEventValidation = "false" AutoEventWireup="true"，怀着侥幸的心理debug了下，却伤心的遇到了下面的问题，web页面上显示如下：

文件的最上層無效。處理資源 'http://localhost:6075/mySkills/GridView/GridView.aspx' 發生錯誤。第 1 行, 位置 1

转载于:https://blog.51cto.com/larkin/518769