Click here to Skip to main content
15,921,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to export tree view to excel file but i get this is error:
C#
/******************************Error Message*****************************
RegisterForEventValidation can only be called during Render();
*****************************Export Code*******************************/
private void ExportTree()
    {
        
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("content-disposition","attachment;filename="+Ddl_Companies.SelectedItem.Text +"----"+ Ddl_TreeType.SelectedItem.Text+".xls");
        Response.Charset = "";
        //this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        TreeNode tn=new TreeNode(Ddl_Companies.SelectedItem.Text +"----"+ Ddl_TreeType.SelectedItem.Text,"-1");
        Tv_Tree.Nodes.AddAt(0, tn);
        Tv_Tree.ExpandAll();
        Tv_Tree.ShowExpandCollapse = false;

        HtmlForm frm = new HtmlForm();
        Tv_Tree.Parent.Controls.Add(frm);
        frm.Attributes.Add("runat", "server");
        frm.Controls.Add(Tv_Tree);

        frm.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }
Posted
Updated 10-Jun-12 23:37pm
v3

1 solution

Hi, this is a similar discussion: please have a view: http://forums.asp.net/t/1222903.aspx[^].

An alternative is a research on export to excel: Exporting Data to Excel[^]
 
Share this answer
 

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