Click here to Skip to main content
15,892,005 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am writing a code to export to excel a gridview. I am using updatepanel, so whole page doesnot loads. So, i wrote a code :

aspx.cs Code

C#
protected void Export_click(object sender, EventArgs e)
    {
        GridView gv = (GridView)TBMMasterContentPalceHolder.FindControl("myGridView");
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=Suppliers.xls");
        Response.Charset = "";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        gv.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();

    }
    public override void VerifyRenderingInServerForm(Control control) //To prevent Export To Excel Error
    {
    }


asp Code

ASP.NET
<asp:Button ID="btnExport" runat="server" Text="  Export  " OnClick="Export_click" />
<Triggers>
        <asp:PostBackTrigger ControlID="btnExport" />
</Triggers>


But here, i am getting the error in VerifyRenderingInServerForm(Control control) function. Error is :

no suitable method found to override

How to solve the error ?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900