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.
Unfortunately, activation email could not send to your email. Please try again.

DataGrid

The data grid 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. It has also been optimized for working with millions of records as well as handling high frequency real-time updates.


High Performance

Instant Loading

Load millions of records instantly.

Fast Data Processing

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

Export

The data grid is optimized for quickly exporting to Excel and PDF file formats.


Data Binding

Data binding works out of the box with all popular data sources like SQL Server, Oracle, and IEnumerable; and data providers like LINQ to SQL, ADO.NET, Entity Framework, and WCF Data Service.


Seamless Editing Experience

  • Supports built-in column types.
  • Add new records dynamically.

Data Error Indication and Validation

Includes built-in support for validating cells and displaying error information based on IDataErrorInfo, INotifyDataErrorInfo, and DataAnnotations. The data grid also provides support for custom validations.


Data Shaping and Manipulation

Sorting

Sort data against one or more columns with multiple customization operations. An option is also included to sort by caption summary values when the grid is grouped.

Grouping

Group data by one or more columns either programmatically or through mouse and touch interactivity.

Filtering

The data grid has a built-in, Excel-inspired filter UI with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically.

Summaries

Calculate and display sum, min, max, average, count, and custom aggregates in additional rows in a table or group.

Real-Time Updates

The data grid handles 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.

Highlight search results and also filter records based on search text.


Conditional Formatting

Customize cell and row appearances conditionally based on the cell data.


Row and Column Customization

Individual Row Heights

Change the height of the rows based on the content of any column or certain columns to enhance readability.

Cell Merging

Merge cells in both horizontal and vertical directions. Adjacent cells with the same data can be merged into a single cell and display the data in the cell.

Freeze Panes

Freeze the rows and columns at the top, bottom, left, and right positions of the grid, similar to Excel.

Unbound Rows

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

Stacked Headers

Display stacked headers, which are unbound header rows that can span across multiple rows and columns.

Unbound Columns

Display additional columns that are not bound to data. The data grid also supports expressions, which are used to calculate values among columns.


Master-Details View

A master-detail relationship is represented through nested grids that can be expanded and collapsed as required. The data grid also supports functionalities like editing, sorting, filtering, and more. Its flexibility allows unlimited levels of nesting.


Data Virtualization

Create records on demand by automatically enabling data virtualization.


Interactive Features

Column Drag-and-Drop

Drag and drop columns within the grid, and even drag and drop between controls.

Tooltip

Provides advanced tooltip options to display multiple items, balloon styles, and custom appearances.

Context Menu

Improve the end user experience by adding custom context menu entries.

Selection

Built-in support for row-based selection similar to Excel, with extensive support for all keyboard navigation actions.


Built-in Themes

Supports built-in Office 2016 themes:

  • Black
  • Colorful
  • White
  • Dark Gray

Exporting

  • Includes a rich set of options for exporting data to Microsoft Excel file formats, PDF, and CSV.
  • Several customization options are also provided to customize the exporting operations.


Serialization

Settings in the grid can be serialized to XML format and loaded back through the built-in serialization options.


Localization

All static text in the data grid can be localized to any desired language.


Accessibility

Provides accessibility support to make applications available to a wide variety of users.

No results found

GRID

DATA VISUALIZATION

DATA SCIENCE

EDITORS

NAVIGATION

FILE FORMAT LIBRARY

NOTIFICATION

LAYOUT

MISCELLANEOUS

BUSINESS INTELLIGENCE

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.