Intersoft Community - WebGrid Enterprise - Webgrid not Exporting All the Records in virtual Mode

Webgrid not Exporting All the Records in virtual Mode

yudi — Tue, 03 Jan 2017 03:31:47 GMT

Thank For the response Yudi. The Solution Provided is working.

Glad to know that the approach helps.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

Webgrid not Exporting All the Records in virtual Mode

sreeji.vijayan@pcctg.com — Mon, 02 Jan 2017 14:35:21 GMT

Thank For the response Yudi. The Solution Provided is working.

Webgrid not Exporting All the Records in virtual Mode

yudi — Thu, 15 Dec 2016 08:05:46 GMT

Do we have any update on the above ticket?

Sorry for the delay in sending this.

The ExportAllData will not work if VirtualLoadMode is set to Custom or LargeData. For such scenario, you might want to try this approach: re-creating the table that will be exported by utilizing OnExport server-side event of WebGrid.

WebGrid has OnExport server-side event which allows you to use your own exporting codes or module to handle exporting functionality.

I managed to export all data by modifying WebGridRowCollection such as shown in the following snippet code (please note that following snippet code works for WebGrid's data binding performed at OnInitializeDataSource event):

protected void WebGrid1_Export1(object sender, ExportEventArgs e)
{
    e.Table.Rows.Clear();

    DataRowCollection rows = (e.DataSource as System.Data.DataView).ToTable().Rows;

    foreach (DataRow row in rows)
    {
        var wgRow = e.Table.CreateRow();

        foreach (WebGridColumn col in e.Table.Columns)
        {
            if (!col.IsRowChecker)
            {
                wgRow.Cells.GetNamedItem(col.Name).Value = row[col.DataMember];
                wgRow.Cells.GetNamedItem(col.Name).Text = wgRow.Cells.GetNamedItem(col.Name).Value.ToString();
            }
        }

        e.Table.Rows.Add(wgRow);
    }
}

Please give it a spin and let us know how it works in your end.

Webgrid not Exporting All the Records in virtual Mode

sreeji.vijayan@pcctg.com — Mon, 21 Nov 2016 07:46:11 GMT

Hello Intersoft,

Do we have any update on the above ticket?

Thank You

Webgrid not Exporting All the Records in virtual Mode

sreeji.vijayan@pcctg.com — Mon, 14 Nov 2016 15:54:25 GMT

Hello,

We are using Intersoft Grid Version 9.0.7200.1. We are facing an issue with Export to excel feature,

The Export to excel feature is not exporting all the records, it is exporting only 100 rows when we set the

PagingMode="VirtualLoad" and VirtualPageSize="100" and PagingExportMode="ExportAllData".

Please let us know how to export all the records to Excel ASAP.

Thank You