Pass Through Grouping

Pass Through Grouping is a great way to limit the data being retrieved from the datasource. The grid's default setting pulls all the records in the underlying datasource to be enable effective grouping and summarizing. However, you can override this behavior using Pass Through Grouping and retrieve only the required records from the data source. Typically,these are the records required to display the current page. The grid could be bound to millions of records. By using Pass Through Grouping, desired number of records may be retrieved from the datasource based on page size.

Pass Through Grouping can be implemented on any datasource using any data retrieval technique. However, this method is ideally suited to retrieve data through LINQ. Pass Through Grouping using the LINQ data retrieval technique is elaborated in the next section.