iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Latest Development Blogs
Browse By Tag
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.
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)
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)
wgRow.Cells.GetNamedItem(col.Name).Value = row[col.DataMember];
wgRow.Cells.GetNamedItem(col.Name).Text = wgRow.Cells.GetNamedItem(col.Name).Value.ToString();
Please give it a spin and let us know how it works in your end.
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.
Forgot your password | Sign up
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Already a member? Sign in