Sales
 
1-888-9DOTNET
Gridcontrol
Data Populating and Virtual Mode
There are two modes for populating the Grid control with data (cell values and the required cell styles). You can use its internal data storage or provide the data on demand through virtual mode. To use the Grid control’s internal data storage, you can simply set the cell styles using the grid indexer. To configure the Grid control in virtual mode, you need to dynamically provide data to the grid through an event. This means that the grid does not store any data in its internal data structures. A virtual grid can display millions of rows as easily as it displays a dozen. The grid also exposes a second event that lets you save changes made through the grid's UI back to the external data source.
feature image
Grid Control with Large Number of Rows
Cell Styles
Essential Grid is a cell-oriented control and allows you to apply styles at the cell level. Individual cells can be customized in different formats. Every cell in a grid is associated with a list of attributes that affect the appearance of the grid cells.
feature image
Various Cell Styles
Cell Types
The Grid control supports several cell types including text box, combo box, combo box autocomplete, check box, button, numeric spin box, drop-down list, drop-down calculator, password, link label, color picker, chart, progress bar, rich text, picture box, slider, UI editor, Web browser, XHTML, radio button, embedded grid cells, and editor types like masked edit, double edit, integer edit, percent edit, button edit, and date-time edit. In addition, you can place any Windows Forms control or any custom control inside a cell using the control cell type.
feature image
Different Cell Types
Cell types are implemented using a highly efficient flyweight pattern-based architecture. Thousands of cells can share the same control instance providing tremendous savings in resources. This enables Essential Grid to handle billions of rows with ease. The Grid control provides a pluggable cell renderer architecture for easily implemeting custom cell types without compromising on performance.
Alpha Blending
Essential Grid supports alpha blending and background bitmaps. The alpha value can be applied to individual cells or base styles by changing the interior cell attribute.
feature image
Grid Background with Alpha Blending
Banner cells allow users to combine the background of neighboring cells to display a background image or gradient brush. Users can load an image from a file on disk and display it in a cell, as a gradient among cells, or create custom cell backgrounds.
feature image
Banner Cells
Covered Cells
Multiple cells can be covered to exhibit the behavior of a single cell. This makes it easy to display special items such as titles and bitmaps such that they occupy multiple cells.
Covered cells blend seamlessly with Essential Grid's keyboard navigation model. Covered cells can also host any Essential Grid control type. They can be interactively created and cleared by end users. Formatted covered cells with their own borders are illustrated below:
feature image
Covered Cells
Merged Cells
Merged cells allow users to display adjoining cells with similar values as a single cell. The merging is dynamic. If a cell's value changes, the grid will automatically adjust the merged cells.
feature image
Merged Cells
Format Cell Dialog
Essential Grid exposes an Excel-like >Format Cells dialog that aids in dynamic cell formatting. It now comes with options such as font, number, background and alignment. With this feature available, you can format numerous grid cells with ease.
feature image
Partial Format Cells Dialog
Freeze Rows and Columns
Frozen columns and rows stay stationary much like the default headers when scrolling through the body of a grid. They are very useful when an application requires header rows or columns in addition to default headers.
feature image
Frozen Column Headers
Frozen columns are moved to the far left of the grid and remain there when the grid is scrolled.
feature image
Frozen Columns
Frozen rows are moved to the top of the grid and remain there when the grid is scrolled.
feature image
Frozen Rows
Frozen rows and columns are typically used in reporting applications where there is a need for extensive header information. A unique aspect of Essential Grid's frozen rows and columns is that they can be configured to any cell type. They do not have to look like the header row.
GDI+
All Essential Grid drawing code is implemented using GDI+. GDI+ is the C++ based version of its predecessor GDI (Graphics Device Interface). GDI+ is an improved 2-D graphics environment with advanced features such as anti-aliased 2-D graphics, floating point coordinates, gradient shading, more complex path management, and intrinsic support for modern graphics-file formats like .jpeg and .png.
This enables Essential Grid cells to display gradients, rotate text and support transparency.
feature image
Gradient Cell-Using GDI+
feature image
Rotated Text-Using GDI+
Selection Modes
Essential Grid offers different kinds of selection modes such as row only, column only, cell only, and more.
feature image
Selection Modes
List Box Selection Mode
Essential Grid can simulate a list box control. All three list box modes are supported: one, multi-simple, and multi-extended. The list box can be bound to any collection or ADO.NET table.
feature image
Grid List Box—One Select Mode
feature image
Grid List Box—Multi-Simple Select Mode
feature image
Grid List Box—Multi-Extended Select Mode
A grid list box can be used as the list box part of a combo box with AutoComplete support. Both the "drop-down with AutoComplete support" and "drop-down list" styles known from regular combo boxes are supported.
feature image
Grid with Combo Box
Keyboard Interface
Essential Grid provides extensive support for keyboard handling.
Arrow keys—move current cell PAGE UP/PAGE DOWN key—scroll through grid pagesF2—activate/deactivate cellF4 + ALT—Drop-down/Close-Up cellCTRL+arrow keys—move to first/last, row/columnSHIFT + Arrow keys—select cellDELETE key—delete cellCTRL + X, CTRL + V, CTRL + C, INSERT key and DELETE key support common clipboard operations
All keyboard operations can be customized.
MDI Support
Essential Grid extends its support to Multiple Document Interface (MDI) by allowing users to work with multiple grid controls at the same time.
feature image
MDI Support
Mouse Operation
Essential Grid's mouse and hit-testing operations are implemented using a special MouseController pattern. This allows easy implementation of custom mouse operations pertaining to different hit test contexts.
feature image
Button Appearance Change and Tactile Feedback due to Mouseover
This architecture fully supports the Windows Forms framework with events such as MouseHover, MouseLeave, and MouseEnter.
Scrolling Support
The Grid control offers very flexible scrolling support. It supports accelerated scrolling similar to Microsoft Office applications. Holding down the scroll button generates accelerated scrolling. Users can also select cells and move them to the edge of the control's scrollable area to scroll through the grid. A grid can be hooked to an external scroll bar or can have common scroll bars for two or more grid controls. It also supports IntelliMouse scrolling and has the option to display scroll tips when dragging the scroll box. The Grid control also supports automatic scrolling of cells when users click and drag the mouse wheel, similar to Microsoft Excel.
feature image
Accelerated Scrolling in Progress
feature image
Scrolling Left with the IntelliMouse
feature image
Grid Control Showing Scroll Tip
OLE DND and Clipboard
Essential Grid provides complete clipboard support. Users can copy and paste inside a grid, and from or to other OLE (Object Linking and Embedding) DND (Drag-and-Drop)-enabled applications that understand text format. OLE DND between two grids includes a custom format that allows users to copy or move complete style information including covered cells. Essential Grid also provides hooks for the easy addition of support for custom data formats.
feature image
OLE DND in Progress
Copy and paste, and drag-and-drop operations retain all formatting when performed between Essential Grid controls.
Multilevel Undo-Redo
The undo and redo commands add immeasurable value to the user interface of any application. The Grid control offers complete support for multilevel undo and redo operations. Any changes to the grid are saved in an undo list to perform subsequent undo and redo operations when needed.
feature image
Undo and Redo Lists
A group of such actions, called a 'transaction,' can be rolled back in a single step.
Formula Support
The Grid control supports MS Excel-like formulas in each cell. It comes with an extensive formula function library supporting more than 150 built-in formulas. You can also easily add custom functions to its function library. The Grid control also supports cross-sheet references and named ranges.
feature image
Grid with Formula Cell
feature image
Partial Formula Function List
feature image
Workbook-Style Grid with Cross-Sheet Reference
feature image
Named Ranges
Excel-like Features
The Grid control supports Excel-like user interactive features like cell range drag-and-drop, selection auto-fill, and visual indicators to show hidden rows and columns. It also provides Excel-like current cell for editing.
feature image
Excel-Like Fill Series
feature image
Single Column Resize
feature image
Multiple Column Resize
Pivot Grid
Essential Grid offers Excel-like pivot table feature. Using this feature, users can pivot data via drag-and-drop operations to organize the data in a cross-tabulated form. This allows users to present desired information from a large data list within seconds.
feature image
Pivot Grid
Record Navigation Bar
A MS Access-like record navigation bar lets users scroll through records in a table. The total number of records can also be displayed in the navigation bar next to the current record number.
feature image
MS Access-Like Record Navigation Bar
Document View Support
MFC applications are usually designed using the document-view pattern. This pattern is a variant of the Model View Controller (MVC) pattern. In practice, this refers to the complete separation between data and presentation, enabling the creation of extremely flexible and adaptable components.
Essential Grid provides complete separation between its data and display details. This allows users to easily implement multiple views of the same data, similar to MFC document-view applications.
feature image
MFC-Like Shared Data
Split Views
The Grid control view can be split into different sections using the Splitter control in Essential Studio.
feature image
Split Display of Records
Dynamic Splitters
Essential Grid can be used inside a dynamic splitter control. The control inside the split view will normally share the same data model, providing a sophisticated perspective of the same data, similar to Microsoft Excel.
feature image
Grid inside a Splitter Control
Dynamic splitting is a feature that adds extra usability to any user interface. Components must have pre-built support to provide split views.
Zooming Grid
Grid contents can be zoomed in and out as required. Some available zoom options include percentage zooming at grid level and zooming at cell level.
feature image
Grid Control Zoom Options
Grid Skins
The appearance of the Grid control can be enhanced by applying one of the several MS Office 2003, MS Office 2007, MS Office 2010, and Windows Vista styles available.
feature image
MS Office 2007 Blue
feature image
MS Office 2007 Black
feature image
MS Office 2007 Silver
feature image
MS Office 2003
feature image
Windows Vista
Serialization
Essential Grid supports versioned serialization of grid data to binary, .xml, and SOAP (Simple Object Access Protocol) formats. Future versions of Essential Grid will automatically read legacy files from earlier versions. Versioning is a must for applications that are expected to have a long market life span. However, many third party .NET controls on the market do not implement versioning because the default serialization provided in Windows Forms does not support versioning.
feature image
Serialization to SOAP-Formatted XML File
Essential Grid can be saved in SOAP format through gridControl.SaveSoap(filename).
MS Excel Import and Export
Grid control contents can be exported to MS Excel.
feature image
Grid Control to be Exported
feature image
Grid Contents Exported to MS Excel
Microsoft Excel file contents can also be imported to the Grid control.
PDF Export
Grid control contents can be exported to a PDF file. It also supports drawing custom header and footers.
feature image
Grid Control to be Exported
feature image
PDF of Exported Grid Contents
Print Support
Essential Grid provides complete support for print and print preview operations.
feature image
Print Preview
There is a special mode to display a grid in grayscale. This is especially useful when printing a grid using black ink. The grayscale print will exhibit finer discrimination between cells when compared to prints in regular color mode.
It also offers options to view the divided layout of a grid into pages at run time.
feature image
Print Page Layout
Call Toll Free
1-888-9DOTNET
Copyright © 2001 - 2012 Syncfusion Inc. All Rights Reserved
Privacy Policy | Contact Us | Sitemap
::adCenter::