Delphi & C++ Builder components library
and Software development
 
 
 

rDBGrid - Powerfull DBGrid with column grouping, sorting, filtering and new editors

rDBGrid is impressive DBGrid component with many improvements, new look, functions and events.
It is derived from DBGrid and can simply replace standard DBGrid without loosing current column settings and with no code modification (unlike other complicated and not compatible components).
All new properties can be set very easily by design time editor so developer can use it immediately without long learning.

rDBGrid works with any dataset and database type (ADO, DBX, FireDAC, UniDac...), sorting is provided by Sorter component (see detail help).

Looks:

  • column grouping definable in design or run time by end user
  • definable title row height and data rows height
  • glyphs in title row, multiple line title row with automatic word wrapping and rotated text new
  • sort markers in title row including multi column sorting
  • funnel filter glyphs in title row like in MS Excel and dialog for selecting of filtered values with possibility to enter range or date period, show filtered records with selectable font color
  • whole active row can be colored and with focus rectangle, odd rows can have different color
  • new record indicators, definable width and content of fixed column including checkbox for record selection
  • hint window with complete text for truncated cell text or memo field and with image content for graphics field (by using my rHTMLHint component)
  • new one-click selectable grid look style and glyps style for memo and graphics fields, developer can define new own styles by definition in RosiComp\RosiCompGlobalCfg.pas unit
  • new component rCustomGlyphs with possibility to define all custom glyphs for rDBGrid, rStringGridEd and rDBRecordView new

Editors and special field content:

  • show check boxes for boolean fields or any other field with definable TRUE/FALSE values
  • show content or glyphs for memo fields and graphics fields
  • show text as hyperlink and can handle click on it (http://, mailto:// or user defined links)
  • can show graphic symbols in cell according field value
  • DateTimePicker and ColorPicker for defined fields
  • build-in editor for memo fields and long string fields
  • build-in browser for graphics fields with BMP, JPG and PNG support
  • enhanced picklist and lookup combobox with definable item height, content and custom drawing new

Events and new functions:

  • automatic changing of columns width after resizing of grid or after dblclick on boundary of title cell (autofit)
  • title row context menu with calculation of SUM, MIN, MAX, AVG, COUNT values for selected column
  • supports linked summary DBGrid with user defined content
  • supports copying data to Excel and pasting from Excel as new records or to update existing records
  • introduces events for change sorting and click on title cells or fixed column cell
  • introduces Sorter component to provide sorting for different data types (ADO, DBX, ClientDataset, FireDac, Zeos, UniDAC, SDAC) - see detail help updated
  • introduces events for getting cell properties (font, background), for drawing on title row or active row and for custom drawing of DropDown list items
  • introduces event for custom hint on any cell
  • provides drag and drop support
  • and many more...

Examples of rDBGrid:

Group columns with definable colors and column moving:
dbgrid_groups

Auto filter like in Excel:
dbgrid_filter_button
with possibility to enter range or date period:
dbgrid_filtercond1 dbgrid_filtercond2
Memo and graphics content directly in Grid with increased row height:
dbgrid_memo_graphic

Date picker and Color picker:
dbgrid_datepicker             dbgrid_colorpicker

Footer row with automatic calculation, many formating properties and events:
dbgrid_footerrow

Summary popup in title row and summary linked grid at bottom:
dbgrid_summary

Using graphics in cells:
dbgrid_dataimages

Multiselect grid with checkboxes in fixed column (see DBGrid MS):
dbgrid_multiselect

Selectable one-click look style in design time or by user in runtime due to prepared dialogs (see DB Dialogs & Actions):
dbgrid_blue1 dbgrid_blue2 dbgrid_olive
dbgrid_brown dbgrid_green dbgrid_yellow

New design time editor (install package RosiComp2010_DT.dpk and double click to any rDBGrid):
dbgrid_dteditor

See more examples in video:
video Column grouping - usage, video Column grouping - design, video Fixed column
video Auto Filter like in Excel, video Memo ang Graphics field content, video Memo, Graphics, Bool Editors

Open documentation page.

Go back