MultiColumnGrouping for PTG mode in GGC.Web | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (172).NET Core  (29).NET MAUI  (192)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (209)BoldSign  (12)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (63)Flutter  (131)JavaScript  (219)Microsoft  (118)PDF  (80)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (882)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (49)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  (125)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (62)Development  (613)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (37)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  (488)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (41)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  (368)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (30)Visual Studio Code  (17)Web  (577)What's new  (313)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

MultiColumnGrouping for PTG mode in GGC.Web

In Essential Studio 2010 Vol. 3, we will support MultiColumnGrouping in PassThroughGrouping mode in the ASP.NET GridGroupingControl.

The performance of GridGroupingControl can be increased by using PassThroughGrouping DataSourceControl. PassThroughGrouping is a great way to take control of data being retrieved from the data source. In default mode, the grid will retrieve all the records from the data source and perform processes like sorting, grouping, and paging. But while using PassThroughGrouping, LINQ will take charge of the entire data retrieval and process part of grid. LINQ will do paging, sorting, and grouping by querying the data source, which leads to higher performance.

PassThroughGrouping mode can be enabled by using the PassThroughGrouping DataSourceControl. This can be added to the ASPX page, as shown in the following code: [ASPX]

The GridGroupingControl’s definition could be as follows: [ASPX]

<%
   1: --Grid Definition--
%>

    
    

<%
   1: --GridPager Definition--
%>

    
        
        
        
    

The screen shots below depict the improved performance of the PassThroughGrouping data source control:

image

MultiColumn Grouping Performance

 

image

MultiColumn Sorting Performance

Tags:

Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed
Scroll To Top