The WinUI 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 data virtualization. It has also been optimized for working with millions of records, as well as handling high-frequency, real-time updates.
The WinUI DataGrid can load millions of records instantly.
The WinUI DataGrid supports data processing operations like sorting, filtering, grouping, summaries, and real-time updates that are handled efficiently using the PLINQ.
Data binding works out of the box for all popular data sources. It automatically generates columns for a data-bound collection. It even assigns appropriate column types for specific data types.
Validate cells and display error information based on the following validation types:
Also, it’s possible to use:
Sort data against one or more columns with multiple customization operations. You can also sort by caption summary values when the grid is grouped, or by writing custom logic.
Group data by one or more columns either through mouse and touch interactivity in the group drop area or in code behind. Or group data with custom logic.
Filter data with the row filter or an intuitive, built-in, Excel-inspired filtering UI.
Calculate and display sum, min, max, average, count, and custom aggregates in a table or group. Display summaries with different summary types, such as:
The WinUI DataGrid control can handle 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.
Add a new record in an underlying collection with a built-in row. Place the new row at the top or bottom, or stick it at the top. It’s also possible to place a newly added row at the top or bottom in a data grid.
Delete selected records in a data grid by pressing the
Delete key. You can change it to another key instead of the default, too.
The WinUI DataGrid allows you to select rows or cells in a similar way to Excel for all keyboard navigations.
Customize the appearance of cells, rows, or columns based on data.
Users can adjust (auto fit) the row height based on the content of any column or certain columns to enhance the readability of content. It’s also possible to set the row height conditionally.
Users can freeze rows and columns at the top, bottom, left, and right positions, similar to in Excel. Horizontal and vertical scrolling can be performed, except on fixed columns and rows.
Display rows at the top and bottom of the grid with data that is not bound to the ItemsSource.
Stacked headers (column header span) allow users to show unbound header rows. They span the stacked header columns across multiple rows and columns.
Column width can be adjusted (auto fit) based on the content of any column or column header. All the columns can be fit within the viewport of the data grid.
A master-details view (nested grid view) can be represented through nested grids that can be expanded and collapsed. Functionalities like editing, sorting, filtering, and grouping are supported. Unlimited levels of nested grid relationships are allowed.
Create records on demand by automatically enabling data virtualization. Load millions of records of data instantly with virtualization enabled.
Load data while scrolling if the data source is derived from the ISupportIncrementalLoading interface.
The appearance of a data grid and its inner elements, such as rows, cells, columns, headers, and summary rows, can be customized easily by using styles and templates.
The WinUI DataGrid control provides an entirely custom context menu to expose functionality on the user interface. Users can create context menus for different rows such as a record row, summary row, and group caption header, in an efficient manner.
The WinUI DataGrid allows you to perform clipboard operations such as cut, copy, and paste within the control and between other applications such as Notepad or Excel.
Print the content of a data grid using the framework’s printing user interface. Users can easily customize their printing with several options such as print current page alone, choose custom page range, and so on.
Serialize the WinUI DataGrid’s settings to XML format and load back (deserialization) to DataGrid using the built-in serialization options.
Localize all the static default strings in the WinUI DataGrid to any desired language.
The WinUI DataGrid supports right-to-left (RTL) control rendering. Display text direction and layout from right to left.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.