If you are using Update Panel and try to Export gridview contents to EXCEL or Word, your asp.net page will throw the following error. ”Sys.WebForms.PageRequestManagerParserErrorException”
Its because AJAX & Response.write don’t go together. By calling Response.Write() directly you are bypassing the normal rendering mechanism of ASP.NET controls. The bits you write are going straight out to the client without further processing (well, mostly…). This means that UpdatePanel can’t encode the data in its special format.
There are couple of ways to solve this problem…
1. Place the Export Button outside of Update Panel.
2. By Pass the Export Button using <Triggers>
<asp:PostBackTrigger ControlID=”cmdExport” />
if your Export button is part of UserControl then specify usercontrolid:buttonid
<asp:PostBackTrigger ControlID=”uscSelCtl:cmdExport” />
Try to use Spire.DataExport (http://www.e-iceblue.com/Introduce/data-export-for-net-intro.html) – it is c# data export component that supports data export into MS Excel,MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format.
tks so much, that’s helpful with me
Glad It Helped 🙂
Wow, everyone here is just copying the same non-sense solution that someone else gave. Is there no creativity or intelligence around here? So frustrating seeing the same canned answer “word for word” in every solution page.
That was the way it worked for me 3 years ago… I just wrote it down! But was useful for a few people.