Super Data Grid WinForms Control

DotNetBar Super Data Grid is complete grid/editors control for your Windows Forms applications. It includes built-in data-binding, numerous editors, master-detail support, nested tables, built-in virtualization and much more.

Master-Detail Data Grid

DotNetBar SuperGrid includes support for Master-Detail views through binding and even when you are doing everything in code. Control has been designed from ground-up to include powerful data presentation functionality.

Data-Binding

SuperGrid automatically binds to your most common data-sources like DataSets, IList, IListSource, IBindingList etc. and automatically loads your data.

Grid Editors

SuperGrid includes number of built-in editors that you can use to edit your data. You can also add new custom editors yourself for complete editing control. Here is screen-shot showing just few editors in our data grid:

Some of the editors included:

• Text-Box
• Text-Box with drop-down
• Date-Time
• Integer type numeric input
• Double type numeric input
• Numeric up/down
• Check-Box
• Button
• Combo-Box
• Micro-charts
• Progress-bar
• Rating star
• Slider
• Gauges
• IP Address input
• Masked Text-Box
• And More...

Filtering

SuperGrid includes powerful filtering engine that allows your end users to easily find and narrow data displayed in the grid. We included both easy filtering mode as well as more powerful custom filtering expression engine. Following screenshot shows filter icon being added to each grid column which allows easy filtering of data:

When filtering with more options is needed built-in expression engine allows you to set filters like: "(Age IS BETWEEN 20 AND 30) AND (Age != 25)" or "(LastName IS NOT EMPTY) AND (Age IS NOT NULL)" to filter the data with custom expressions. Following screenshot shows the custom filtering entry dialog:

Data Grouping

The SuperGrid supports single and multiple Column grouping, with the ability to specify the sort direction for each group. It provides the end-user UI for creating groups and sorting. Following screen-shot shows grouping in SuperGrid control:

The SuperGrid supports user rendering of additional "detail" group rows through the dynamic use of the GetGroupDetailRows event. Group Detail Rows are temporary rows that can be added by the application following a SuperGrid grouping operation. Group Detail Rows are automatically removed when the grouping changes (either cleared or set/reset to another group criteria). Group Detail Rows are totally defined and rendered by the user application - the row’s content is neither known nor managed by the grid. Following screen-shots from sample app included with DotNetBar shows how detail group rows are used to add totals to the SuperGrid:

Virtualization

SuperGrid built-in support for virtual data allows you to present huge amounts of data without degrading grid performance. Sample application included with DotNetBar shows how to use virtualization to present 2 million rows.

Spreadsheet Tables

SuperGrid can be easily used to provide spreadsheets in your application. It even includes formula engine so you can have calculated cell values entered directly by the user.

Cell and Column Merging

SuperGrid includes ability to perform cell and column merging. Following screen-shot shows an example of cell merging:

Here are some main cell merging features:

• Merging of the formatted cell data unclutters the grid display area and makes data transitions easier for the user to recognize and evaluate.
• Cell merging is available in all grid presentations (bound, unbound, virtual, non-virtual, grouped, ungrouped, filtered, etc).
• The SuperGrid dynamically performs its merging operation on the current displayed “View”, meaning that the grid does not attempt to exhaustively merge all data in every row and every column, but rather only merges the current displayed set of rows/columns. As a result, you can have a 2,000,000 row virtual grid that quickly merges the data as well as a 60 row grid.
• The cell merging can be set to merge either Horizontally Left, Horizontally Right, or Vertically. It can also be set to any of those modes logically combined together.
• The "mode" with which the cell data is merged (horizontal/vertical/etc), can be set at the grid level, or at the individual column level (thus overriding the default grid level setting).
• The grid can also be told what order (horizontal vs vertical) to perform the merging operation in. The cell merging order can be set to merge the data either horizontally first, then vertically – or vertically first, then horizontally.
• All merged data can be automatically evaluated and processed by the grid, or it can be partially (or completely) overridden by the user application, thus giving the application complete control over what is – or is not – merged and presented to the user.
• Each merged area can have its own Style definitions (Default, MouseOver, etc). They each have their own Tooltips, MiniMarkup support, etc. Each area can even be totally (or partially) rendered by the application if desired.
• Each merged group can be UI enabled or disabled by the application. If enabled, the user can double-click on the merged group to temporarily “unmerge” the area and enable editing of each individual cell contained within the area. Once the user clicks outside the merged area, the merging of the area will resume.

Following screen-shot shows an example of column header merging:

Here are column header merge features:

• The SuperGrid supports grouping of column headers together, to present a more organized and informative grid layout.
• The number, or levels, to which headers may be grouped, is solely at the discretion of the application – you could have 2 levels of headers, or 20 levels – whatever the application needs.
• Once grouped, the user can fully interact with the grouped headers (move, resize, click, etc).
• You can specify ‘how’ the user can interact with the header (select, reorder, sort, etc), just as you can with base column headers.
• Group Headers can span both individual columns as well as sub-defined GroupHeaders – within the same grouping.
• The default column headers (as defined by the column itself) can either be shown or hidden for all columns that the group header encompasses.
• You can specify the Text, HeaderStyle, and ToolTip for each header group.
• Mini-Markup support can be enabled on a header-by-header basis.
• Each GroupHeader can have its own Style definitions (Default, MouseOver, etc). They each have their own Tooltips, MiniMarkup support, etc. Each header can even be totally (or partially) rendered by the application if desired.

There is so much more to SuperGrid. Please download DotNetBar trial and check out the sample project which shows most of major SuperGrid functionality.