Difference between revisions of "TDBGridControler"

From Lazarus wiki
Jump to navigationJump to search
(Five changed the content model of the page TDBGridControler from "JavaScript" to "wikitext")
Tag: content model change
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
== TDBGridControler is a non visual component with no dependencies providing added functionalities for the TDBGrid object==
+
== See also ==
  
 
+
* [[TDBGridController]]
 
 
Package download link : https://gitlab.com/lazaruscomponent/dbgridcontroler
 
 
 
 
 
[[File:TdxDBGridControler_200.png|32px||Left|]] 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
 
 
 
 
 
 
 
{| class="wikitable"
 
|+ DBGridControler 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
 
 
 
 
 
[[File:TdxDBGridControler_Properties.png]]
 

Latest revision as of 15:50, 30 December 2022