GridView for WPF

Overview

RadGridView is the ultimate WPF grid control that features unrivalled performance through LINQ-based data engine, remarkably flexible hierarchy model, advanced features such as Excel-like filtering, row details, totals, export to Word/Excel/CSV and many more. And as good looks count, we’ve created a truly lookless WPF Grid that can be easily customized to blend perfectly into your applications.

See Demos Download Trial

Features

• LINQ-based Data Engine and Native UI Virtualization
• Truly Lookless, Blend Skinnable, Completely Customizable Control
• WPF/Silverlight Code Compatibility
• Powerful databinding
• Asynchronous databinding
• Data source updates
• Hierarchy
• Custom hierarchy
• Self Reference hierarchy
• In-place data editing and built-in data validation
• Grouping and aggregates
• Sorting
• Filtering and Excel-like Filtering
• Totals Row with Aggregate Functions
• Frozen columns
• Export to Word/Excel/CSV
• Custom layout
• Row details
• Styling
• Gridlines visibility
• Localization support
• Selecting and Navigating

• LINQ-based Data Engine and Native UI Virtualization

  Telerik WPF Grid handles millions of records without affecting the user experience. The grid uses native UI virtualization, which processes only information loaded in the viewable grid area, which reduces the memory footprint of the application and speeds up loading time thus enhancing additionally the UI performance.  The grid supports UI virtualization, even when grouping data.
  
  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.

   

  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

• 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

• 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 tables
  • WinForms-native BindingList collectios
  • WPF-native collection views

   

  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

• Hierarchy

  Telerik WPF Grid has an extremely flexible hierarchy model, which allows for meaningful organization of complex data. To spare you the trouble of defining hierarchical relationship, the grid can automatically detect those if bound to an ADO.NET DataSet and display the data accordingly.
  Telerik WPF Grid hierarchy support also extends to .NET object graphs. Furthermore, the control allows you to define custom hierarchy settings using your own implemented rules instead of using data table or .NET object relations.
  To ease the display of tree-like data, Telerik WPF Grid also provides self-reference hierarchy support, which allows you to display objects which have child objects of the same type and can be nested to arbitrary depths.
  
  Table hierarchy
  This hierarchy mode allows you to define your hierarchy settings when binding to different data tables.
  You can either use the relations already defined in a DataSet or define them yourself. Telerik WPF Grid uses those relations to build the main grid as well as nested grids in accordance with your data model.

  Property hierarchy
  Not all data comes from ADO.NET DataSet or DataTable objects. RadGridView fully supports .NET objects and can display them in a hierarchical fashion. For example binding to a collection of Customer objects each of those having a collection of Order objects accessible through its Orders property is a matter of setting up the correct relationship.
  

  

   

  Top

• Custom hierarchy

  For those advanced scenarios where child data may come from special sources, you can use a custom hierarchy setting. Telerik WPF Grid will trigger 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.

  Top

• Self Reference hierarchy

  Often tabular data defines a hierarchical relationship with itself. 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. For example, consider a Customer object with a collection of related customers.

  Top

• In-place data editing and built-in data validation

  RadGridView for WPF allows you to codelessly edit data through the integrated RadMaskedTextBox, RadCheckBox, RadDatePicker, RadTextBox and RadComboBox editors. Furthermore the control provides built-in data validation and flexible editor appearance customization. With the help of these editors, you can manage various data entries - text, numerical, dates, etc. Depending on the column data type, a relevant Editor allows you to edit content in a friendly environment. You can customize both the display of the currently edited cell and reuse an existing editor or define your own custom editors.

   

   

  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

• 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

• 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

• 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

• Export to Word/Excel/CSV

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

   

  Top

• Custom layout

  You have full control over the way the data is presented through cell customization and row layout customization. You can easily customize a column’s cell template and the row layout in any way your user experience team may desire. You can also combine the built-in appearance settings with your custom ones.
  
  Column customization
  You can customize column templates and use unbound data columns in RadGridView.

  Card Style rows
  Using technologies like WinForms makes implementing custom row layouts very hard, even downright impossible. WPF and RadGridView make that an easy job: you can customize the row appearance inside the grid and break away from the standard tabular view. Designers can unleash their imagination and present the information in a visually appealing way well-suited to your application.

  Tabular and custom
  Of course, you can combine both the built-in appearance of your 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.

   

  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

• Styling

  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. Cell templating is not the only way to change your cell visual appearance, you can modify your column settings and choose different background color for your columns, for example.

  Custom style
  You can completely replace the control template of the RadGridView cells with a custom template.
  By specifying a standard WPF control template you can completely restyle both a GridViewCell and its editor.
  Pushing further the styling 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

• Gridlines visibility

  Telerik WPF Grid grants full control over the visibility of its gridlines. Now the horizontal and the vertical gridlines can be shown or hidden to suit better the user requirements for the GridView look.

  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