We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

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.


Instant loading illustration for WinUI datagrid

Instant loading

DataGrid can load millions of records instantly.

Fast data processing of WinUI datagrid illustration

Fast data processing

Data processing operations like sorting, filtering, grouping, summaries, and real-time updates are handled efficiently using PLINQ.


Data binding

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.

Data binding illustration for WinUI datagrid


Seamless editing experience

  • Use different built-in column types such as ComboBox, CheckBox, and TextBox.
  • Embed any control, such as a progress bar or rating, to view or edit the data in a cell.
  • Commit or rollback changes when the data object implements IEditableObject.
  • Add new records dynamically.

Editing with date picker in WinUI datagrid


Built-in data error indication and validation

Validate cells and display error information based on the following validation types:

  • INotifyDataErrorInfo
  • Data Annotations

Also, it’s possible to use:

  • Cell validation
  • Row validation

Data validation in WinUI datagrid


Data operations

Multicolumn sorting in WinUI datagrid

Sorting

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.

WinUI datagrid shows columns grouping

Grouping

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.

Excel-like filtering in WinUI datagrid

Filter

Filter data with the filter row filter or an intuitive, built-in, Excel-inspired filtering UI.

WinUI datagrid shows summary rows

Summaries

Calculate and display sum, min, max, average, count, and custom aggregates in a table or group. Display summaries with different summary types, such as:

  • Total or table summary
  • Group summary
  • Summary in group caption or header

Real time updates

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.

Real time update in WinUI datagrid


Data manipulation

Built-in add new row in WinUI datagrid

Built-in add new row

Add a new record in an underlying collection with a built-in row. Place the added 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 datagrid.

WinUI datagrid delete row

Delete row

Delete selected records in a datagrid by pressing the Delete key. You can change it to another key instead of the default, too.


Selection

Select rows or cells in a similar way to Excel for all keyboard navigations.

Selection in WinUI datagrid


Conditional formatting

Customize the appearance of cells, rows, or columns based on data.

Conditional formatting in WinUI datagrid


Row and column customization

Auto fitted row height in WinUI datagrid

Row height

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.

WinUI datagrid shows frozen rows and columns

Freeze panes

Users can freeze rows and columns at the top, bottom, left, and right positions, similar to Excel. Horizontal and vertical scrolling can be performed, except on fixed columns and rows.

WinUI datagrid shows unbound rows

Unbound row

Display rows at the top and bottom of the grid with data that is not bound to the ItemsSource.

WinUI datagrid shows stacked headers

Stacked headers

Stacked headers (column header span) allow users to show unbound header rows. They span the stacked header columns across multiple rows and columns.


Column sizing

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 datagrid.


Master-details view

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.

Master details view of WinUI datagrid


Data virtualization

Create records on demand by automatically enabling data virtualization. Load millions of records of data instantly with virtualization enabled.


Incremental loading

Ability to load data while scrolling, if the data source is derived from ISupportIncrementalLoading interface.

Incremental loading in WinUI datagrid


Appearance style

The appearance of a datagrid and its inner elements, such as rows, cells, columns, headers, and summary rows, can be customized easily by using styles and templates.

Styling in WinUI datagrid


Context menu

The WinUI DataGrid control provides an entirely custom context menu to expose the functionality on the user interface. Users can create context menus for different rows such as record row, summary row, and group caption header in an efficient manner.

Styling in WinUI datagrid


Clipboard operations

Perform clipboard operations such as cut, copy, and paste within a control and between other applications such as Notepad or Excel.


Serialization

Serialize the WinUI datagrid settings to XML format and load back (deserialization) to datagrid using the built-in serialization options.


Localization

Localization of WinUI datagrid

Localization

Localize all the static default strings in the WinUI datagrid to any desired language.

Right to Left of WinUI datagrid

Right to left (RTL)

WinUI DataGrid supports right-to-left (RTL) control rendering. Display text direction and layout from right to left.


Syncfusion WinUI DataViz & UI Controls

Awards

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.

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon