Counting the rows in a TDbGrid

Question

I have a TDbGrid, and I can easily tell how many columns are in it at runtime with the FieldCount property, but there doesn't seem to be a corresponding RowCount property to display how many records are being displayed. How can I find this out?

score 14 · Answer 1 · edited Sep 14 '12 at 08:06

14

Both RowCount and VisibleRowCount are protected properties in TCustomGrid that are not exposed in TDBGrid. But you can get round that doing the following:

type
  TDummyGrid = class(TDBGrid);

  RowCount := TDummyGrid(MyDBGrid).RowCount;
  VisibleRowCount := TDummyGrid(MyDBGrid).VisibleRowCount;

Be warned that this includes the header.

edited Sep 14 '12 at 08:06

bluish

26,356
27
122
180

answered Nov 16 '08 at 20:47

Steve

6,382
3
41
66

score 9 · Accepted Answer · answered Nov 16 '08 at 20:24

9

You could try:

DBGrid1.DataSource.DataSet.RecordCount

Maybe there are better solutions. But this worked for me.

answered Nov 16 '08 at 20:24

Toon Krijthe

52,876
38
145
202

4

TDataSet.RecordCount will often give -1 depending on the situation (like queries). – Lars Truijens Nov 16 '08 at 21:55
Thanks, it looks like I have to do some db programming, else I'm losing the touch. (Two years working on a DB less app). – Toon Krijthe Nov 16 '08 at 22:10
Indeed, Lars? So much time using TClientDataset, I didn't remember that. What kind of Query objects (ADO, IBX or DBX) show this behavior? I believe dbx would, because it's components are unidirectional cursors - but there are more? – Fabricio Araujo Nov 17 '08 at 17:56

score 1 · Answer 3 · edited Sep 14 '12 at 08:07

1

I would use

TDbGrid.ApproxCount

edited Sep 14 '12 at 08:07

bluish

26,356
27
122
180

answered Jul 01 '10 at 07:59

hassen

11
1

Counting the rows in a TDbGrid

3 Answers3

Linked