GridView导出EXCEL问题

Question

问题描述：有一个GridView，需要把里面的内容导出到EXCEL里。GridView里有checkbox控件。现在在导出得时候系统报错（F5调试，设断点），错误提示如下：“只能在执行 Render() 的过程中调用 RegisterForEventValidation；”。个人认为是checkbox引起的，但不知道怎么解决。请大家指点下。导出的代码如下：

 

private void ToExcel( GridView gvToExcel )
{
            Response.ClearContent();
            Response.AddHeader( "content-disposition", "attachment; filename=QDL" + DateTime.Now.ToString( "yyyyMMdd" ) + ".xls" );
            Response.Charset = "gb2312";
            Response.ContentType = "application/excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter( sw );

            gvToExcel.AllowPaging = false;
            DataBound();

            gvToExcel.RenderControl( htw );     错误出在这一行
            Response.Write( sw.ToString() );
            Response.End();

            gvToExcel.AllowPaging = true;
            DataBound();
}

public override void VerifyRenderingInServerForm( Control control )
{

}

Answer 1

解决办法和代码参见
http://hi.baidu.com/ly_baidu/blog/item/683cdca264701ca9caefd070.html

Answer 2

 

在导出前，调用下这个方法，把textbox加进去就好了。

 

private void DisableControls(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.GetType() == typeof(LinkButton))
        {
            l.Text = (gv.Controls as LinkButton).Text;
            gv.Controls.Remove(gv.Controls);
            gv.Controls.AddAt(i, l);
        }
        else if (gv.Controls.GetType() == typeof(DropDownList))
        {
            l.Text = (gv.Controls as DropDownList).SelectedItem.Text;
            gv.Controls.Remove(gv.Controls);
            gv.Controls.AddAt(i, l);
        }

        if (gv.Controls.HasControls())
        {
            DisableControls(gv.Controls);
        }
    }
}