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.

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,

Sandeep.M

Hi Sandeep,

You appear to be experiencing this issue because your Excel export link requires a full postback, but is configured to use an aynchronous postback.  This is because *all* postbacks within the DNN UpdatePanel wrapper are asynchronous unless you arrange otherwise.

I believe that you can remedy this issue by wrapping your control in a new UpdatePanel, and adding a <Trigger><asp:PostBackTrigger ControlID="YourExcelExportLinkControlId" /></Trigger> inside its body.

It may also be possible to add the trigger to the DNN UpdatePanel wrapper via code, but I am not sure offhand if the framework provides a good way to access this control.  It's not something that I've needed to do before.

Hope this points you in the right direction!

Brandon

Hi All,

I have solved the issue by pasting the following code in the page load function

If DotNetNuke.Framework.AJAX.IsInstalled Then

DotNetNuke.Framework.AJAX.RegisterScriptManager()

DotNetNuke.Framework.AJAX.WrapUpdatePanelControl(Me.pnlCompetencies, True)

DotNetNuke.Framework.AJAX.RegisterPostBackControl(Me.competencygridexport)

End If

pnlCompetencies is my panel and competencygridexport is my exportlink.Now i am able to export data but my paging events are not working now.

Any Help would be greatly appreciated.I have written the paging events as of like in the file manager.

Thanks,

Sandeep.M