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. Image for the cookie policy date
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 been optimized for working with millions of records, as well as handling high-frequency, real-time updates.


WinUI DataGrid instant loading illustration.

Instant loading

The WinUI DataGrid can load millions of records instantly.

WinUI DataGrid fast data processing illustration.

Fast data processing

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

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.

WinUI DataGrid data binding illustration.


Seamless editing experience

  • Use different built-in column types such as combo box, checkbox, date, and text box.
  • 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.

WinUI DataGrid editing.


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

WinUI DataGrid data validation.


Data operations

WinUI DataGrid sorting.

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

WinUI DataGrid filter like Excel.

Filter

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

WinUI DataGrid 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.

WinUI DataGrid Real Time Update


Data manipulation

WinUI DataGrid add new row.

Built-in add new row

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.

WinUI DataGrid delete row.

Delete row

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


Selection

The WinUI DataGrid allows you to select rows or cells in a similar way to Excel for all keyboard navigations.

WinUI DataGrid selection.


Conditional formatting

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

WinUI DataGrid conditional styling.


Row and column customization

WinUI DataGrid auto fit row height.

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 freeze panes.

Freeze panes

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.

WinUI DataGrid with unbound rows.

Unbound rows

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

WinUI DataGrid with 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 data grid.


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.

WinUI DataGrid showing master-details view.


Data virtualization

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


Appearance style

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.

WinUI DataGrid style.


Context menu

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.

WinUI DataGrid context flyout.


Clipboard operations

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.


Row drag and drop

The WinUI DataGrid allows you to drag and drop the rows between datagrid and other controls such as ListView, SfTreeView, and SfTreeGrid. You can also select and drag multiple rows when the SelectionMode is multiple or extended.

WinUI DataGrid Row drag and drop.


Serialization

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


Right to left (RTL)

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

WinUI DataGrid right to left.


Localization

Localize all the static default strings in the WinUI DataGrid to any supported language.

WinUI DataGrid localization.


WinUI DataGrid Code Example

Easily get started with the WinUI DataGrid using a few simple lines of XAML and C# code example as demonstrated below. Also explore our WinUI DataGrid Example that shows you how to render and configure the DataGrid in WinUI.

<Page
    x:Class="GettingStarted.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:local="using:GettingStarted"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    xmlns:dataGrid="using:Syncfusion.UI.Xaml.DataGrid"
    mc:Ignorable="d"
    Background="{ThemeResource ApplicationPageBackgroundThemeBrush}">
    <Grid x:Name="rootGrid">
    <dataGrid:SfDataGrid x:Name="sfDataGrid" />
    </Grid>
</Page>
using Syncfusion.UI.Xaml.DataGrid;
namespace GettingStarted
{
    /// <summary>
    /// An empty page that can be used on its own or navigated to within a Frame.
    /// </summary>
    public sealed partial class MainPage : Page
    {
        public MainPage()
        {
            this.InitializeComponent();
            SfDataGrid sfDataGrid = new SfDataGrid();
            rootGrid.Children.Add(sfDataGrid);
        }
    }
}



Syncfusion WinUI DataViz & UI Controls

Frequently Asked Questions

  • Instantly load large amounts of data.
  • Handle high-frequency updates even for demanding scenarios.
  • Build complex, large-scale applications with features such as seamless editing, grouping, sorting, filtering, and summaries out of the box.
  • Load more rows continuously with infinite or endless scrolling.
  • Interact with the software with rich UI interaction and keyboard navigation.
  • Work with a simple configuration and APIs.
  • Incorporate a touch-friendly and responsive control in your apps.
  • Access extensive demos and documentation to learn quickly and get started with WinUI DataGrid.

We do not sell WinUI DataGrid separately. It is only available for purchase as part of the Syncfusion WinUI suite, which contains an ever-growing set of native WinUI components, including DataGrid. A single developer license for the Syncfusion Essential Studio for WinUI suite costs $795.00 USD, including one year of support and updates. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team to see if you qualify for any additional discounts.

You can find our WinUI DataGrid demo here.

No, our WinUI components, including DataGrid, are not sold individually, only as a single package. However, we have competitively priced the package so it only costs a little bit more than what some other vendors charge for their DataGrid alone. We have also found that, in our experience, our customers usually start off using one of our products and then expand to several products quickly, so we felt it was best to offer all the WinUI components for a flat fee of $795/developer. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team to see if you qualify for any additional discounts.

No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.

A good place to start would be our comprehensive getting started documentation.

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.

Up arrow 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