GridView for Silverlight

Overview

RadGridView is the ultimate Silverlight 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 Silverlight Grid that can be easily customized to blend perfectly into your applications. See a detailed features comparison of Telerik RadGridView and Microsoft Data Grid.

See Demos Download Trial

Features

• WPF/Silverlight Code Compatibility
• Support for .NET RIA Services
• LINQ-Based Data Engine and Native UI Virtualization
• Truly Lookless, Blend Skinnable, Completely Customizable Control
• RadCompression Module
• Direct Data Operations
• Powerful Databinding
• Asynchronous Databinding
• Data Source Updates
• Grouping and Aggregates
• Sorting
• Filtering and Excel-like Filtering
• Hierarchy
• Built-in Data Validation
• Column Types
• Printing
• Totals Row with Aggregate Functions
• Frozen Columns
• Export to Word/Excel/CSV
• Custom Layout
• Row Details
• Styling
• Gridlines Visibility
• Localization Support
• Selecting and Navigating
• Codeless Test Automation for RadGridView

• WPF/Silverlight Code Compatibility

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

  Top

• Support for .NET RIA Services

  Telerik Grid for Silverlight 3 provides support for .NET RIA Services. It now can handle an enormous amount of records server-side in no time. All data operations are executed on the server, which results in speedier sorting, filtering and paging. Telerik Silverlight Grid can be directly bound to a RIA Service through its ItemSource property, or to a Silverlight DomainDataSource contol. Either way, no coding is required, as both approaches allow you to declaratively set the RIA Service.

  Top

• LINQ-Based Data Engine and Native UI Virtualization

  Telerik Silverlight 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.

  See demo

  Top

• Truly Lookless, Blend Skinnable, Completely Customizable Control

  Telerik Silverlight 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 – Vista, Office Black and Summer, which will help you deliver a consistent look and feel in your application.
  
  

  

  Top

• RadCompression Module

  RadCompression is an HttpModule allowing you to compress the entire Web Service traffic in a codeless manner resulting in less traffic and faster page load. RadCompression intercepts the bits that the server is sending back to a browser (or Silverlight-client, for that matter) and compresses them. Once the compressed bits reach the browser, standard browser technology takes-over and decompresses the response so your application can work with it normally. It is extremely useful in shared hosting environments, where the users usually don’t have the ability to enable the integrated compression of IIS.
  
  Learn how to compress the response from ADO.NET DataServices in Silverlight

  Top

• Direct Data Operations

  With Telerik Silverlight Grid data operations (sorting, grouping, filtering) work directly with your data objects. In a common scenario when a Silverlight grid is performing data operations, you need to create your own collection view. With Telerik Silverlight grid there is no requirement for wrapping your data in collection views to do sorting, grouping and filtering.

   

  Top

• Powerful Databinding

  Databinding with RadGridView is as simple as setting a single property. The binding sources the Silverlight grid supports include:

  • .NET object
  • ADO.NET data tables

  Top

• Asynchronous Databinding

  To provide better user experience Telerik Silverlight 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 it may be more convenient to manipulate data in the original data source instead of using the RadGridView API.  Telerik Silverlight Grid supports that scenario by listening to data source collection change events and reflecting those changes in its visual representation.

  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 Silverlight 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 Silverlight 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 Silverlight, aggregate result display is fully customizable.
  

   

  Top

• Sorting

  You can have Telerik Silverlight 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 Silverlight 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 Silverlight 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 Silverlight grid hierarchy support also extends to .NET objects and can display them in a hierarchical fashion
  • Custom hierarchy - Telerik Silverlight 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 – allows you to define a relation that points back to the same table

   

  

  Top

• Built-in Data Validation

  Telerik Silverlight Grid supports metadata-driven validation via data annotations. You can use the grid with the Validation Summary class to implement the automatic validation UI provided by the platform and also benefit from the server-side validation attributes provided by RIA Services. 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 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

• Printing

  RadGridView for Silverlight now supports printing by using PrintToHtml() method.

  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 Silverlight 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 Silverlight 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 RadGridView 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 in the Silverlight grid through cell customization and row layout customization.  Or 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.
  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 of the grid with your custom one. Furthermore 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

• Row Details

  Telerik Silverlight 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 Silverlight Grid 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 grid cells with a custom template. Furthermore you can completely replace the control template of the grid cells with a custom template.
  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 Silverlight 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 Silverlight 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 Silverlight and WPF share the same API, once a control has been localized for Silverlight, the control's declaration can be reused in WPF.

  Top

• Selecting and Navigating

  Telerik Silverlight Grid provides a familiar selection API that will make Silverlight developers feel at home. The control supports single and multiple record selection that can be manipulated both with the mouse and the keyboard.

  Top

• Codeless Test Automation for RadGridView

  Now you can record, execute and debug functional tests for RadGridView without leaving the familiar Visual Studio environment. Telerik WebUI Test Studio is an advanced click and play web application testing tool specialized for automating both AJAX and Silverlight applications. The Studio ships with special translators for Telerik RadControls for ASP.NET AJAX and Silverlight.
  
  

  Top