The UWP DataGrid control is used for efficiently displaying and manipulating tabular data. Its rich feature set includes functionalities like data binding, editing, sorting, filtering, grouping, and exporting to Excel and PDF file formats. It has also been optimized for working with millions of records, as well as handling high frequency real-time updates.
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.
Optimized for quickly printing and exporting to Excel/PDF file formats.
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 mouse and touch interactivity.
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.
Built-in support to calculate and display sum, min, max, average, count, and custom aggregates in additional rows in a table or group.
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.
Ability to customize cell and row appearance conditionally based on data.
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.
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, unbound header rows that can span across multiple rows and columns.
Provides support to display additional columns that are not bound to a data source. It can also display the results of expressions that are calculated based on values in other columns.
Master-detail relationship is represented through nested grids that can be expanded and collapsed as required. It also supports functionalities like editing, sorting, filtering, etc. Its flexibility allows unlimited levels of nesting.
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 to manipulate the data using 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.
Built-in support to drag and drop rows. Also supports drag-and-drop between controls.
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.
Improve the end user experience by adding custom context menu entries.
Built-in support for row and cell-based selection similar to Excel, with extensive support for all keyboard navigations.
Settings in the grid can be serialized to XML format and loaded back through the built-in serialization options.
Any static text in the data grid can be localized to any desired language.