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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The WinForms 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/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.


High Performance

Instant loading illustration for winforms datagrid

Instant loading

Load millions of records instantly.

Fast data processing of winforms datagrid illustration

Fast data processing

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

Printing illustration of winforms datagrid

Export

Quickly export the datagrid content to Excel or PDF file formats.


Data binding

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

Data binding illustration for winforms datagrid


Seamless editing experience

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. You can also add new records dynamically.

Different column types in winforms datagrid

Widely used column types

The WinForms DataGrid control provides support for widely used column types. Users can easily edit cell values using built-in intuitive editors such as TextBox, Numeric TextBox (Includes currency and percentage TextBoxes), DatePicker, CheckBox, Image, Hyperlink and Button.

winforms datagrid shows combobox column type

DataGrid provides support to lookup data using dropdown column type. The ComboBox editor is supported to select an item from the dropdown.

winforms datagrid shows custom column type

Custom column type

DataGrid allows you to create your own custom columns. Thus, you can perform customized operations for your business application use cases. It is also possible to change the behavior of built-in column types.


Built-in data error indication and validation

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.

Data validation in winforms datagrid


Data operations

Multicolumn sorting in winforms datagrid

Sorting

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.

winforms 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. You can also group data with custom logic.

Excel-like filtering in winforms datagrid

Filter

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

winforms 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
  • Custom summary

Data manipulation

Real-time updates in winforms datagrid

Real time updates

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. The summaries are calculated in an optimized way and the updated summary is displayed in real-time scenarios.

Built-in add new row in winforms datagrid

Built-in add new row

Add a new record in an underlying collection with a built-in row. Place the add new row at the top or bottom, or stick it to the top. It’s also possible to place a newly added row at the top or bottom in a datagrid.

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

Text searching in winforms datagrid

Search and highlight text in a datagrid and filter records based on the search text.


Selection

Select rows or cells similar to Excel for all keyboard navigations and mouse interactions.

Selection in winforms datagrid


Conditional formatting

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

Conditional formatting in winforms datagrid


Row and column customization

Auto fitted row height in winforms datagrid

Row height

Users can adjust (auto fit) the row height based on the content of any column or certain columns to enhance readability of the content. It’s also possible to set the row height conditionally.

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

winforms datagrid shows unbound column

Unbound column

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

winforms datagrid shows unbound rows

Unbound row

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

winforms datagrid shows merged cells with images

Cell merging

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.

winforms 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

Adjust (auto fit) the column width based on the content of any column or column header. Fit all the columns within the viewport of the datagrid.


Master-details view (Hierarchical)

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.

Master details view of winforms datagrid


Data virtualization

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


Paging

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

paging support in winforms 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 winforms datagrid


Column chooser

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

Column chooser is showing in winforms datagrid


Context menu

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.

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


Excel, PDF, CSV export

Support to export a datagrid to Excel and PDF file formats with the rich set of options.

Exporting to Excel and pdf of winforms datagrid illustration


Serialization

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


Localization

Localization of winforms datagrid

Localization

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

Right to Left mode of winforms 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 WinForms DataGrid control is compatible with Coded UI and UFT (formerly QTP) automation tools to automate applications.

UI automation illustration for winforms datagrid


100+ WINDOWS FORMS CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

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