The WinForms DataGrid control is used to efficiently display and manipulate tabular data. Its rich feature set includes data binding, editing, sorting, filtering, grouping, and exporting to Excel/PDF file formats and more. It has also been optimized for working with millions of records as well as handling high frequency real-time updates.
Load millions of records instantly.
Data processing operations like sorting, filtering, grouping, summaries, and real-time updates are handled efficiently using PLINQ.
Quickly export the data grid content to Excel or PDF file formats.
The WinForms DataGrid has data-binding support to work 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.
Use different built-in column types such as ComboBox, DateTime, CheckBox, and more to edit cell values. Commit or rollback changes when the data object implements IEditableObject. Also add new records dynamically.
The WinForms DataGrid control supports various column types. Users can display information and easily edit cell values using built-in intuitive editors such as TextBox, Numeric TextBox (Includes currency and percentage TextBoxes), DatePicker, and CheckBox.
Lookup data using the dropdown column type. The ComboBox editor is used to select an item from the dropdown.
DataGrid allows you to create your own custom columns to perform customized operations for your business application use cases. It is also possible to change the behavior of built-in column types.
Validate cells and display error information based on the validation types such as IDataErrorInfo, INotifyDataErrorInfo, Data Annotations. It is also possible to use cell, row, and custom validations.
Sort data based on 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 in the group drop area or in code behind. You can also group data with custom logic.
Filter data using the built-in filter row or Excel-inspired filtering UI.
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:
The WinForms DataGrid control can handle high-frequency updates even under the most demanding scenarios where the data is sorted and grouped in real-time. Summaries are also calculated and displayed in real-time scenarios.
Add a new record in an underlying collection with a built-in row. It is also possible to place a newly added row at the top or bottom of a data grid.
Delete selected records in a data grid by pressing the Delete
key. You can also change it to another key instead of the default key.
Search and highlight text in a data grid and filter records based on the search text.
Select rows or cells for all keyboard navigations and mouse interactions like Excel.
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 readability. It is also possible to set the row height conditionally.
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.
Display unbound columns with custom data . This control supports an expression to calculate values based on other columns.
Display rows at the top and bottom of the grid with data that is not bound to a field or data source.
Dynamically merge data in the adjacent cells and present that data in a single cell. Merge data based on content by writing your own custom logic.
Stacked headers (column header span) allow users to show unbound header rows. They span the stacked header columns across multiple rows and columns.
Adjust (auto fit) the column width based on the content of any column or column header. Fit all the columns within the viewport of a data grid.
A master-details view (nested DataGridView) can be represented using nested grids that can be expanded and collapsed. Functions like editing, sorting, filtering, and grouping are supported. Unlimited levels of nested grid relationships are allowed.
Display additional information of a row. View the preview row by expanding and collapsing the record as required. Custom view can also be shown by using custom drawing logic.
Create records on demand by automatically enabling data virtualization. Load millions of records of data instantly with virtualization enabled.
Manipulate data using the DataPager control to view records in multiple pages. DataPager also supports on-demand loading of data.
The appearance of a DataGrid and its inner elements, such as rows, cells, columns, headers, and summary rows, can be customized easily.
Users can change the visibility of columns at runtime using the customizable column chooser UI.
The WinForms DataGrid control provides an entirely customized 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.
Perform clipboard operations such as cut, copy, and paste within a control and between other applications such as Notepad or Excel.
Export a data grid to Excel and PDF file formats with the rich set of options.
Serialize the WinForms DataGrid settings to XML format and load back (deserialization) to the data grid using built-in serialization options.
Localize all the static default strings in the WinForms data grid to any desired language.
Displays text in the right-to-left (RTL) direction for users working with languages like Hebrew, Arabic, or Persian.
The WinForms DataGrid control is compatible with Coded UI and UFT (formerly QTP) automation tools to automate applications.
Easily get started with the WinForms DataGrid using a few simple lines of C# code example as demonstrated below. Also explore our WinForms DataGrid Example that shows you how to render and configure the WinForms DataGrid.
using Syncfusion.WinForms.DataGrid;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
SfDataGrid sfDataGrid1 = new SfDataGrid();
sfDataGrid1.Location = new System.Drawing.Point(85, 108);
sfDataGrid1.Size = new System.Drawing.Size(240, 150);
this.Controls.Add(sfDataGrid1);
}
}
}
We do not sell the WinForms DataGrid control separately. It is only available for purchase as part of the Syncfusion WinForms suite, which contains over 100 WinForms controls, including DataGrid. A single developer license for the Syncfusion Essential Studio for WinForms suite costs $995.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 WinForms DataGrid demo on
GitHub location.
No, our 100+ WinForms controls, including DataGrid, are not sold individually, only as a single package. However, we have competitively priced the product 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 100+ WinForms controls for a flat fee of $995/developer. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today 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.
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.