||Mature, powerful & fast. The most-adopted WPF datagrid around! |
||Current version for .NET 4/4.5: 5.1 (History)|
||Current version for .NET 3.5 SP1 & lower: 3.9|
||Platforms: WPF, .NET 4.5/4/3.5|
||Price: $1,499.95 USD for a 1-year subscription|
Perpetual, royalty-free license
45-day trial, 60-day satisfaction guarantee
Updated March 26 2013! Compare Xceed DataGrid for WPF with the competition.
|WPF / .NET Technology
- Created entirely for WPF, written in C# and XAML.
- Complete source code is available through a Blueprint subscription. (Also includes the source code for Xceed 3D Views for WPF and Xceed Editors for WPF.)
- Supports UI virtualization, even when grouping data, so only elements currently in view are created and kept, meaning faster loading time, uses less memory. Container recycling also performed for improved scrolling speed.
- Design-time support in Visual Studio 2012/2010/2008 and Expression Blend.
- Design-time configuration window that lets you set up the most important features quickly and easily.
- Supports .NET 4.5, 4, and 3.5.
- XBAP- friendly, CLS compliant, and uses no unsafe blocks. No special permissions are required, so it can run within the limited permission set granted to XBAP applications.
- Based on a flexible and extensible object model, with modular and reusable visual elements.
- The datagrid's cells are true WPF content controls, so they can contain anything.
- Supports the WPF command infrastructure, for example letting you map a toolbar button to "enter edit" in a cell.
- Comprehensive documentation fully integrated into Visual Studio is provided.
- Supports Right-To-Left and Inking.
- Supports regional settings including numbers, money type, dates, etc.
- Includes a variety of VB.NET and C# sample applications to get you started.
- All error handling works through .NET exception classes.
- Can also be used in your Windows Forms applications.
- Can be used in conjunction with the MVVM and MVC design and architectural patterns.
- Integrates well into dashboard and business intelligence software.
|Rich in-place editing
- Features rich in-place editing that works in all views. See Included editor controls below.
- Auto-detection of ComboBox columns (enums, foreign keys).
- Updates source when the cell or row exits edit mode or immediately when the cell content changes.
- Combo boxes can easily be used as cell editors without the need to write code to fill the combo box thanks to auto- detection of ComboBox columns (enums, foreign keys).
- Routed edit events for both cell and row, providing fine-grained control over the edit process.
- Provides configurable keyboard and mouse edit commands.
- Programmatic control over edit mode.
- Provides Excel-like default keyboard and mouse edit behavior, including F2, Esc (cancel edit on a cell and restore the original value), Double-Esc (cancel edit on the entire row and restore the original values), and Enter.
- Allows you to specify a different visual template for a cell being edited.
- Cell editors can be displayed without entering edit mode, under a variety of conditions such as a mouse hover over the cell or row, the cell or row becoming current, the row being edited, or always.
- Single-click edit mode allows entering edit mode and activating items such as check, text, and combo boxes with one click.
- Automatically selects the appropriate editor control depending on the field data type.
- Insertion row / card object allows for quick entry of new data.
- A continuous insertion mode lets end-users add data without having to manually move to the first editable column after finishing the previous row. (New in v3.7)
- Triggers meaningful edit events for both rows and cells.
- Manages “null” and “DbNull” values.
- Any portion of the grid can be made read-only.
- The cells in a column can be non-focusable when read-only, so they can’t be selected with either the mouse or the keyboard. (New in v3.7)
|Hierarchical master/detail capabilities
- Lets users see their data in a master-detail hierarchy.
- The single-scrollbar approach used in detail grids provides a more professional, integrated master/detail experience than the awkward scrollbar-within-scrollbar approach used by competing datagrids.
- Each datarow in the main grid or in a detail can have an unlimited number of details attached to it.
- Details can have “sibling” or “child” details, or both.
- Details support headers and footers, grouping, sorting, and autofiltering.
- Different style for the data items contained in each same- level detail.
- Custom grouping in grid and details supported.
- Custom detail relations supported.
|Data grouping and organization
- Supports hierarchical, multi-level grouping in all views.
- Customizable group-level configurations with header and footer support.
- Supports UI virtualization, preserving memory and reducing load time, even when grouping.
- Supports custom grouping criteria, to allow your code to group together rows with your own conditions.
- Interactive, hierarchical “Group-by” row allows end-users to easily create and manipulate groups themselves. Adapted for all included views.
- Programmatic control over expanding and collapsing groups.
- Grouping can be controlled via code.
- Provides merged column header capabilities in TableView and TableFlowView, for improved presentation of data. Columns can be grouped under these merged headers, which span the columns they contain. Groups of columns and their associated header can be grouped under headers at higher levels too. Merged headers and their columns can be reordered and moved to same-level headers (drag-and-drop, programmatically) and removed / added back. Column headers can be resized and support the column chooser. (New in v4.5)
|Views and themes
- Presents data and lets users edit it in a variety of 2D and 3D views and themes. Can switch between 2D and 3D views in real-time while preserving state.
- Ships with the stunning, interactive Cardflow™ 3D view, with multiple card layouts. More are currently being developed.
- Ships with the Tableflow™ 2D view, which provides inertial smooth scrolling and animated full-column reordering, zero-lag data virtualization.
- Ships with the TableGridflow view, which displays details in a tree-like structure under the main column at the master level. (New in v5.0)
- Ships with two other 2D views (traditional table view and card view). Achieve the look of traditional XP or Vista applications with a true native WPF control.
- Ships with several backgrounds, as well as textures for 2D and 3D cards.
- Project template for Visual Studio that sets up a new theme project so you can create your own. A tutorial on creating a custom theme is also included to help you get started.
- Eighteen striking themes in all:
- Metro / ModernUI theme with Light and Dark versions and accent color (New in v5.1)
- Glass, Windows Media Player 11, and Zune. (Glass theme currently not available for Tableflow™ view)
- All Microsoft Windows themes: Classic (NT), Luna (Normal/Olive, Metallic/Silver, Homestead/Blue), Aero (Vista), and Royale (Media Center).
- A vibrant Window 7 theme.
- A Windows 8 theme for TableFlow view. (New in v5.0)
- Office 2007: Blue, Black, and Silver.
- The Xceed Live Explorer theme.
- 3D view, multi-surface: Office themes (Blue, Black, and Silver); Chameleon.
- Each theme provides an alternating row style that can be activated through the TableView class.
- Various cursors—such as "busy", "resize", and "drag" cursors—can be customized in the different views.
- Includes the commented XAML source code to the card and table view styles and templates, so you have a great starting point for developing your own.
|Cardflow™ 3D view
- Gives end-users complete control over their experience.
- Multiple card layouts and transitions.
- Controls the offsets, spacing, and angles of cards.
- Controls camera position and angle
- Controls field of view.
- Four themes: Office 2007 themes (Blue, Black, and Silver); Chameleon.
|Tableflow™ 2D view
- Fast animated smooth scrolling (with inertia) for impressive UI performance.
- Works when using data virtualization for great perceived responsiveness.
- Sticky group headers (group headers are always visible).
- Sticky master-detail master row and headers.
- Full-column animated drag and drop reordering.
- Also has all the features of the classic (see below).
- An innovative new group navigation control in the TableflowTM view greatly increases the datagrid’s usability. A first in any WPF datagrid, it lets the end-user go instantly to any group or sub-group with a single click in a combo box.
|2D card view
- Defaults to cards stacked into columns, with horizontal scrolling.
- Two types of card view styles are included: compact card view (borderless cards with column separator lines) and standard card view (cards with borders, but no separator lines).
- Supports grouping with multiple levels. Group-by row includes built-in list of columns, so end-users can still group by columns and reorder fields even if there are no column headers. Group headers flow within the card list.
- Cards can be independently sized, each card sizing itself to its content.
- Resizable cards in CardView.
- Allows you to hide empty fields on a per-card basis.
- Insertion card lets users quickly add new data to the grid.
|Classic 2D table view
- Column auto-sizing / stretching and starrable column widths.
- Custom sorting.
- Fixed columns (UI widget + programmatic control).
- Context menu column chooser: lets end-users add or remove columns.
- Includes an Outlook-style table view with all the typical elements you would expect.
- Column headers support drag-and-drop column reordering, column resizing, click-to-sort, and dragging to "Group-by" row.
- Row margin selects and resizes rows, and displays icons indicating that the row is current, is being edited, is an insertion, or has a validation error.
- Provides horizontal and vertical Grid line brush and grid line thickness properties.
- Automatically changes a row’s height to fit the contents of the largest cell.
- Supports IDataErrorInfo.
- Supports IEditableObject and error style when IEditableObject’s EndEdit throws an exception when trying to leave edit mode.
- Includes built-in data validation, at the cell or row level.
- Error display is integrated with the included views.
- You can completely style the way a cell or row looks when a validation error occurs.
- Can validate on any criteria, including the values of other cells.
- Validation error messages are overridable and localizable.
- Expandable and compatible with custom validation rules you have already built.
|Included editor controls
- All included editor controls are usable either as cell viewers / editors, or independently outside of the grid for a more flexible and uniform interface.
- Several editors available in the “Included
- PhoneMaskedTextBox (North American format).
- Simple CurrencyMaskedTextBox.
- DateTimeTextBox (with ShortDate, ShortTime, ShortDateAndShortTime, and ShortDateAndLongTime formats).
- All controls are 100% stylable and templatable.
- Combinability/modularity: Embed controls into one another to create flexible, innovative new controls.
- The grid automatically picks the correct type depending on the data type of the column.
- Fully visual approach: Powerful designers help make development faster and easier.
- Extensibility: All controls can be extended to implement custom features, appearance, and behavior.
- Themes: Support for Windows XP and Windows Classic themes and the ability to adapt to the current Windows theme.
- Data virtualization (sometimes called “virtual mode” or “lazy loading”) vastly improves performance and reduces memory usage, especially when working with large data sources, loading data only when it's needed. Also supports grouping and data sources implementing IQueryable (LINQ). (See it in action!)
- Because it’s asynchronous, the data virtualization implementation decouples the UI from the data source, which keeps the application responsive while data is being retrieved. It also supports caching, pre-emptive data loading, and delayed triggering of events to avoid needless querying during scrolling.
- Filtering (auto filtering and filter row) in virtualized collection view, letting you combine the advantage of a data virtualization performance boost and the flexibility of filtering.
- Indicator glyphs let end-users know when virtualized data is being loaded and committed, and when there has been an error.
- Support for Entity Framework data sources, making the developer’s job easier when he or she must work with different types of data sources, as there is less code to write.
- Ability to customize the content of the AutoFilterControl, which allows any ListBox- or Selector-based control to handle how a specific column’s values are automatically filtered.
- Provides column virtualization, which allows you to work with a large number of columns while keeping performance reasonable.
- Inserting records into non-IBindingList sources.
- Easy binding to XML data sources.
- Excel-like end-user automatic filtering, which provides a drop-down box in the column header, allowing end-users to filter by one or more items, on a per-column basis. New events for auto- filter changes allow for improved control (New in v3.7).
- Custom CollectionView that provides fine-grained and efficient control over its underlying data source.
- Fully supports WPF data binding.
- Displays, edits, and works with bound and unbound data.
- Directly supports unbound columns, allowing for example the display of static information such as a delete button for each row, etc.
- Supports unbound data fields, which facilitates the use of calculated columns.
- Custom key-value mappings, which lets you map any kind of value or object to fields in the data that represent keys, such as mapping an employee first and last name fields to an integer ID field in an employee database.
- Can be bound directly to an array of simple types such as String, Decimal, DateTime, TimeSpan, Guid, or Primitive (e.g., SByte, Byte, Int32, etc.), and will show the value of those types in one column.
- Automatically obtains and synchronizes bound data from any .NET source, including jagged arrays, any object that implements IListSource or IList, and any ADO.NET DataSet, DataTable, DataView, or DataViewManager object.
- Can intercept, parse, and modify data being synchronized with the database from the grid.
- Includes Xceed 3D Views for WPF and Xceed Editors for WPF.
- Supports UI Automation (recently improved to cover more scenarios than ever) to enable the use of script-based testing and assistive technologies.
- Supports White, Ranorex, and certain editions of HP’s QuickTest Professional (QTP), allowing for automated UI testing.
- Excel export of grid contents, including groups, detail content, and statistical functions (formulas and values), using XMLSS or CSV.
- Excel-like cell and row selection capabilities (single, multiple, and extended modes), letting end-users select and copy blocks of cells or rows.(New in v3.6)
- Clipboard copy support allows content from the grid to be copied to any other supported application (e.g., Excel, Word, Notepad). Can be sent to the clipboard as HTML or CSV.
- Unicode support in CSV clipboard copy. (New in v3.7)
- Persist user settings: saves the positions and states of columns, as well as grouping and sorting states, etc. Can be extended by developers to persist other aspects.
- Delete selected rows command: in master grid, in details, or both.
- Ability to enable or disable sorting, grouping, and column reordering via the UI.
- Full keyboard navigation is possible through cells and rows. Navigation can be limited to cell-only or row- only, or navigation can be disabled.
- Allows multiple-field sort and custom criteria sort.
- Provides easy manipulation of the grid’s current row.
- Scrolls the view to any cell, row, group, or column.
- Scroll tip displays information about the first visible row in the viewport when the grid is scrolled.
- Allows elements other than columns to be fixed.
- Provides fixed, non-scrolling header and footer regions into which you can put any number and type of row or card.
- 14 statistical functions that can be used both inside and outside of a grid in any element. Sorting is now supported on the results of these functions (New in v4.1).
- Row scrolling is configurable to be immediate (items are scrolled immediately as the thumb is dragged) or deferred (items are not scrolled until the scroll thumb is released).
- Customizable “today” label in the Calendar.
- Ability to create alternating styles for data rows.
- Built-in printing and XPS-exporting capabilities with fully customizable progress dialogs and page layouts.
- Print preview capabilities let the end-user see what a document will look like before printing it—page view and layout configurations are reflected in the preview. And everything happens in the background, so there is no waiting for the entire preview to be generated.
- Customizable group-header control display.
- A Resource Center that centralizes various DataGrid for WPF assets and provides a news feed for the latest developments concerning the product.
- Try the Live Explorer XBAP application, which demonstrates the datagrid and lets you get a feel for it without installing anything. Also available as a stand-alone .EXE when you download Xceed DataGrid for WPF.