error in exporting data into excel

[forumaic]

Hello,

I am trying to export data to excel from datagrid, and I am getting an
error: "The Controls collection cannot be modified because the control
contains code blocks (i.e. <% ... %>)."

Error details:
System.Web.Http Exception was unhandled by user code
Message="The Controls collection cannot be modified because the control
contains code blocks (i.e. <% ... %>)."
Source="System. Web"
ErrorCode=-2147467259
StackTrace:
at System.Web.UI.C ontrolCollectio n.Add(Control child)
at datawarehouse.i ndividual._defa ult.ClearContro ls(Control control) in
c:\Inetpub\wwwr oot\datawarehou se\individual\d efault.aspx.cs: line 131
at datawarehouse.i ndividual._defa ult.ClearContro ls(Control control) in
c:\Inetpub\wwwr oot\datawarehou se\individual\d efault.aspx.cs: line 123
at datawarehouse.i ndividual._defa ult.excelExport (Object sender,
ImageClickEvent Args e) in
c:\Inetpub\wwwr oot\datawarehou se\individual\d efault.aspx.cs: line 173
at System.Web.UI.W ebControls.Imag eButton.OnClick (ImageClickEven tArgs e)
at System.Web.UI.W ebControls.Imag eButton.RaisePo stBackEvent(Str ing
eventArgument)
at
System.Web.UI.W ebControls.Imag eButton.System. Web.UI.IPostBac kEventHandler.R aisePostBackEve nt(String
eventArgument)
at System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
at System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
at System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
------------------------------------------------------------------------------------------------

Code that I am using for export:

Code:

private void ClearControls(C ontrol control)
{
for (int i = control.Control s.Count - 1; i >= 0; i--)
{
ClearControls(c ontrol.Controls[i]);
}

if (!(control is TableCell))
{
if (control.GetTyp e().GetProperty ("SelectedItem" ) !=
null)
{
LiteralControl literal = new LiteralControl( );
control.Parent. Controls.Add(li teral); //on this
line I am getting an error
try
{
literal.Text =
(string)control .GetType().GetP roperty("Select edItem").GetVal ue(control,
null);
}
catch
{
//error msg
}

control.Parent. Controls.Remove (control);
}

else

if (control.GetTyp e().GetProperty ("Text") != null)
{
LiteralControl literal = new LiteralControl( );
control.Parent. Controls.Add(li teral);
literal.Text =
(string)control .GetType().GetP roperty("Text") .GetValue(contr ol, null);
control.Parent. Controls.Remove (control);
}
}
return;
}

public void excelExport(obj ect sender,
System.Web.UI.I mageClickEventA rgs e)
{
//export to excel
lblTitle.Text = "All individuals";

Response.Clear( );
Response.Buffer = true;
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
this.EnableView State = false;

System.IO.Strin gWriter oStringWriter = new
System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter oHtmlTextWriter = new
System.Web.UI.H tmlTextWriter(o StringWriter);

this.ClearContr ols(IndividualL ist1);
lblTitle.Render Control(oHtmlTe xtWriter);
IndividualList1 .RenderControl( oHtmlTextWriter );

Response.Write( oStringWriter.T oString());

Response.End();
}

Maybe have anybody ideas how to solve this problem and fix this error.

Thanks is advance.

A.