Create column on execute time in TcxGrid like tDbGrid in delphi

Question

I use TcxGrid But I cant create fields on execution time because I have a pivot query and columns are variable

Can I fill cxGrid like tDbGrid?

score 5 · Accepted Answer · answered Mar 23 '10 at 09:10

5

I solved the problem like this

grdCevapDBTableView2.BeginUpdate;
grdCevapDBTableView2.ClearItems;
fillGridView(grdCevapDBTableView2,command);
grdCevapDBTableView2.DataController.CreateAllItems;
grdCevapDBTableView2.EndUpdate;

answered Mar 23 '10 at 09:10

Rapunzo

966
5
21
42

Hey, can I ask where you get the fillGridView function from? I have the same problem, but this doesn't compile for me. – Mr Lister May 15 '13 at 11:01
Sorry I just saw your comment. it was a user defined function. so many years passed I forgot its form. but it was in a class and working with that two parameters. – Rapunzo Jan 21 '14 at 10:23
Thanks for our answer. I think I solved my problem last year though. – Mr Lister Jan 21 '14 at 10:27
actually clearItems and createallitems would have been enough. – user763539 Nov 08 '16 at 10:39

score 4 · Answer 2 · answered Mar 23 '10 at 07:44

4

I like to use the TcxGrid.DataController.CreateAllItems method which creates all columns that exists in the datasource. It takes a boolean parameter with which you can decide wether to add all columns or only those missing.

answered Mar 23 '10 at 07:44

johnny

657
7
18

score 1 · Answer 3 · answered Mar 22 '10 at 14:24

Try something like this:

function TForm1.AddIntegerColumn(const ACaption, AName: string): TcxGridColumn;
begin
  Result := TableView.CreateColumn;
  Result.DataBinding.ValueTypeClass := TcxIntegerValueType;
  Result.Caption := ACaption;
  Result.Name := AName;
end;

Create column on execute time in TcxGrid like tDbGrid in delphi

3 Answers3