GridView

HomeProductsWPF ControlsGridView

Overview

Uncompromising performance no matter how much data you're dealing with

See Demos Download Trial

Features

LINQ-based Data Engine and Native UI Virtualization

Telerik WPF Grid handles millions of records without affecting the user experience. The grid utilizes horizontal and vertical virtualization and introduces container recycling for further improvement of speed and memory footprint, especially when bound to large data sets. The UI virtualization technique ensures that the grid creates only the needed containers (rows/cells) which are shown in the viewport of the grid. The container recycling pushes further the speed of scrolling horizontally and vertically. This feature enables RadGridView to reuse the existing containers over and over for different data items, instead of creating new ones. These techniques combined with our outstanding LINQ-based data engine guarantee the exceptional fast performance of Telerik’s RadGridView.

Using our brand new LINQ data engine now, you can group, filter, sort, page, aggregate, etc. directly on the data-base server with maximum performance when the grid is bound to LINQ to SQL, ADO.NET Entities, Telerik Open Access and any other standard LINQ provider.
RadGridView also provides support for Parallel LINQ (PLINQ) – bringing high performance computing power onto the desktop. Using PLINQ, the grid can do sorting, filtering, grouping and aggregating on all CPU cores.

Top
Powerful Databinding
Databinding with Telerik WPF Grid is as simple as setting a single property. The binding sources the WPF grid supports include:
- .NET objects
- ADO.NET data services
- WinForms-native BindingList collections
- WPF-native collection views
Top
Built-in Paging UI

It provides you with a navigation interface to page through your data quickly. The pager control itself can be used as a standalone component in order to provide paged data source to other data-bound controls.

Top
Asynchronous Databinding

To provide better user experience Telerik WPF Grid allows asynchronous databinding, which means that the application is responsive even while a large dataset is being loaded. A background Thread is used to load the data asynchronously without blocking the main application flow.
Top
Data Source Updates

To achieve better testability and loose coupling in your code, you can manipulate data in the original data source instead of using the RadGridView API. RadGridView supports that scenario by listening to data source collection change events and reflecting those changes in its visual representation. This feature is only supported for observable data sources like the WPF-native collections implementing the INotifyCollectionChanged interface or the WinForms-specific ones implementing IBindingList.

Top
Truly Lookless, Blend Skinnable, Completely Customizable Control

Telerik WPF Grid can have its appearance and animations completely customized through Microsoft Expression Blend. You can use your own theme or you can use one of the several themes shipped with the grid control, which will help you deliver a consistent look and feel in your application.

Top
Custom Layout

You have full control over the way the data is presented in the WPF grid through cell customization, row layout customization and column’s cell templates. You can combine the built-in appearance of the grid cells with a custom view you have defined. You can let some of your cells get generated automatically and provide your own styles and templates for the rest. Or you can customize the grid’s column templates and use unbound data columns in RadGridView.
To break away from the standard tabular view, you can customize the row appearance inside the grid. Designers can unleash their imagination and present the information in a visually appealing way well-suited to your application.

Top
Formatting

To give you more control on how the data is displayed Telerik WPF Gird allows displaying your data as currency, percentage and any other format that suits your needs. You can use a standard .NET format string applied to your grid cells. You can customize the way the content of the RadGridView cells is arranged and displayed or can completely replace the control template of the RadGridView cells with a custom template. Furthermore you can completely replace the control template of the grid cells with a custom template.
Pushing further the formatting capabilities of the Telerik grid control alternating rows and disabled state features are available. The disable state allows better showing the inactive state for the entire grid as well as a chosen row/cell/column.
Top
Grouping and Aggregates

Data can be grouped according to several criteria effectively creating a tree of groups with the leaf nodes holding the actual data records. Users can group data by dragging a column header and dropping it in the group area above the WPF grid. Users can also rearrange the grouping headers in the group area (again by dragging and dropping).

The grid supports UI virtualization even when grouping, thus saving memory and reducing load time.
To empower users to get more value from their data, the WPF grid provides aggregates display that calculate values taking into account every data item in the group. You can add a variety of aggregate functions, such as Sum, Count, Min, Max, Average, etc, to your data model and see the results they produce in the RadGridView. Of course, in the spirit of WPF, aggregate result display is fully customizable.

Top
Totals Row with Aggregate Functions

Summarizing the data from a column in a single cell is a feature that is widely used in numerous scenarios. Telerik WPF Grid control offers a built-in totals row which makes it easy and fast to add a cell which represents the calculated values across a range of data. The summary row with aggregates is available for each column in the whole grid and/or for each individual group. The user can choose to show in the footer row from a variety of aggregate functions such as Sum, Count, Min, Max, Average and etc.

Top
Sorting

You can have Telerik WPF Grid automatically sort its columns by setting a single property. There are three sorting modes: ascending, descending and no sort.
In addition to the simple one-column sorting Telerik grid allows you to sort data by several columns just like in Microsoft Excel. Furthermore, you can define column sorted color for better user experience.
Top
Filtering and Excel-like Filtering

Telerik WPF Grid allows end users to filter data by applying filter patterns or their own filter criteria, hiding the records that do not match the filter thus accessing only the data they need. For each column RadGridView creates a filtering dropdown menu with the expressions applicable for the respective data type.

You can filter data against single or multiple columns, search as you type or filter in an Excel-like fashion.

Top
Hierarchy
Telerik WPF Grid has an extremely flexible hierarchy model, which allows for meaningful organization of complex data. The grid can automatically detect hierarchical relationship if bound to an ADO.NET DataSet and display the data accordingly.
The control provides:
- Table hierarchy – allowing you to define your hierarchy settings when binding to different data tables
- Property hierarchy - the WPF grid hierarchy support also extends to .NET objects and can display them in a hierarchical fashion
- Custom hierarchy - Telerik WPF Grid triggers an event that you can use to implement your own child data access logic. You can use this feature to define your hierarchy even when child data comes from legacy systems, XML files, COM, etc.
- Self-reference hierarchy – this approach is used to model tree-like structures that can be nested to arbitrary depths. Telerik WPF Grid supports that scenario through it self-reference hierarchy feature that allows you to define a relation that points back to the same table.
Top
Built-in Data Validation

Telerik WPF Grid supports metadata-driven validation via data annotations. The built-in validation operates on two layers – UI and Data. Furthermore, using the extensible event based API of RadGridView users can plug their own data validation mechanism.

Top
Column Types

The WPF Grid allows you choose from several predefined column types. The supported out-of-the-box columns are: Data, Hyperlink, DynamicHyperlink, Image, Select, ToggleRowDetailsVisibility and MaskedTextBox. They provide a built-in validation support for editing which cover most of the editing scenarios. If there are specific requirements, the built-in columns can be inherited and their editing validation mechanism can be used without any problem. Furthermore RadGridView offers flexible appearance model through the CellEditTemplate property of the column which allows any control to be used as editor.

Top
Frozen Columns

RadGridView allows you to keep part of your data in your WPF grid always visible putting the rest of the data in context. To freeze columns, you simply set the FrozenColumnCount property on the Grid to the number of columns you want to freeze.
Top
Row Details

Telerik WPF Grid supports Row Details, which can be used to present additional information related to the row in a visually appealing manner. The Row Details is a very convenient feature when the space at hand is insufficient for the data that needs to be presented.

Row Details can also be used for providing a more convenient editing environment for end-users. Defined through a data template, Row Details can present virtually anything to the user, be it for viewing-only or editing.

Top
Localization Support
Telerik WPF Grid provides advanced Localization support. Two new properties were added, so that you don’t have to always create an instance of the LocalizationManager:
- Default Culture property - you can change localized values without changing the UI culture of the current thread
- DefaultResourceManager - you change localized values using a new resource manager, i.e. a new resource file.
In addition, as RadGridView for WPF and Silverlight share the same API, once a control has been localized for WPF, the control's declaration can be reused in Silverlight.
Top
Selecting and Navigating

Telerik WPF Grid tries to provide a familiar selection API that will make WPF developers feel at home. The control supports single and multiple record selection that can be manipulated both with the mouse and the keyboard.
Top
Export to Word/Excel/CSV

With Telerik WPF Grid you can easily export data to Microsoft Excel/Microsoft Word/CSV.
Top
WPF/Silverlight Code Compatibility

The WPF Grid shares a common codebase and API with its Silverlight counterpart. This means that you can achieve close to 100% code reuse for your grid logic if you have parallel WPF/Silverlight development.
Top
Multiple Cells Selection

This Excel-like feature brings the user experience in RadGrid to another level and is the most important building block for the Copy and Paste functionality.

Top
Copy/Paste in RadGrid and to/from Excel

Copy/paste from Grid to Excel or from Excel to RadGridView is very useful when the data comes in Excel format and should be easily put in RadGridView.

Top
Asynchronous Validation

The Asynchronous Validation is the most needed prerequisite for achieving custom validation scenarios when there is a complicated set of rules which cannot be executed at the client.
Top
Expression Column

The Expression column in Telerik Grid for WPF calculates and displays information from the business object’s properties. The displayed information can be a result form mathematical or logical operations described as LINQ Expression trees.

Top
VS Plug-in for Testing RadControls

Telerik's automated software testing tool Test Studio is among the few to deliver rich UI object model that covers the entire range of UI elements in WPF. Easily record tests, customize them in code within Visual Studio or convert them to unit tests. What’s more, Test Studio is the best way to test RadControls for WPF. The powerful test recorder automatically detects the controls and exposes commonly used verifications. Learn more
Top