Wednesday Jun 16, 2010 at 09:30 PM
| Posted by:
| Category:
ASP.NET | LINQ
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]
<Syncfusion:PassThruGroupingDataSource ID="PassThruGroupingDataSource1" runat="server" GridGroupingControlID="GridGroupingControl1" SelectTable="Orders" SourceContext="DataClassesDataContext">
</Syncfusion:PassThruGroupingDataSource>
The GridGroupingControl’s definition could be as follows:
[ASPX]
<% 1: --Grid Definition--
%>
<Syncfusion:GridGroupingControl ID="GridGroupingControl1"
runat="server" AutoFormat="Office 2007 Blue" ShowGroupDropArea="True">
<TableDescriptor AllowNew="False" AllowEdit="false">
</TableDescriptor>
</Syncfusion:GridGroupingControl>
<% 1: --GridPager Definition--
%>
<Syncfusion:GridPager ID="GridPager1" PagingControlID="GridGroupingControl1" runat="server" Skin="Office2007Blue" PageSize="10" Width="600px">
<PagerItems>
<Syncfusion:NextPreviousGridPagerItem FirstPageText="<<" PreviousPageText="<" ShowFirstPageButton="true"
ShowPreviousPageButton="true" ShowLastPageButton="False" ShowNextPageButton="false" />
<Syncfusion:NumericGridPagerItem ButtonCount="7" />
<Syncfusion:NextPreviousGridPagerItem LastPageText=">>" NextPageText=">" ShowFirstPageButton="false"
ShowPreviousPageButton="false" ShowLastPageButton="true" ShowNextPageButton="true" />
</PagerItems>
</Syncfusion:GridPager>
The screen shots below depict the improved performance of the PassThroughGrouping data source control:
MultiColumn Grouping Performance
MultiColumn Sorting Performance
