Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (141).NET Core  (21)Angular  (37)ASP.NET  (47)ASP.NET Core  (52)ASP.NET MVC  (83)Azure  (26)Blazor  (42)DocIO  (18)Essential JS 2  (63)Essential Studio  (158)Flutter  (37)JavaScript  (131)Microsoft  (95)PDF  (46)React  (28)Succinctly series  (118)Syncfusion  (371)TypeScript  (30)Uno Platform  (2)UWP  (4)Vue  (24)Webinar  (12)Windows Forms  (52)WPF  (84)Xamarin  (101)XlsIO  (19)Other CategoriesBarcode  (4)BI  (29)Bold BI  (3)Build conference  (6)Business intelligence  (53)Button  (4)C#  (97)Chart  (36)Cloud  (8)Company  (445)Dashboard  (4)Data Science  (3)Data Validation  (2)DataGrid  (25)Development  (232)Doc  (7)eBook  (89)Enterprise  (22)Entity Framework  (4)Essential Tools  (14)Excel  (10)Extensions  (6)File Manager  (3)Gantt  (6)Gauge  (3)Git  (3)Grid  (24)HTML  (8)Installer  (1)Knockout  (2)LINQPad  (1)Linux  (1)M-Commerce  (1)Metro Studio  (11)Mobile  (123)Mobile MVC  (9)OLAP server  (1)Orubase  (12)Partners  (20)PDF viewer  (14)PHP  (1)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (5)Road Map  (9)Scheduler  (12)SfDataGrid  (7)Silverlight  (21)Sneak Peek  (10)Solution Services  (2)Spreadsheet  (2)SQL  (3)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (8)Tips and Tricks  (10)UI  (51)Uncategorized  (68)Unix  (2)User interface  (38)Visual State Manager  (1)Visual Studio  (12)Visual Studio Code  (6)Web  (77)What's new  (44)Windows 8  (19)Windows App  (1)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)
Share on twitter
Share on facebook
Share on linkedin

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:

Share on twitter
Share on facebook
Share on linkedin

Leave a comment

Popular Now

Be the first to get updates

Subscribe RSS feed
Scroll To Top