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.
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.
SuperGrid automatically binds to your most common data-sources like DataSets, IList, IListSource, IBindingList etc. and automatically loads your data.
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:
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 colum 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:
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:
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.
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.
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:
Following screen-shot shows an example of column header merging:
Here are column header merge features:
There is so much more to SuperGrid. Please download DotNetBar trial and check out the sample project which shows most of major SuperGrid functionality.