Main Features - GridView
- 5 minutes to read
Data Specifics
- Binding to Data - GridView is designed to function in bound mode only. GridView can be easily bound to any Model data passed by a Controller. (See demo: Data Binding)
- Binding to Large Data (Database Server Mode) - has been designed to work with large datasets (consisting of 50,000 records and even more). Bound data is not loaded into memory in its entirety. Instead, GridView loads data in small portions on demand. When the grid starts, it loads and displays the first portion of data from the data store. Then, as an end-user scrolls the grid, when the last record of the loaded subset is reached, the grid requests the data store to return a subsequent data portion. (See demo: Data Binding to Large Database)
- Unbound Columns - It is possible to combine bound and unbound data modes. Just add unbound columns and supply their data manually. (See demos: Filtering, Data Summaries, Export - the Total column)
- Master-Detail Support - GridView allows you to present master-detail information of any complexity. (See demo: Master-Detail)
Data Editing
- Built-in Edit Modes - GridView provides two built-in edit modes: editing via the Edit Form and In-Cell editing. (See demo: Edit Modes)
- Row Validation and Error Indication - GridView supports automatic or manual validation of the edited row. Error messages can be automatically displayed for invalid fields. (See demo: Edit Modes)
- Batch Editing - The GridView extension allows you to modify a batch of grid data on the client side and send it to the server in a single request. (See demo: Batch Edit Mode)
Data Shaping and Manipulation
- Automatic Data Sorting and Grouping - Allow your users to sort and group the data against an unlimited number of columns, giving them an unprecedented ability to analyze and edit information. (See demos: Sorting, Grouping)
- Full Data Summaries - Summaries allow you to present statistical information such as MIN, MAX, AVG, SUM, and COUNT directly in the grid itself, without having to resort to the age-old ugly work around of using an individual edit control. Even better: You can handle summary specific events to implement complex functions with ease. Standard deviation and all sorts of other statistical formulas are now available. (See demo: Data Summaries Via Aggregate Functions)
- Custom Text for Summary Values - You can provide custom display text for any summary value (group or total summary) and this will be used when exporting the grid.
- Filtering by Values and Display Text - For each column, you can specify how the column’s data should be filtered - by edit values or displayed values. (See demo: Filtering)
- Auto Filter Row - This allows end-users to filter data on the fly - by typing values directly within this row. (See demo: Filter Row)
- Preview Rows - With preview rows, you can let your end-users view large text or memo fields directly in GridView, without the need to open an external editor or drop-down window. (See demo: Preview)
- Multiple Records Selection - GridView supports single and multiple row selection modes. (See demo: Row Selection)
- Runtime Column Customization - With GridView, your end-users can control the appearance of the grid as they wish, by adding and removing columns using drag and drop. (See demo: Customization Window)
- Band Columns - The GridView’s multi-row headers feature allows you to organize grid columns in logical groups (bands). (See demo: Multi-Row Headers (Bands))
- Column Freezing - GridView allows you to anchor columns (and bands) on its left side. When anchored, columns are always displayed within the grid, regardless of its horizontal scrolling.
Focus and Navigation
- Built-in Pager - GridView automatically splits content across multiple pages and provides a built-in pager that enables end-users to navigate through data. (See demo: Paging)
- Focused Row - GridView enables end-users to move focus through rows by clicking them. (See demo: Focused Row)
- Scrolling - GridView offers both vertical and horizontal scrolling. To reduce GridView’s width and height, you can display its horizontal and vertical scrollbars and specify the width and height of the scrollable area. (See demo: Scrolling)
Appearance Customization
- Appearances - A powerful mechanism to control the entire look and feel of the grid. You can customize the appearance of almost any visual element of GridView and even apply them conditionally to reflect certain states, such as errors. In addition, GridView ships with a number of predefined themes. These themes allow you to specify its appearance and behavior as your business needs dictate.
- Templates Technology - Templates are fully supported. For each element inside GridView, you can completely customize the appearance or layout using any HTML content. (See demos: Templates, Edit Form Template, help topic: Templates)
- Conditional Formatting - With GridView, you have a flexible mechanism to control conditional cell and row formatting.
- Full CSS Support - GridView’s appearance can be customized using CSS classes. This approach is the best choice if you need centralized control over the appearance of several controls or the entire site.
Miscellaneous
- Cross-Browser Compatibility - Internet Explorer, Mozilla Firefox, Google Chrome, Opera, Apple Safari, etc. GridView is cross-browser compatible.
- Rich Client-Side Functionality - A comprehensive client-side API is available for GridView. This functionality, which is then coupled with the ability to handle events on the client side, allows you to have full control over the grid’s behavior on the client side.
- Client-Side Events - GridView exposes a rich set of client-side events. These events are executed on the client side and have been engineered to maximize performance.
- Cookies Support - GridView control fully supports cookies, allowing your site’s visitors to personalize pages as needed. If cookies are enabled, every possible end-user customization option is saved and then restored in future sessions.
- Save and Restore Layout - GridView allows you to save the information on its layout to a database, and then restore it.
- Export - GridView allows you to export its data to PDF, CSV, XLS, XLSX and RTF formats. (See demo: Exporting Data)