Display graphic in grid background

DBGridEh lets you display a static image (type TPicture) in the background of the client area of the grid.

To customize the display graphic background use BackgroundData properties DBGridEh.BackgroundData.

DBGridEh.BackgroundData: TDBGridBackgroundDataEh

Property name	Property type	Description
Visible	Boolean	Specifies whether the Background Picture is visible in the grid.
Picture	TPicture	The Picture to draw as a Background Data.
Placement	TImagePlacementEh	Specifies the position of the image and the way of filling the free space TImagePlacementEh = ( ipTopLeftEh, ipTopCenterEh, ipTopRightEh, ipCenterLeftEh, ipCenterCenterEh, ipCenterRightEh, ipBottomLeftEh, ipBottomCenterEh, ipBottomRightEh, ipFillEh, ipFitEh, ipStretchEh, ipTileEh);
HorzMargin	Integer	Horizontal Shift
VertMargin	Integer	Vertical Shift
ExcludeTitle	Boolean	Delete the title of the fill graphic background.
ExcludeIndicator	Boolean	Delete button from the fill graphic background.
ExcludeFooter	Boolean	Delete the footer of the fill graphic background.

Search panel and filter data.

DBGridEh can display a special panel to search and filter the data in the grid.

In search mode, grid displays the search phrase in all grid cells in a different color (yellow by default).Grid also allows you to filter the data so that the screen will display only those records that include the search string.

To configure the settings panel, search and filter properties using sub-properties DBGridEh.SearchPanel.

DBGridEh.SearchPanel: TDBGridSearchPanelEh

Sub-properties properties TDBGridEh.Border:

Property name	Property type	Description
Enabled	Boolean	Set the Enabled property to True to activate the search and filter of the panel. Activate the Panel still does not mean that it will be immediately visible in the grid. Panel's visibility is set through property PersistentShowing.
PersistentShowing	Boolean	Specifies that the search panel always visible in the grid. If PersistentShowing = False, the panel becomes visible after pressing the key combination to activate the search through the panel in the property ShortCut.
ShortCut	TShortCut	Specifies the key combination to activate the search panel and give focus to the input text editor search bar. Defaults to "Ctrl + F".
Location	TSearchPanelLocationEh	Location of the search panel. Can take the following values: splGridTopEh - Search panel at the top of the grid above the title. splHorzScrollBarExtraPanelEh - Search panel is in the "extra-bar" thumb scroll horizontally. The search panel works correctly in this location, "extra-panel" slider is visible. splExternal - Search panel is outside the grid. In this mode, the algorithm of the search panel and drawing the sole responsibility of the developer.
FilterOnTyping	Boolean	Specifies that the grid will filter data as you enter text in the text editor panel of the search. If FilterOnTyping = False then the data will be filtered only by pressing the key «Enter» or click the Apply Filter button in the search panel.
FilterEnabled	Boolean	Specifies that filter is available in the search panel. If FilterOnTyping = False, then the search will only be available by code.

Extra horizontal scroll bar slider (ScrollBar).

DBGridEh allows displaying additional information in the horizontal scrolling section. In this case, the left side of the SrollBar is moved to the right so as to display information.

Area of additional information may include the following:

The number of entries in the DataSet and the number of selected records in a grid.
Navigation buttons on records (DBNavigator).
Search bar and filtering (SearchPanel).
Summary information about the selected data (MultiSelected area). Data section will be visible when the user selects a region in the grid, square area or column. In this case, in the summary information is displayed: The amount of data, number of selected rows, average, minimum and maximum value.

Use the sub-property DBGridEh.HorzScrollBar.ExtraPanel management options to display extra panel:

Property name	Property type	Description
Visible	Boolean	Set the Visible property to True to display additional panel horizontal ScrollBar
NavigatorButtons	TNavButtonSetEh	NavigatorButtons TNavButtonSetEh Use the NavigatorButtons property to determine which navigation buttons will be visible in the database navigator. TNavigateBtnEh = (nbFirstEh, nbPriorEh, nbNextEh, nbLastEh, nbInsertEh, nbDeleteEh, nbEditEh, nbPostEh, nbCancelEh, nbRefreshEh); TNavButtonSetEh = set of TNavigateBtnEh;
VisibleItems	TGridSBItemsEh	Use VisibleItems property to determine which items will be visible in the panel. TGridSBItemEh = (gsbiRecordsInfoEh, gsbiNavigator, gsbiFindEditorEh, gsbiSelAggregationInfoEh); TGridSBItemsEh = set of TGridSBItemEh;

Displaying the search for extra-panel runner is configured through the properties of the search bar Grid.SearchPanel.

Flexible adjustment of color and the presence of the border of the client area Grid.

DBGridEh allows you to customize the color and display side border (Border) of the client area Grid.

Sub-properties of property TDBGridEh.Border:

Property name	Property type	Description
Color	Boolean	Background color fringing.
Ctl3D	Boolean	Specifies that the line shall be drawn in 3D. Top and left border darker color. Bottom and right lighter.
EdgeBorders	TEdgeBorders	EdgeBorders property is set (set) that indicates which side of border drawn. A set can contain a combination of the following - ebLeft, ebTop, ebRight, ebBottom.
ExtendedDraw	Boolean	Use ExtendedDraw property to establish that border will be drawn through the inner grid instead by standard features of the functional Windows. Color properties and EdgeBorders are taken into account only when ExtendedDraw = True.
Style	TBorderStyle	Style edging. It can take values bsNone and bsSingle.

Group

Using TDBGridEh component

Links

Using TDBGridEh component

What do you think about this topic? Send feedback!