I have about 120,000 rows in my grid and they are going to increase in number in short span. Currently its taking about 12 seconds to extract data from DB and painting it on the UI. But i want to optimize it more. I have seen there is a DisplayLayout.Pager api on WebGrid. Do we have something like that for UltraGrid for Window based Applications.
I want to load rows at the scroll of the scrollbar and not loading all the rows in one shot.
Hi,
The WinGrid does not have any paging functionality. Paging is really more of a web thing than a WinForms thing in my opinion.
But you can load grid data on-demand by using the UltraDataSource component as a sort've intermediary between the grid and your real data source. There's a sample included with NetAdvantage in the grid Samples Explorer and also as part of the UltraDataSource sample calling the million rows sample. This sample demonstrates displaying a WinGrid with a million rows by loading the rows on demand as they are needed.
Hi Mike,
I don't think i got you suggestion, can you be more specific, i have the same problem as ngaheer.
I have tones of entries in my DB, i don't want the use to see them all in one page or wait alot of time for it to load.
Can you please help?
Thanx,
Gilad, Intel ISRAEL
Hi Gilad,
By using the UltraDataSource component as your data source for the grid, you can load the data on-demand. The UltraDataSource fires events when it needs more data. This way you can load only the rows that the grid asks for instead of all of the data at once.
The Million Rows sample demonstrates how to do this - assuming you installed the samples.
Hi Steve,
Nothing has changed in this area. There is still no paging functionality in the grid.
I see this post was from 2008 and am curious if there is change with the new 2013 UltraWinGrid. Do you still not support paging for UltraWinGrid 2013? and Do I still need to use UltraDataSource to load data on demand? The problem with me is I need to pivot the data in the C# side before setting it to grid and there are too many rows so the total response time is 90 seconds for 283k rows inclduing pivoting.
I want to be able to fetch, say, top 10k rows, pivot it in C# and then display it in grid. Do the next 10k only when user scroll to the bottom of it. So on and so forth. What's the best way to implement this with UltraWinGrid 2013 version?