The NOV Grid for WPF is a high performance Data Grid component for displaying and editing tabular data within your WPF desktop applications.
The NOV installation comes with WPF Example Solution including many Grid Control examples with source code. You can use the NOV Grid for WPF to replace the standard DataGrid, or any Grid control for your business applications, whether you are working on a new or extending an existing WPF application.
The NOV Grid will not only help with your WPF application development, it will also allow you to start with your cross-platform .NET development and target multiple platforms and devices.
That is correct - when you start developing with NOV, you will be able to build cross-platform applications using single code base.
NOV Grid for WPF includes:
Filtering
Grouping
Sorting
Tree Grid View
Alternating Rows
Gridlines
Master Details
Row Headers
Frozen Rows
Frozen Columns
Null Values
Calculated Columns
Data Columns
Column Editors
Column Formats
Conditional Formatting
Column Width
Protection
Scrolling
Selection
Tooltips
Widget Hosting
NOV Grid for WPF provides support for binding to diverse set of data sources. The Grid displays data from a data source assigned by the DataSource property.
A data source is an attribute that aggregates a Data Table. Data Tables help you define data in-memory, or bind to different collections of objects.
You can work with all types of data tables in a consistent and intuitive manner.
The Data Table exposes various operations that help you add/remove fields and rows, get or set cell values as well as perform different queries.
With NOV Grid for WPF you can load 1M+ records (million records) without compromising performance.
The WPF Grid allows end-users to perform smooth scrolling, Grouping, Sorting and Filtering on hundreds of thousands of records instantly, without lags or delays.
The
NOV Grid for WPF Data Processing allows to easily perform Filtering, Grouping, Sorting, or Self-Referencing operations on your data. Both the Table Grid and Tree Grid are performing the Filtering and Sorting processes, however the order of the data processing algorithm is different for each type of grid. Following is an overview of the data processing algorithm for each type of grid.
-
The WPF Table Grid allows Filtering, Grouping and Sorting
-
The WPF Tree Grid allows Filtering, Self-Referencing and Sorting
Filtering is the process of passing only certain records from the data source to be displayed by the grid.
NOV Grid for WPF allows you to create filter rules that work on column and field provided row values.
This makes it possible to create filter rules that work on calculated columns (i.e. columns that do not have an associated field in the data source) as well as create filter rules that work on data source fields, regardless of whether they are represented by columns in the grid.
Sorting is the process of sorting the rows that reside on the same hierarchical level. The WPF Grid support multiple sorting rules that define a certain sorting order of the rows that reside at the same level in the grid grouping or self-referencing level.
Sorting can be visually performed by the user in several ways:
- Clicking on the Column Headers or Sorting Buttons - when the user clicks on the column headers or the sorting buttons, this will toggle the sorting direction in which that specific column is sorted. Additionally when the user holds down the Ctrl key, it is possible to perform sorting on multiple grid columns.
- Selecting the Sort Ascending or Sort Descending command from the Column Context Menu - the user can sort by a specific column by selecting the respective commands in the column context menu.
The purpose of the WPF Table Grid Grouping is to create a hierarchical organization of the grid rows, such that the rows that reside in each group share some common grouping defined common value.
The WPF Table Grid supports multi-level grouping. Because each grouping rule can produce multiple groups and because there are multiple grouping rules, this creates a hierarchically grouped grid. There is a sorting direction associated with each grouping rule.
Self-referencing is only applicable to the WPF Tree Grid. Self-referencing produces a tree-like structure from a tabular data source.
This is achieved by specifying two fields of the data source - one that identifies each record uniquely and another that specifies the parent record of the record.
Master - Details is a feature of the WPF Table Grid that allows you to display additional information (details) for each record data row.
Master - Details allows you to display other tables data that is related to the master table rows - NTableGridDetail and NTreeGridDetail are master-details that can display a Table Grid or Tree Grid showing information from a slave data source.
Unlike Data Columns, calculated columns do not show a specific data source field. Instead it is a user's responsibility to define a value for each data source row. Typically this value is a product of other data source fields. For example the TOTAL column in many grids is derived by multiplying the PRICE * QUANTITY values.
Calculated columns can also be used when you want to extract information about a specific data row from another data source. There are two types of calculated columns:
- Formula Calculated Column - this is a calculated column that is defined as a formula. The value that this column assigns to each row is the result of a formula evaluation, where you can use other column values.
- Custom Calculated Column - this is a calculated column that calls a user handled delegate to obtain a row value on-demand.
Filtering, Grouping and Sorting can be performed on the calculated columns.
Column Conditional Formatting helps you format certain data cell views, according to specific rules. NOV Grid for WPF provides strong support for authoring complex cell conditions.
Besides static fill rules, NOV Grid for WPF also supports gradient background and text fill declarations, that can be defined as a two color or three color gradient.
The NOV Grid for WPF Column Format allows the modification of the visualization of the data cell value.
Generally, the Column Formats are logically divided into two categories:
- Default Column Formats - these are the standard column formats that the grid by default uses, for specific row values types.
- Extended Column Formats - these are column formats that the grid does not use by default, but you can manually assign to certain columns.
NOV Grid for WPF also provides support for Custom Column Formatting - this allows you to use any NOV widget to represent the row values e.g. Charts, Gauges, Barcodes, or other widgets.
Resizing WPF Grid columns - the width of the column can be determined in several ways:
- Auto
- Fixed
- Size To Cells
- Size To Header
- Percent
Additionally the user can also resize the columns or double-click the column separators to "best fit" the columns.
Reordering WPF Grid columns – allows the user to change the order of the columns by dragging them.
NOV Grid for WPF provides support for Frozen Columns and Frozen Rows.
Frozen Columns can be frozen to the left or right side of the grid window area.
Frozen Rows appear pinned to the column headers and they are controlled by the FrozenRows grid property. It specifies the count of rows from the top of the grid, that are non-scrollable.
The WPF Grid protection refers to the set of properties that can help you restrict the user to perform certain actions with the grid in general.
For operations that apply to columns, there is also a respective Column Protection property that can restrict the same operation for a specific column only.
NOV Grid for WPF provides support for Null Values. The Grid also supports editing of null values.
The Grid selection is organized to work around grid rows and to maintain the notion of a Current Row and Current Cell.
Selection can be configured to operate in two modes via its Mode property:
- Single - only a single row can be selected;
- Multiple - multiple rows can be selected;
The Grid selection is also responsible for performing a variety of navigation commands that can alter the current cell, select/deselect rows and also change the current cell. The selection also exposes properties that control the events that trigger the current cell editing.
The Grid alternating rows are useful when you need to display grids with many columns, since the user can easily follow the values that belong to the same row.
Thus alternating rows increase the readability of the grid.
NOV Grid for WPF provides full control over the alternating rows appearance, interval and length.
NOV Grid for WPF features several types of gridlines that are displayed by the Grid cells, Columns and Row Headers.
- Grid Gridlines - the gridlines that separate the rows and data cells;
- Columns Gridlines - Top Gridline, Bottom Gridline and Vertical Columns Gridlines;
- Row Headers Gridlines - Left Gridline, Right Gridline and Horizontal Row Headers Gridlines;
NOV Grid provides full control over the appearance of the gridlines stroke.
NOV Grid for WPF provides full localization support and right-to-left support.
The NOV Framework Localization support allows you to translate the entire user interface (UI) of your applications.
The architecture of the NOV Framework allows you to host any NOV Widget into other NOV Widget.
This allows you to use NOV widgets to represent the WPF Grid row values, for example Charts, Gauges, Barcodes, or other widgets.
Open Vision for .NET
NOV Chart for .NET
NOV Diagram for .NET
NOV Rich Text Editor for .NET
NOV Grid for .NET
NOV Schedule for .NET
NOV Gauge for .NET
NOV Barcode for .NET
NOV User Interface for .NET
Vision for .NET
Chart for .NET
Diagram for .NET
User Interface for .NET
Vision for SSRS
Chart for SSRS
Gauge for SSRS
Map for SSRS
Barcode for SSRS
Vision for SharePoint
Chart for SharePoint
Gauge for SharePoint
Map for SharePoint
Barcode for SharePoint
