WPF DataGrid - Syncfusion WPF UI Controls

The WPF DataGrid is a high performance control 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.

Features and Benefits of WPF DataGrid Control

High performance

• WPF DataGrid Instant loading - DataGrid can load millions of records instantly.
• WPF DataGrid Fast data processing - Data processing operations like sorting, filtering, grouping, summaries, and real-time updates are handled efficiently using PLINQ.
• WPF DataGrid Print and export - Quickly print and export the datagrid content to Excel or PDF file formats.

Data binding

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.

Seamless editing experience

• Use different 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.
• Built-in data error indication and validation to Validate cells and display error information.

WPF Editable DataGrid

Data operations

• 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 - 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. Learn more
• WPF DataGrid Filtering - Filter data with the filter row filter or an intuitive, built-in, Excel-inspired filtering UI. Learn more
• WPF DataGrid Summaries - Calculate and display sum, min, max, average, count, and custom aggregates in a table or group. Display summaries with different summary types

Selection and Clipboard operations

Select rows or cells in a similar way to Excel for all keyboard navigations.Also, perform clipboard operations such as cut, copy, and paste within a control and between other applications such as Notepad or Excel.

Selection in WPF DataGrid

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 Styles and Templates

Data virtualization

• WPF DataGrid Data virtualization - Create records on demand by automatically enabling data virtualization. Load millions of records of data instantly with virtualization enabled.
• WPF DataGrid Paging - Manipulate data using the SfDataPager control to view records in multiple pages. SfDataPager also supports on-demand loading of data.
• WPF DataGrid Incremental loading - Load data while horizontally scrolling (on-demand data loading). This is supported when the ItemsSource is derived from the ISupportIncrementalLoading interface. Manipulate data using the SfDataPager control to view records in multiple pages. SfDataPager also supports on-demand loading of data.

Exporting

• WPF DataGrid Excel, PDF, CSV export - Support to export the datagrid to Excel and pdf file formats with the rich set of options.
• WPF DataGrid Print - Support to print the datagrid with several printing customization options.

Related links

Learn More about WPF DataGrid

Download Free Trial

Pricing

View Demos

Samples

Community Forums

Documentation

Knowledge base

Suggest a Feature

About Syncfusion WPF Controls

Syncfusion's WPF controls library is the only suite that you will ever need to build an application since it contains over 95 high-performance, lightweight, modular, and responsive UI controls in a single package. In addition to DataGrid, we provide popular WPF Controls such as WPF Charts, WPF Scheduler, WPF Diagram, WPF Docking, and WPF PDF Viewer.

About Syncfusion

Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 29,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today we provide 1800+ controls and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP, JavaScript, .NET MAUI), and desktop development (WinForms, WPF, WinUI, UWP, Flutter, and .NET MAUI). We provide ready-to deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.

sales@syncfusion.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET