Ability to load millions of records instantly.
Data processing operations like sorting, filtering, grouping, summaries, refresh, and real-time update operations are handled efficiently using PLINQ.
Data binding works out of the box for all popular data sources. It automatically generates columns for the data-bound collection. It even assigns appropriate column types for the specific data types.
Support to sort data against one or more columns with multiple customization operations. There is also an option to sort by caption summary values when the grid is grouped.
Support for grouping data by one or more columns either programmatically or through touch interactivity.
Built-in support to calculate and display sum, min, max, average, count, and custom aggregates in additional rows in table or group.
Built-in Excel-inspired filter UI with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically.
Handles high frequency updates even under the most demanding scenarios where the data is sorted and grouped in real-time. The summaries are calculated in an optimized way and the updated summary is instantly refreshed in real-time usage scenarios.
Change the height of the rows based on the content of any column or certain columns to enhance the readability of content.
Ability to dynamically merge data in adjacent cells and present that data in a single cell.
Freeze the rows and columns at top, bottom, left, and right positions similar to Excel.
The ability to display rows at the top and bottom of the grid with data that is not bound to the ItemsSource.
Built-in support for displaying stacked headers, which are unbound header rows that can span across multiple rows and columns.
Provides support to display additional columns that are not bound to a datasource. Data grid can also display the result of expressions that are calculated based on values in other columns.
Ability to display records on demand by automatically enabling data virtualization when it is bound to a VirtualizingCollectionView
Ability to load data while scrolling, if the data source is derived from ISupportIncrementalLoading interface.
Interactive support for manipulating data using the SfDataPager control. It also supports on-demand loading.
Fully customizable using Microsoft Expression Blend and Visual Studio. It is possible to completely customize the cell and row appearance.
The column chooser UI can be selectively enabled to let end users interactively choose the visible columns. The default UI can also be customized as required.
Built-in support for row and cell-based selection similar to Excel.
Every static text in Syncfusion’s data grid can be localized to any desired language.