Paging in WinForms GridGrouping with Filter Support | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (173).NET Core  (29).NET MAUI  (203)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (211)BoldSign  (13)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (65)Flutter  (132)JavaScript  (219)Microsoft  (118)PDF  (81)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (897)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (50)Windows Forms  (61)WinUI  (68)WPF  (157)Xamarin  (161)XlsIO  (35)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (8)Business intelligence  (55)Button  (4)C#  (146)Chart  (127)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (63)Development  (618)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (39)Extensions  (22)File Manager  (6)Gantt  (18)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (501)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (42)Performance  (12)PHP  (2)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (52)Security  (3)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (10)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (381)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (17)Web  (582)What's new  (323)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Paging in WinForms GridGrouping with Filter Support

image

Figure 1: Paging workflow in the GridGrouping control

 

When a large number of records is displayed in a grid, the records can be listed on many different pages. This typically means that a filter can only be applied to one page of records at a time.

However, there is a way filters can be applied to entire sets of records that span multiple pages using the Windows Forms GridGrouping control regardless of whether paging is enabled.

The Pager helper enables this by wiring the respective grid (GridGroupingControl) to its bound source (DataTable).

About Pager

Pager extracts the specific page from the bound data source and binds it to the GridGrouping control. With this specific feature, one may encounter a filtering restriction. This occurs because a grid can only control the records in the page bound to it, not all of the records in the bound data source. However, this limitation can be overcome through the engine by allowing it to handle the filtering separately. This can be done by wiring the respective view to the grid through a temporary table.

clip_image001

 

Figure 2: Paging-enabled GridGrouping control with 100 pages, each holding 1000 records (100,000 records in total)

 

How to wire?

The Pager can be wired to the GridGrouping control through the following settings:

clip_image003

The link below takes you to a sample that illustrates paging support in the GridGrouping control for a data table populated with 100,000 records.

Paging.zip

Tags:

Share this post:

Comments (2)

Hi,
I would like to download this file, how is this possible?

Hi Rafael,

You can download the sample from below location,
https://www.syncfusion.com/downloads/support/directtrac/249438/ze/gridgroupingcontrol-paging-671604880

We recommend to use SfDataGrid paging and you can refer below page for choosing between different Grid’s.
https://help.syncfusion.com/windowsforms/datagrid/overview#choose-between-different-grid-controls

User guide reference
https://help.syncfusion.com/windowsforms/datagrid/paging

Comments are closed.

Popular Now

Be the first to get updates

Subscribe RSS feed