Importing TDBGrid

• Dec 28, 2020
• 3 minutes to read

This topic describes the properties imported from the standard Delphi TDBGrid to ExpressQuantumGrid. See the Converting to ExpressQuantumGrid document which describes working with the Import dialog and gives general pointers on importing third-party grid controls to the native format of EQGrid.

The converter imports a source TDBGrid into a new Table View represented by the target TcxGridDBTableView class.

The following grid View elements are imported from a TDBGrid control by the Import tool:

• the DataSource property

• columns and their attributes such as column width, caption, alignment, and visibility status

The type of a column being created is based upon TColumn (a TDBGrid column) properties according to the following table. The column type is assigned via the PropertiesClass property. You can refer to the Data Editing Using Inplace Editors for more information on editing grid cells.

The following table describes the column types assigned based on combinations of TColumn properties:

TColumn properties	Column type assigned to a corresponding TcxGrid column
ButtonStyle = cbsAuto AND Field.FieldKind = fkLookup	A lookup combo box editor (TcxLookupComboBoxProperties).
ButtonStyle = cbsAuto AND Field.FieldKind <> fkLookup AND PickList.Count > 0	A combo box editor (TcxComboBoxProperties).
ButtonStyle = cbsAuto AND Field.FieldKind <> fkLookup AND PickList.Count = 0	A text editor (TcxTextEditProperties).
ButtonStyle = cbsEllipsis	A button editor (TcxButtonEditProperties).
ButtonStyle = cbsNone AND (ReadOnly = True OR Alignment <> taLeftJustify)	A text editor (TcxTextEditProperties).

If your TColumn does not meet any of the conditions listed in this table, then the new column’s type will be exclusively determined by the field type. This is discussed in the FieldName topic of this help system.

• grid options

The next table describes the TDBGrid options imported to ExpressQuantumGrid. The second column specifies the properties of an EQGrid control which are set according to the flags included in the TDBGrid.Options property (unless otherwise indicated, an EQGrid property is set to True or False if a corresponding TDBGrid flag is enabled or disabled, respectively).

Flags enabled in the TDBGrid.Options property	The corresponding EQGrid property
dgAlwaysShowEditor	The View’s OptionsBehavior.AlwaysShowEditor property.
dgAlwaysShowSelection	The View’s OptionsSelection.HideSelection property. This property is set to False, if the flag is enabled. Otherwise, it is set to True.
dgCancelOnExit	The View’s OptionsData.CancelOnExit property.
dgColumnResize	The View’s OptionsCustomize.ColumnHorzSizing property.
dgColLines, dgRowLines	The View’s OptionsView.GridLines property. It is set to glNone, glHorizontal, glVertical or glBoth based on the flag combination.
dgConfirmDelete	The View’s OptionsData.DeletingConfirmation property.
dgEditing	The View’s OptionsData.Editing property.
dgIndicator	The View’s OptionsView.Indicator property.
dgMultiSelect	The View’s OptionsSelection.MultiSelect property.
dgRowSelect	The View’s OptionsSelection.CellSelect property. This property is set to False, if the flag is enabled. Otherwise, it is set to True.
dgTabs	The View’s OptionsBehavior.FocusCellOnTab property.
dgTitles	The View’s OptionsView.Header property.

• color and font settings

The look & feel of EQGrid is maintained by a number of style properties which identify the background and foreground colors and font attributes specific to particular grid elements. The converter imports the color and font settings of a TDBGrid control as style objects and applies them to the corresponding TcxGrid elements:

Color and font settings of TDBGrid	The corresponding EQGrid style property(s)
TDBGrid.Color and TDBGrid.Font	The View’s Styles.Content style.
TDBGrid.FixedColor and TDBGrid.TitleFont	The View’s Styles.Header and Styles.Indicator styles.
TColumn.Color and TColumn.Font	The column’s Styles.Content style.
TColumn.Title.Color and TColumn.Title.Font	The column’s Styles.Header style.