Hi,
i'm using wingrid (version 10.3) to display more than 1.000.000 rows. Data are loaded on demand from SQLite database.
Is there any possibility to switch on summaries, but not to load all data? For example, sorting and filter have mode 'External' which gives possibility to realize my own filtering and sorting.
May be that is realized in newer versions of wingrid?
Thank you for your feedback.
Please let me know if you need my further assistance, after you upgrade.
Hi, thank you very much for you kind help.
I'm using version 10.3 at this moment. I'll upgrade soon and try that functionality
Hello Sergey,
I am just checking about the progress of this issue. Let me know if you need my further assistance on it.
Thank you for using Infragistics Components
Thank you for contacting Infragistics Support.
Yes you can use external summary value in UltraGrid. What you need to do is first set the Summary type to External using Add method on the Summaries collection. You can use code like this:
this.ultraGrid1.DisplayLayout.Bands[0].Summaries.Add( SummaryType.External, BandColumn );
When the summary type is set to External, the ExternalSummaryValueRequested event is fired. This event exposes a SetExternalSummaryValue method that is used to set the summary value. Please note to use External summary value you need to be able to calculate this value in advance, e.g. you can get it from database. More about External Summary Calculations you can find by following the next link http://help.infragistics.com/Help/Doc/WinForms/2012.2/CLR4.0/HTML/WinGrid_Performing_External_Summary_Calculations.html
Please check attached sample solution implementing UltraGrid with Summary type set to External.
Please let me know if this is what you are looking for or if I am missing something.