Hi all,

I am using the datagrid containing the template columns. I have the code for exporting datagrid to excel sheet. I also have the code for deleting the controls in the template column before exporting it to the datagrid. but I am still getting an error because I have bounded the template columns using databinder.eval

I want to export datagrid to excel sheet. will anybody help me in this matter.

Try the following and let me know if you have any problem


Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=QuotationList.xls");
Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.No Cache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

this.ClearControls(compareTable);

compareTable.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

Software proffesional from Bangalore,INDIA

hi,

when I used the above code. I got following error

Server Error in '/schedule' Application.
--------------------------------------------------------------------------------

The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).]
   System.Web.UI.ControlCollection.Add(Control child) +244
   schedule.timesheet.clearcontrols(Control control) +225
   schedule.timesheet.LinkButton1_Click(Object sender, EventArgs e) +203
   System.Web.UI.WebControls.LinkButton.OnClick(Event Args e) +108
   System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1263

hi swati !!

just remove

Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.Cache.SetCacheability(HttpCacheability.No Cache);

this two statements

it will work
u can further mail me and ask anythign : [email protected]

bye