ComponentOne True DBGridВ® is the most robust grid available for enterprise-wide database front-end application development. End users can browse, edit, add, and delete data in a tabular format with True DBGrid. It includes dozens of advanced data access, data presentation, and UI features.

Data Options
Allow your users to explore data in different projections and hierarchies with OLAP support
True DataControlв„ў integration adds powerful data access and manipulation capabilities
Summarize complex data concisely with True DataControl Lite's crosstab presentation support
Present data in different formats: Form View and Inverted Mode provide context for your data
Save single grid layouts to a file and reuse them in other projects
Store multiple layouts in a single grid at design time, then load them as needed in code
Save user layout preferences to a file and recall them the next time the application runs
Display Options
Customize row, column, and cell borders
Connect a True DBDropDown control to translate grid cells to drop-down values
Proportionately resize columns when the grid is resized horizontally
Merge like-valued cells of a column into a single cell
Create fixed, non-scrolling columns anywhere in the grid
Performance Options
Track the location of your scroll bar, and give users an informational pop-up window with scroll tracking and scroll tips as the scroll bar moves
Read More В»

Enhanced print options — like additional zoom and print preview capabilities — give you full control over printing
True DBGrid includes support for both right-to-left and left-to-right languages
Select any range of cells in addition to selecting rows and columns
Implement custom end-user operations — like incremental search and recordset filtering — with an easy-to-use interface
Allow end users to dynamically reorder or group fixed, non-scrolling columns on the left side of the grid as in Microsoft Outlook

The OLE DB version of True DBGrid includes a feature called "Outlook-Style Grouping." The purpose of this feature is to allow users to dynamically configure fixed, nonscrolling columns on the left side of the grid as in Microsoft Outlook. When in Group mode, a "grouping area" is added to the top of the grid, providing an intuitive interface for specifying column groups. In code, this feature is supported by the GroupColumns collection, which contains the columns that have been moved to the grouping area; it is similar to the Columns collection.

The grouping area is created when DataView is set to 2 - Group. When AllowColMove is set to True, the grid will support the ability to move one or more columns into this area. Users can do this by selecting a single column and dragging its header into the grouping area. This action can also be performed in code at run time by invoking the Add method of the GroupColumns collection. When a column is first added to the grouping area, a new split is created on the left side of the grid. Similarly, when the last column is removed from the grouping area, the (now empty) split is deleted.

When a column is added to the grouping area, either in code or by user interaction, its Merge property is implicitly set to True. Therefore, if adjacent fields are identical in a grouped column, those fields are rendered as a single non-editable cell, as shown in the following illustration.

It is important to note that the act of moving columns to or from the grouping area does not sort the underlying data source; it simply provides a convenient way to manipulate a split containing nonscrolling columns. Therefore, if you want a grouped column to appear in sorted order, you must sort it explicitly in code. Typically, this is done in the GroupColMove event, which is fired before a column is moved to or from the grouping area. You can also use the GroupHeadClick event, which is fired when a column header is clicked within the grouping area.

To manipulate the grouping area in code, use the GroupColumns property to access the collection of grouped columns. Like the Columns collection, the GroupColumns collection supports Add, Item, and Remove methods, as well as a Count property. However, since the GroupColumns collection serves as a placeholder for existing grid columns, the semantics of its Add and Remove methods are different.

The Add method moves an existing column to the grouping area; it does not create a new column in the grid. Similarly, the Remove method removes a column from the grouping area and returns it to its original position within the grid; it does not delete the column altogether. Also, the Remove method implicitly restores the previous value of the Merge property of the affected column.

Only for V.I.P