FlexGrid: Datagrid Control for WPF Apps

Familiar, Excel-Like Experience

FlexGrid's interactive features mimic Microsoft Excel. Users enjoy familiar features such as keyboard navigation, cell selection, editing, sorting, freezing, as well as Excel import and export.
Full-Feature WPF Datagrid

Users have full control over how each cell is rendered and includes cell render control, using cell factories, and more built-in features.

Hierarchical Datagrid

Aggregate data and display dynamic hierarchical views in your desktop application. Group data with summaries or create nested grids and child content using the row details feature.
Fast and Lightweight

FlexGrid supports data virtualization. You can load data on-demand as the user scrolls. This is due in part to the C1CollectionView component. Its modularized assemblies allow you to add just the features you need while not adding bloat to your desktop applications.

Data Binding & Styling in XAML

Populate FlexGrid and databind each column following the MVVM (Model-View-ViewModel) design pattern. FlexGrid's WPF datagrid can be declaratively written and bound to in XAML using native binding techniques. Easily apply styles and change common colors without having to customize the XAML template.

Built-in Filtering, Grouping, Sorting, Globalization

Change View:

Features

Filtering

Enable filtering to filter on any column's data, by condition or value. FlexGrid supports drop-down filters in the column headers, like Microsoft Excel, and full-text search that allows users to filter across all columns at once.

Learn More

Globalization

Format and display numeric data appropriately for any target culture. FlexGrid also supports right-to-left column displays for Arabic and Hebrew.

Learn More

Grouping

Create a hierarchical view of your data by grouping. FlexGrid for WPF supports dynamic grouping by code, or through end-user interaction by dragging column headers into the grouping panel. You may also customize the text displayed on the group headers to show summaries.

Learn More

Sorting

FlexGrid supports sorting, ascending and descending, by clicking on the column headers.

Learn More

Filtering

Globalization

Format and display numeric data appropriately for any target culture. FlexGrid also supports right-to-left column displays for Arabic and Hebrew.

Grouping

Sorting

FlexGrid supports sorting, ascending and descending, by clicking on the column headers.

Selection, Formatting, and Editing

Change View:

Features

Custom Cells

Fully customize the datagrid cells in FlexGrid to provide conditional formatting or to visualize the data differently. FlexGrid for WPF supports this through cell factories (C# code) or XAML templates. Simply format the text, or display progress bars, sparklines, bullet graphs, ratings, images, or any embedded UI control into the cells.

Learn More

Detail Row

Drill into a row of data to show more details inside a collapsible panel. You can display an input form, a child data grid, or anything else within the detail row.

Learn More

Excel-like Editing

In-cell, fast editing requires no extra Edit columns to switch between modes. Embed other controls to include drop-downs and datepickers in your grid. Batch editing also included in some platforms.

Learn More

Live Updates

Show stock prices (and other rapidly updating information) in your grid. The FlexGrid control supports binding to MVVM-compatible observable collections that automatically reflect any changes to the underlying data source.

Learn More

Master Detail

Bind one datagrid to another using FlexGrid and create a master-detail scenario. Drill-down into data by clicking on a row in one grid that shows related data in the second grid.

Selection

The FlexGrid selection experience is heavily inspired by Microsoft Excel. Users can select multiple cells across rows and columns, select multiple non-adjacent rows, select entire columns, or limit the selection to a single row or cell.

Learn More

Validation

Validate data with the built-in formatting, or use unobtrusive validation to validate as the user types.

Learn More

Custom Cells

Detail Row

Drill into a row of data to show more details inside a collapsible panel. You can display an input form, a child data grid, or anything else within the detail row.

Excel-like Editing

In-cell, fast editing requires no extra Edit columns to switch between modes. Embed other controls to include drop-downs and datepickers in your grid. Batch editing also included in some platforms.

Live Updates

Master Detail

Bind one datagrid to another using FlexGrid and create a master-detail scenario. Drill-down into data by clicking on a row in one grid that shows related data in the second grid.

Selection

Validation

Validate data with the built-in formatting, or use unobtrusive validation to validate as the user types.

Row & Column Features

Change View:

Features

Add New Row

Users may enter data into the datagrid to add new rows using the empty row template. This feature works for both bound and unbound datagrids.

Learn More

Frozen Cells

FlexGrid supports column and row freezing, which allows the user to prevent the left-most columns or the top rows from scrolling out of view.

Learn More

Merge Cells in a WPF DataGrid

Merge cells across rows and columns dynamically or as needed. FlexGrid can be configured to automatically merge adjacent cells with the same value, down columns, and across rows.

Learn More

Virtual Scrolling

Use FlexGrid to implement a WPF datagrid with virtual mode, where data is only retrieved as needed. This feature is also known as on-demand loading, and it's useful if you are working with large data sets to reduce load times.

Learn More

Column Pinning

Pinned columns are automatically moved to the left and frozen during scroll. This feature is made possible with custom headers, freezing and column reordering.

Learn More

Add New Row

Users may enter data into the datagrid to add new rows using the empty row template. This feature works for both bound and unbound datagrids.

Frozen Cells

FlexGrid supports column and row freezing, which allows the user to prevent the left-most columns or the top rows from scrolling out of view.

Merge Cells in a WPF DataGrid

Merge cells across rows and columns dynamically or as needed. FlexGrid can be configured to automatically merge adjacent cells with the same value, down columns, and across rows.

Virtual Scrolling

Data Binding in a WPF Datagrid

Change View:

Features

Flexible Data Binding

FlexGrid for WPF supports data binding to ADO.NET data source objects such as DataTable, DataView, DataSet, and DataViewManager, as well as custom business objects and MVVM-friendly observable collections. It supports an unbound mode where the developer can manually add each row and column and set each cell value.

Learn More