包含CheckBox控件的DataGrid导出到EXCEL——终极方法

以下方法在VS2008中测试过

导出到Excel方法：

步骤一：后台添加如下代码

        public override void VerifyRenderingInServerForm(Control control)
        {
            //   base.VerifyRenderingInServerForm(control);  
        }

       

            //导出方法——DataGrid当前页的数据

       public void DataGirdtoExcel()

       {
            Response.Clear();
            Response.Buffer = true;
            Response.Charset = "GB2312";
            Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
            Response.ContentEncoding = System.Text.Encoding.UTF7;
            Response.ContentType = "application/ms-excel";
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
            DataGrid2.RenderControl(oHtmlTextWriter);
            Response.Output.Write(oStringWriter.ToString());
            Response.Flush();
            Response.End();

       }

步骤二：只能在执行 Render() 的过程中调用 RegisterForEventValidation(RegisterForEventValidation can only be called during Render(); ) 若弹出此错误

有两种方法可以解决以上问题：
1.修改web.config(不推荐)<pages enableEventValidation ="false" ></pages>

2.直接在导出Execl的页面修改

<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true"

 CodeFile="ExportGridView.aspx.cs" Inherits="ExportGridView" %>