The data grid 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/PDF file formats. It has also been optimized for working with millions of records as well as handling high frequency real-time updates.
Load millions of records instantly.
Data processing operations like sorting, filtering, grouping, summaries, refresh, and real-time update operations are handled efficiently using PLINQ.
The data grid is optimized for quickly exporting to Excel and PDF file formats.
Data binding works out of the box with all popular data sources like SQL Server, Oracle, and IEnumerable; and data providers like LINQ to SQL, ADO.NET, Entity Framework, and WCF Data Service.
Includes built-in support for validating cells and displaying error information based on IDataErrorInfo, INotifyDataErrorInfo, and DataAnnotations. The data grid also provides support for custom validations.
Sort data against one or more columns with multiple customization operations. An option is also included to sort by caption summary values when the grid is grouped.
Group data by one or more columns either programmatically or through mouse and touch interactivity.
The data grid has a 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.
Calculate and display sum, min, max, average, count, and custom aggregates in additional rows in a table or group.
The data grid 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 displayed in real-time scenarios.
Highlight search results and also filter records based on search text.
Change the height of the rows based on the content of any column or certain columns to enhance readability.
Merge cells in both horizontal and vertical directions. Adjacent cells with the same data can be merged into a single cell and display the data in the cell.
Freeze the rows and columns at the top, bottom, left, and right positions of the grid, similar to Excel.
Display rows at the top and bottom of the grid with data that is not bound to the ItemsSource.
Display stacked headers, which are unbound header rows that can span across multiple rows and columns.
Display additional columns that are not bound to data. The data grid also supports expressions, which are used to calculate values among columns.
A master-detail relationship is represented through nested grids that can be expanded and collapsed as required. The data grid also supports functionalities like editing, sorting, filtering, and more. Its flexibility allows unlimited levels of nesting.
Create records on demand by automatically enabling data virtualization.
Drag and drop columns within the grid, and even drag and drop between controls.
Provides advanced tooltip options to display multiple items, balloon styles, and custom appearances.
Improve the end user experience by adding custom context menu entries.
Built-in support for row-based selection similar to Excel, with extensive support for all keyboard navigation actions.
Settings in the grid can be serialized to XML format and loaded back through the built-in serialization options.
All static text in the data grid can be localized to any desired language.
Provides accessibility support to make applications available to a wide variety of users.