Hi All,
I have a module which has different panels in a control and a tabbed interface.Based on this selection panels are shown.I used "Supports partial Rendering" for this control.Everything worked fine with the ajax functionality i mean when i click on tabs the corresponding panels are displayed without refreshing.But i added a link in the panels called "export to excel" and wrote its functionality.I get an excel file if i uncheck the option "Supports partial Rendering".But when i check that option since i want the panels to be shown without page refresh i have checked the partial rendering functionality.When this is checked i get the following error.The following is the sample code i have written for the link.
Protected Sub competencygridexport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles competencygridexport.Click
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=myexcelfile.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.Public)
Response.ContentType = "application /vnd.xls"
Dim StringWriter As New StringWriter
Dim htmlWrite As New HtmlTextWriter(StringWriter)
htmlWrite.RenderBeginTag(System.Web.UI.HtmlTextWriterTag.Html)
lstCompetencies.HeaderStyle.Font.Bold = True
lstCompetencies.GridLines = GridLines.Both
lstCompetencies.Columns(2).Visible = False
lstCompetencies.Columns(3).Visible = False
lstCompetencies.Columns(4).Visible = False
lstCompetencies.AllowPaging = False
lstCompetencies.AllowSorting = False
'Render(htmlWrite)
lstCompetencies.RenderControl(htmlWrite)
htmlWrite.RenderEndTag()
Response.Write(StringWriter)
Response.End()
End Sub
The error i get is a javascript popup which contains the following text in it.All the function executes fine and finally i get the javascriptpop up so i can say there is a pbm with this ajax stuff and not with my code since i am able to export it when the ajax functionality is disabled i mean "Supports partial rendering" is turned off.I think this is due to the line response.write in my code.What might be the problem and how to solve it.please help.
Sys.WebForms.PageRequestManagerParseErrorException: The message recieved from the server could not be parsed.Common causes for this error are when the response is modified by calls to Response.Write(),response filters,Http Modules, or server trace is enabled..so on.
Why is this occuring.please help.I really need the ajax functionality to be working but with this excel option i cannot.Its urgent.Thanks in advance.
Regards,
.netuser