How can i hide some rows in dbgrid?
lazarus / 16-Databases

----------------------------------------------------------------------
majid.ebru · 2018-12-31 07:27

Hi

I have a dbgrid,how can i hide some rows in dbgrid?!

----------------------------------------------------------------------
mangakissa · 2018-12-31 07:48

use the filter of your dataset.

----------------------------------------------------------------------
dsiders · 2018-12-31 12:44

Quote from: mangakissa on December 31, 2018, 08:48:49 amuse the filter
of your dataset.

Or, if it is SQL-based, by adding a WHERE clause to its SQL select
statement.

----------------------------------------------------------------------
majid.ebru · 2019-01-01 03:55

Quote from: mangakissa on December 31, 2018, 08:48:49 amuse the filter
of your dataset.

How?
Can you explain?

----------------------------------------------------------------------
Handoko · 2019-01-01 07:30

https://www.freepascal.org/docs-html/fcl/db/tdataset.filter.html
https://www.w3schools.com/SQl/sql_where.asp

----------------------------------------------------------------------
Robert.Thompson · 2019-01-02 20:32

Newbie here so, beware.

DBGrid1.Columns[N].Visible:=false;


where N = column number with the first being 0 (zero), I think.

Rob.

----------------------------------------------------------------------
mangakissa · 2019-01-03 07:11

A column  is not a row

----------------------------------------------------------------------
Robert.Thompson · 2019-01-03 17:27

"A column  is not a row"

Yep, my mistake.