Hi,
I am using Infragistics 14 and one of the UltraWinGrids used in a winform (C#) app pulls more than a million rows. I need to know if I can use paging.
Paging seems to be there for web application but could not find for winform/wingrid.
I have tried the LoadOnDemand but that does not help at all. I tried it setting before assigning the datasource. The issue is DataSource itself is very huge so I would like to implement paging to limit the data pulled for the grid by the datasource. Currently since the datasource itself becomes gigantic sometimes the application crashed with out of memory exception.
I cant limit the no of rows. Tried filters too but still the data could very well be more than million rows and constantly growing.
Hello Bane,
I am just checking about the progress of this issue. Did Milko's suggestion helped you resolve it? Let me know if you need any further assistance on this issue.
Thank you for using Infragistics Components.
Thank you for posting in our forum.
Please let me know how you retrieve the data for your grid? Is it run time generated data or you get it form back end data base?
If you have the entire data loaded in the memory you may implement custom paging by retrieving only a small amount of rows and set them to the grid data source. Please check the attached sample solution where I have implement this approach.
Please consider also using UltraDataSource. Its CellDataRequest event is fired when the control bound to the UltraDataSource request value for a cell and the UltraDataSource does not have this value. More about load on demand capability of UltraDataSource you may find by following the next link http://help.infragistics.com/Help/Doc/WinForms/2015.1/CLR4.0/HTML/WinDataSource_Load_Data_on_Demand.html. Please check also CacheData property of UltraDataSource. If you set this property to false it will not cache any cell data and will try to retrieve the value of each cell on demand. Here you can find more about CacheData property http://help.infragistics.com/Help/Doc/WinForms/2015.1/CLR4.0/HTML/Infragistics4.Win.UltraWinDataSource.v15.1~Infragistics.Win.UltraWinDataSource.CellDataRequestedEventArgs~CacheData.html.
Please note if you have sorting or filtering logic implemented in your grid both these methods will not work.
Please let me know if you have any further queations.