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