NOV Grid for .NET Features

NOV Grid for .NET supports data-binding to a diverse set of data sources. The Grid displays data from a data source assigned to its DataSource property.

A data source is an attribute that aggregates a Data Table. Data Tables help you define data in memory or bind it to different collections of objects. You can work with all types of data tables consistently and intuitively. The Data Table exposes various operations that help you add/remove fields and rows, get or set cell values, and perform different queries.

With NOV Grid for .NET, you can load 1M+ records (million records) without compromising performance.

The Grid instantly allows end-users to perform Smooth Scrolling, Grouping, Sorting and Filtering on hundreds of thousands of records without lags or delays.

Master-Details is a feature of the Table Grid that allows you to display additional information (details) for each record data row.

Master-Details allows you to display other table data 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 the 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 extracting information about a specific data row from another source. There are two types of calculated columns:

• Formula Calculated Column - this is a calculated column that is defined as a formula. The value this column assigns to each row results from 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 .NET provides strong support for authoring complex cell conditions.

Besides static fill rules, NOV Grid for .NET also supports gradient background and text fill declarations that can be defined as two- or three-color gradients.

The NOV Grid 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 also supports Custom Column Formatting, allowing you to use any NOV widget to represent the row values, e.g., Charts, Gauges, Barcodes, or other widgets.

Resizing Grid columns - Resizing Grid columns can determine the width of the column in several ways:

• Auto
• Fixed
• Size To Cells
• Size To Header
• Percent

The user can also resize the columns or double-click the column separators to "best fit" the columns.

Reordering Grid columns – allows the user to change the order of the columns by dragging them.

NOV Grid for .NET 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 the FrozenRows grid property controls them. It specifies the count of rows from the top of the grid that is non-scrollable.

Grid protection refers to the set of properties that can help you restrict the user to perform specific actions with the grid in general.

For operations that apply to columns, a respective Column Protection property can restrict the same operation for a specific column only.

NOV Grid for .NET provides support for Null Values. The Grid also supports editing of null values.

The Grid selection is organized to work around grid rows and 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 change the current cell. The selection also exposes properties that control the events triggering recent cell editing.

The Grid alternating rows are helpful 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 .NET provides full control over the alternating rows appearance, interval and length.

NOV Grid for .NET features several gridlines 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 complete control over the appearance of the gridlines stroke.

NOV Grid for .NET provides full localization support and right-to-left support.

The NOV Framework Localization support allows you to translate your applications' entire user interface (UI).

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 Grid row values, for example, Charts, Gauges, Barcodes, or other widgets.