iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hello Intersoft,
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
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.
or
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