[Solved] Extending Export

[Ross]

I need to export my own propriatory xml format based on the dataitems of the grid.  This would be easy enough by simply iterating through the grid items, however the export functonality has some nice features, such as being able to ignore paging (by returning all items from the datasource).

So... is there any way to extend the grids export functionality?

If the answer to the above is no, then what is the best way to return all the dataitems from a grid (which ignores paging, but will honor any filters or sorting that have been applied)?

Thanks.

[Pavlina]

Hi Ross,

You can get the raw html of the grid, just attach a render delegate to the grid object and use its RenderControl method as follows:

C#

string GridRawHtml;

    protected void Page_Load(object sender, EventArgs e)
    {
        RadGrid1.SetRenderMethodDelegate(new RenderMethod(GetHtml));
    }

    protected void GetHtml(HtmlTextWriter writer, Control c)
    {
        StringWriter stringWriter = new StringWriter();
        HtmlTextWriter clearWriter = new HtmlTextWriter(stringWriter);
        RadGrid1.MasterTableView.RenderControl(clearWriter);
        string GridRawHtml = clearWriter.InnerWriter.ToString();
    }

I hope this suggestion will help you on the right track with your implementation.

All the best,
Pavlina
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.

[Ross]

Hi,

That is useful, but it won't solve the problem when I need to ignore paging.  The grids native export method calls several internal methods to make this possible which I can't call or override... to be clear on what I need to do...

1) User opens page with a grid of results, they filter them, sort, page through them as required
2) User clicks an export button, which needs to grab the grid data (not just those rows which are visiible, but all rows, including those on other pages).

An easy option would be to simply re-query my datasource, but I want the grid to do the work, maintaining any filters, sort orders etc.

[Pavlina]

Hi Ross,

To return all the dataitems from a grid you need to set the IgnorePaging property to true.
In your case instead of RadGrid1.ExportSettings.IgnorePaging = true I suggest that you use the code snippet bellow:
 
C#

 RadGrid1.AllowPaging = false;
    RadGrid1.Rebind();

Please give this suggestion a try and let us know how it goes.

Kind regards,
Pavlina
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.