True DBGrid Designer

In This Topic

The C1TrueDBGrid Designer can be accessed either through the C1TrueDBGrid Tasks menu, the Columns property, or the context menu. To access the C1TrueDBGrid Designer through the C1TrueDBGrid Tasks menu, you can click the smart tag in the upper right corner of C1TrueDBGrid to open the C1TrueDBGrid Tasks menu, and then select the Designer option. Also, to access the C1TrueDBGrid Designer through the Columns property, you can click the ellipsis button next to the Columns property in the Properties window. To access the C1TrueDBGrid Designer through the context menu, you can right-click the C1TrueDBGrid control on the form and then select Design from the context menu.

TrueDBGrid Designer Elements

This designer allows grid columns to be set up easily at design time instead of having to write the code. Just select the grid, then right-click to bring up the context menu, and then click the Design menu item. This will bring up the C1TrueDBGrid Designer shown below:

The editor displays the grid columns in a window on the right and the properties for these columns on the left. The tabs above the Properties window define which set of properties, DataColumn, DisplayColumn, or Split, are displayed in the properties grid.

The editor performs the following actions:

Reorder Columns: Move columns to new positions by dragging them by the header cells with the mouse.
Adjust Column Widths: Adjust column widths by dragging the right edge of the header cells with the mouse. You can also select multiple columns by SHIFT-clicking the header cells, and then set all column widths at once using the property grid. Setting the column width to -1 restores the default width.
Set Column Properties: Whenever one or more columns are selected, their properties can be viewed and edited in the property grid on the left of the editor.
Insert or Remove Columns: Use the toolbar to insert columns before or after the selection (useful mostly in unbound mode), or to remove columns.
Use the Toolbar to Perform Common Tasks: The table below describes the function of the buttons on the toolbar:

Element	Description
	These tabs above the property grid determine which set of properties are available for modification in the designer. The tabs allow you to choose between the DataColumns property set that contains data-related column properties, the DisplayColumns property set that contains display-related column properties, and the Split property set that contains split-related properties.
	These buttons set the column widths for the grid. The left button sets all the columns to have the same width, the center button increases the width of the selected column (the column with focus in the grid), and the right button decreases the width of the selected column (the column with focus in the grid).
	These buttons add, insert, and delete columns from the grid. The first adds columns to the grid, the second button inserts columns in the grid, and the third button deletes columns from the grid.
	The drop-down box sets which column receives focus. By choosing a column from the drop-down list, the associated properties for this column will appear in the property grid to the left.
	These buttons set the vertical alignment of the selected column. The first button aligns all column content to the top. The second button aligns all column content to the center, and the third button aligns all column content to the bottom.
	Align column content to the left, center, or right. These buttons only affect the scrollable area of the grid. To set the alignment for the header columns, select the columns and set the TextAlignFixed property.
	These buttons add or remove vertical or horizontal splits. The first button adds a vertical split to the grid, while the second one adds a horizontal split. The third button removes a vertical split, while the fourth one removes a horizontal split.
	These buttons set the DataView property of the table. The buttons set the DataView property to Normal, GroupBy, Hierarchial, Inverted, Form, MultipleLines, and MultipleLinesFixed, respectively. See Views for more information.

There are three types of properties enumerated in the TrueDBGridDesigner:

Splits Properties

The following SplitCollection object properties are available in the C1TrueDBGrid Designer through the Split tab:

Property	Description
AllowColMove	Gets or sets a value indicating the ability to move columns.
AllowColSelect	Gets or sets a value indicating the ability to select columns.
AllowFocus	Gets or sets a value indicating whether the split can receive focus.
AllowHorizontalSizing	Gets or sets a value indicating whether a user is allowed to resize horizontal splits.
AllowRowSelect	Gets or sets a value indicating the ability to select rows.
AllowRowSizing	Gets or sets how interactive row resizing is performed.
AllowVerticalSizing	Gets or sets a value indicating whether a user is allowed to resize vertical splits.
AlternatingRowStyle	Gets or sets a value indicating whether the split uses the OddRowStyle for odd-numbered rows and EvenRowStyle for even-numbered rows.
BorderStyle	Gets or sets the type of border rendered for a split.
Caption	Gets or sets the caption.
CaptionHeight	Gets or sets the height of the caption.
CaptionStyle	Gets or sets the Style object that controls the appearance of the caption area.
ColumnCaptionHeight	Gets or sets the height of the column captions.
ColumnFooterHeight	Gets or sets the height of column footers.
DisplayColumns	Gets a collection of C1DisplayColumn objects.
EditorStyle	Gets or sets the Style object that controls the appearance of the cell editor within a grid.
EvenRowStyle	Gets or sets the Style object that controls the appearance of an even-numbered row when using AlternatingRows.
ExtendRightColumn	Gets or sets a value that determines how the last column will extend to fill the dead area of the split.
FetchRowStyles	Gets or sets a value indicating whether the FetchRowStyle event will be raised.
FilterBar	Gets or sets a value indicating the visibility of the FilterBar.
FilterBarStyle	Gets or sets the Style object that controls the appearance of the FilterBar.
FilterBorderStyle	Controls the appearance of the separator for the FilterBar.
FooterStyle	Gets or sets the Style object that controls the appearance of column footers.
HeadingStyle	Gets or sets the Style object that controls the appearance of the grids column headers.
Height	Gets or sets the height of a split.
HighlightRowStyle	Gets or sets the Style object that controls the current row/cell when the MarqueeStyle is set to Highlight Row/Cell.
HorizontalScrollGroup	Gets or sets the group which synchronizes horizontal scrolling between splits.
HScrollBar	Gets the HBar object that controls the appearance of the horizontal scroll bar.
InactiveStyle	Gets or sets the Style object that controls the grids caption when it doesn't have focus.
Locked	Gets or sets a value indicating if the cells of a split can be edited.
MarqueeStyle	Gets or sets the MarqueeStyle for a Split.
MinHeight	Gets or sets the minimum height that a split can be interactively resized.
MinWidth	Gets or sets the minimum width that a split can be interactively resized.
Name	Gets or sets the name of a split.
OddRowStyle	Gets or sets the Style object that controls the appearance of an odd-numbered row when using AlternatingRows.
RecordSelectors	Gets or sets a value indicating the visibility of row headers for Split.
RecordSelectorStyle	Gets or sets the Style object that controls the appearance of the RecordSelectors.
RecordSelectorWidth	Gets or sets the width of the row headers.
SelectedStyle	Gets or sets the Style object that controls the appearance of selected rows and columns.
SplitSize	Gets or sets the size of a split.
SplitSizeMode	Gets or sets a value indicating how the SplitSize property is used to determine the actual size of a split.
SpringMode	Gets or sets a value that determines how columns will resize when the grid is resized.
Style	Gets or sets the root Style object for the Split.
VerticalScrollGroup	Gets or sets the group which synchronizes vertical scrolling between splits.
VScrollBar	Gets the VBar object that controls the appearance of the vertical scroll bar.

DataColumn Properties

The following C1DataColumnCollection object properties are available in the C1TrueDBGrid Designer through the Column tab:

Property	Description
Aggregate	Gets or sets the type of aggregate computed for a grouped row.
ButtonPicture	Gets or sets the image shown in a drop-down button in a column.
Caption	Gets or sets the text in the column header.
DataField	Gets or sets the database field name for a column.
DataWidth	Gets or sets the maximum number of characters which may be entered for cells in this column.
DefaultValue	Gets or sets the default value for a column when a new row is added by the grid.
DropDown	Gets or sets the C1TrueDBDropDown control associated with this column.
EditMask	Gets or sets the edit mask for a column.
EditMaskUpdate	Gets or sets a value indicating whether literal characters in the edit mask are stored to the underlying data source.
EnableDateTimeEditor	Gets or sets the characters that should be escaped when applying the filter criteria to the data source.
FilterButtonPicture	Gets or sets the image show in the filter button for the column.
FilterDropdown	Gets or sets a value indicating whether a drop-down list is displayed in the filter cell that lists all the values of the field.
FilterEscape	Gets or sets the characters that should be escaped when applying the filter criteria to the data source.
FilterKeys	Gets or sets the key used to initiate the filtering operation as the user types in the FilterBar.
FilterOperator	Gets or sets the operator that is used for a filter expression.
FilterText	Gets or sets the data associated with the value of the filter for a column.
FooterText	Gets or sets the text displayed in the column footer.
GroupInfo	Gets or sets the GroupInfo associated with this column.
Level	Gets or sets the level of this column in a hierarchical data source.
NumberFormat	Gets or sets the formatting string for a column.
SortDirection	Gets or sets the state of the sorting glyph in the column caption.
ValueItems	Gets the ValueItems object for this column.

DisplayColumns Properties

The following C1DisplayColumnCollection object properties are available in the C1TrueDBGrid Designer through the Display Column tab:

Property	Description
AllowFocus	Gets or sets a value indicating the ability of a column to receive focus.
AllowSizing	Gets or sets a value indicating whether column resizing is allowed.
AutoComplete	Gets or sets a value indicating whether the drop-down auto fills the edit portion with the matched entry.
AutoDropDown	Gets or sets a value indicating whether the drop-down opens automatically when a key is typed.
Button	Gets or sets a value indicating whether a drop-down button will be displayed in this column.
ButtonAlways	Gets or sets a value indicating whether buttons will be displayed when the cell does not contain focus.
ButtonFooter	Gets or sets a value indicating whether a column footer will act like a button.
ButtonHeader	Gets or sets a value indicating whether a column header will act like a button.
ButtonText	Gets or sets a value indicating whether cells in this column look like buttons.
ColumnDivider	Gets or sets the style of the border drawn between columns.
DropDownList	Gets or sets a value indicating whether the drop-down acts like a drop-down list (text portion is not editable).
EditorStyle	Gets or sets the Style used for the cell editor.
FetchStyle	Gets or sets a value indicating whether the FetchCellStyle event will be raised for a column.
FilterButton	Gets or sets a value indicating whether a drop-down button will be displayed in this column.
FooterDivider	Gets or sets a value indicating whether to display the column divider in the footer area.
FooterStyle	Gets or sets the Style object that controls the appearance of column footers.
Frozen	Gets or sets a value indicating whether the column scrolls.
GroupFooterStyle	Gets or sets the Style used to render the cell in the grouped footer row.
GroupHeaderStyle	Gets or sets the Style used to render the cell in the grouped header row.
HeaderDivider	Gets or sets a value indicating whether to display the column divider in the header area.
HeadingStyle	Gets or sets the Style that controls the appearance of the column headers.
Height	Gets or sets the height of the column.
Locked	Gets or sets a value indicating whether editing is permitted in a column.
Merge	Gets or sets a value indicating whether contiguous like-value cells of this column are merged into one large cell.
MinWidth	Gets or sets the minimum width a column can be resized to when in SpringMode.
Name	Gets the caption of the associated C1DataColumn objects.
OwnerDraw	Gets or sets a value indicating whether cells in this column are drawn by the user in the OwnerDrawCell event.
Style	Gets or sets the root Style for this column.
Visible	Gets or sets a value indicating the visibility of a column.
Width	Gets or sets the width of a column.