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


High Performance

The WPF DataGrid loads millions of records in just a second without any performance degradation with the help of row and column virtualization

High Performance WPF DataGrid

Instant loading

The WPF DataGrid can load millions of records instantly.

High Performance WPF DataGrid

Fast data processing

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

High Performance WPF DataGrid Printing

Quickly print and export the WPF DataGrid to Excel, CSV, and PDF file formats.


Data binding

The WPF DataGrid has data-binding support to work out-of-the-box with all popular data sources like SQL server, Oracle, DataTable, and IEnumerable, and data providers like LINQ to SQL, ADO.NET, Entity Framework, and WCF Data Service.

WPF DataGrid Data Binding


Seamless editing experience

  • 15+ built-in column types such as ComboBox, DateTime, and MultiColumn DropDown.
  • 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.

WPF DataGrid Editing


Built-in data error indication and validation

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

Also, it’s possible to use:

  • Cell validation
  • Row validation
  • Custom validation

Data Validation in WPF DataGrid


Data operations

Multi-column Sorting in WPF 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.

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

Filtering WPF DataGrid like in Excel

Filter

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

WPF DataGrid with Summary Rows

Summaries

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

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

Data manipulation

Real-time updates in WPF DataGrid

Real time updates

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

WPF DataGrid - Add New Row

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.

WPF DataGrid - Delete Row

Delete row

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

WPF DataGrid Search

Search and highlight text in the WPF DataGrid and filter records based on the search text.


Selection

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

Selection in WPF DataGrid


Conditional formatting

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

Conditional Styling in WPF DataGrid


Row and column customization

Auto-Fit Row Height in WPF 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.

WPF DataGrid with Freeze Panes

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.

WPF DataGrid with Unbound Column

Unbound column

Display additional columns that are not bound to data. The control supports an expression to calculate values among columns.

WPF DataGrid with Unbound Rows

Unbound row

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

WPF DataGrid - Merge Cells

Cell merging

Dynamically merge data in adjacent cells and present that data in a single cell. Merge data based on content by writing your own custom logic.

WPF DataGrid with Stacked Header Rows

Stacked headers

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


Column auto sizing

The WPF DataGrid provides auto sizing options like auto-fit columns based on content, fit all columns within a view port, fill the last column to view port size, etc.


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.

WPF DataGrid - Master Details View


Record template view

Display the additional information of a row using a template. View the record template by expanding and collapsing the record as required.

WPF DataGrid - Row Details View


Data virtualization

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


Incremental loading

Load data while horizontally scrolling (on-demand data loading). This is supported when the ItemsSource is derived from the ISupportIncrementalLoading interface.

On-demand data loading in WPF DataGrid


Paging

Manipulate data using the DataPager control to view records in multiple pages. DataPager also supports on-demand loading of data.

Data Paging in WPF 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.

WPF DataGrid Styling


Row drag and drop

Drag and drop rows within WPF DataGrid or between controls.

WPF DataGrid Reorder Rows


Column chooser

Users can change the visibility of columns at runtime using the customizable column chooser UI. 

WPF DataGrid with Column Chooser


Context menu

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

WPF DataGrid with Context Menu


Clipboard operations

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


Exporting

WPF DataGrid to Excel and PDF

Excel, PDF, CSV export

Easily export the WPF DataGrid control to various file formats such as Excel, PDF, or CSV.

WPF DataGrid Printing

Print

Support to print the DataGrid with several printing customization options.


Serialization

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


Localization

WPF DataGrid Localization

Localization

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

Right to Left in WPF DataGrid

Right to left (RTL)

Supports right to left (RTL) direction for users working in right-to-left languages like Hebrew, Arabic, or Persian.


UI Automation

The WPF DataGrid control is compatible with Coded UI and UFT (formerly QTP) automation tools to automate the application with the DataGrid control.

UI automation illustration for WPF DataGrid


100+ WPF CONTROLS

Read independent,
authenticated reviews
on G2

Download Now Pricing

What do our customers say about us?

double quotes

I work for an electrical instruments plant. I purchased the Gantt control from Syncfusion. It has saved me many hours as well as stores our information more efficiently… now.
Marco Del Frate

Marco Del Frate

Tecnel SRL

double quotes

I am really thankful for the wonderful set of controls for WPF. I was able to deliver things on time and could focus on core business logic rather than control development.
Umair Ahmed

Umair Ahmed

Technical Lead at Vercom

Transform your applications today by downloading our free evaluation version Download Free Trial

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