RadGrid - Cancel Export after GridExporting event

[Jason]

Hello,

I was wondering if it is possible to cancel the RadGrid's Export after the GridExporting event. 

I have figured out that I can save a file to the server during the GridExporting event, and after this occurs, I would like to cancel the rest of the normal process.

Any ideas?

Thanks in advance!

Jason

[Daniel]

Hello Jason,

I believe you can redirect to the same page to achieve the desired effect:

Response.Redirect(Request.Url.ToString());

Kind regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Paul]

The solution doesn't really cancel, it just reloads the page.  Is there a way to cancel the export (set the file to null or clear the response)? Basically I want to cancel the process and continue with the postback.

[Daniel]

Hello Paul,

Straight onto the answers:

The solution doesn't really cancel, it just reloads the page.
Yes, this is the actual result of my suggestion.

Is there a way to cancel the export (set the file to null or clear the response)?
No. In the best case you will face a blank page.

Basically I want to cancel the process and continue with the postback.
At this point (where you want to cancel the event) the server is in a process of generating the response to the client. Therefore (as I mentioned before) if you cancel it you will end up with an empty page because the output will be displayed on the screen instead of file stream.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Meenakshi]

Hello Daniel,

Is there any workaround for this pbm. I too want to do the same thing. In my GridExporting method, i am trying to open the outlook with the exported excel file as an attachment and i would like the user to stay on the same page without reloading.

Please let me know is there any workaround for this pbm.

Regards,
Meenakshi Sekar.

[Daniel]

Hi Meenakshi,

GridExporting event fires too late in the page lifecycle that's why you can't just "cancel" the export.

Regards,
Daniel
the Telerik team

[Meenakshi]

Thanks Daniel. 

Regards,
Meenakshi Sekar. 

[Najah]

I would like to get the XML of radgrid which has been generated in Grid Exporting event
e.ExportOutput

so that i can merge it with another Grid and then export manually to on Excel document with two sheets showing two different RadGrids data in ML format.


Regards,

[Daniel]

Hello Sana,

Yes, this is possible although not very straightforward. You can get the generated XMLSS code in the GridExporting event.

Best regards,
Daniel
the Telerik team

[Najah]

Yes i am already getting this XMl in Grid exporting event
gridXML = e.ExportOutput;

but after that immediately response of excel document sent back to the client. I try to stop that response to get another grid xml and to combined them together and then send it to client but no luck and i do not know how it will be done.

Regards, 

[Daniel]

Hello Sana,

The problem is not how to merge the contents but rather how to get the output from another grid. The export happens too late in the page lifecycle and it is not possible to export two controls to ExcelML in a single lifecycle. Indeed, you can save the first control's XMLSS data and then make a Response.Redirect to export the second one while keeping the data from the first one.
In such cases, it would be better to use the export infrastructure to manually traverse the controls (or their datasources directly) and build the desired structure.

Best regards,
Daniel
the Telerik team