Databases
StackOverflow2013
Postsdbo
POExport more than 100000 rows to Excel - Infragistics Excel exporter
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExport more than 100000 rows to Excel - Infragistics Excel exporter
    primarykey
    data
    text
    <p>I am using <code>ultrawebgrid v11.1</code> with xml <code>LoadOnDemand</code> and paging enabled to load more than 100,000 records.</p> <p>I'd written <code>BindGrid()</code> functionality inside the <code>InitializeDataSource</code> event. </p> <p>In every postback(Save,ExcelExport,Load..) and/or partial postback(Page navigation,Sorting,filtering..), I am fetching more than 100,000 records from the database and setting the Grid's DataSource. </p> <p><strong>Issue 1:</strong></p> <p>Each time querying large amount of data from database is taking more time. Is there a way to query for the data only once <code>on load</code> and subsequently when the data in the grid is modified.</p> <p><strong>Issue 2:</strong></p> <p>I am using <code>UltrawebgridExcelExporter v11.1</code>. On click of Export button, Grid's data source is initialized inside <code>InitializeDataSource</code> with more than 100,000 records fetched from database.</p> <p>I have got to know that when xml <code>LoadOnDemand</code> is set, each time when I export to excel, I should set </p> <pre><code>AllowPaging = False and LoadOndemand = LoadOnDemand.NotSet </code></pre> <p>then bind the grid and Export.</p> <p>Fetching huge data from database is taking long time and binding it is taking even longer. After binding, while exporting to excel it is throwing <code>'System Out of Memory'</code> exception.</p> <p><strong>Issue 3:</strong></p> <p>I am not sure even after solving the issues above, will I be able to export more than 65535 rows in Excel 97-2003?</p> <p>How to optimize the performance of all the operations of the grid with the xml <code>LoadOnDemand</code>.</p> <p>Code:</p> <pre><code>Protected Sub UWGrid_InitializeDataSource(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.UltraGridEventArgs) Handles UWGrid.InitializeDataSource UWGrid.DataSource = dsData 'record set with 100000 rows. End Sub Protected Sub btnExportToExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExportToExcel.Click UWGrid.DisplayLayout.Pager.AllowPaging = False UWGrid.DisplayLayout.LoadOnDemand = LoadOnDemand.NotSet UWGrid.DataBind() 'Dim wBook As New Excel.Workbook(Excel.WorkbookFormat.Excel2007) UltraWebGridExcelExporter1.DownloadName = "ExportFile.xls" UltraWebGridExcelExporter1.Export(UWGrid) End Sub </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USEstefany Velez
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COSame question posted and answered on Infragistics forums: http://news.infragistics.com/forums/p/70018/354551.aspx#354551
      singulars
      1. POExport more than 100000 rows to Excel - Infragistics Excel exporter
      1. USroken
    2. CO@roken - well thats me there, and there is no answer to the question. This is a limitation from Infragistics.
      singulars
      1. POExport more than 100000 rows to Excel - Infragistics Excel exporter
      1. USEstefany Velez
    3. COWhat is in the call stack for #2 when you get the OutOfMemoryException? If it is happening when the exporter is writing the workbook to a memory stream, it may be possible to write the file to the file system instead when setting the ExportMode to Custom and then later read the file for download later.
      singulars
      1. POExport more than 100000 rows to Excel - Infragistics Excel exporter
      1. USalhalama
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload