TDBGridControler

TDBGridControler is a non visual component with no dependencies providing added functionalities for the TDBGrid object

Package download link : https://gitlab.com/lazaruscomponent/dbgridcontroler

TDBGridControler component

You need more functionalities? A grid controller that provide extra features to your existing TDBGrid

• Searching expression in the grid;
• Searching expression in column;
• Column filter editor;
• Datetime editor, memo editor and lookup editor;
• Saving the current filter view;
• Multi column sorting;
• Column chooser editor;
• Column grouping visual separator on one level;
• Footer and aggregation on columns;

TDBGrid Overidden Events to achive the task

• OnCellDraw
• OnCellHint
• OnEditorEdit
• OnMouseClick
• OnTitleClick
• OnTitleDraw

TDBGridControler events

OnAfterFilterGrid	After filter execution
OnAfterSortColumn	After a column is sorted
OnAggregation	Define which column is showing an aggregation
OnBeforeSortColumn	Before a column is sorted
OnLocalize	Use to translate string resources
OnPrepareLookupDataset	Use to prepare the lookup dataset
OnSortColumn	Custom sort event, could be use to change order by statement in the SQL query

Localization example

Screen shots