Lazarus

Programming => Databases => Topic started by: majid.ebru on December 31, 2018, 08:27:11 am

Title: How can i hide some rows in dbgrid?
Post by: majid.ebru on December 31, 2018, 08:27:11 am: Hi

I have a dbgrid,how can i hide some rows in dbgrid?!
Title: Re: How can i hide some rows in dbgrid?
Post by: mangakissa on December 31, 2018, 08:48:49 am: use the filter of your dataset.
Title: Re: How can i hide some rows in dbgrid?
Post by: dsiders on December 31, 2018, 01:44:56 pm: Quote from: mangakissa on December 31, 2018, 08:48:49 am
use the filter of your dataset.

Or, if it is SQL-based, by adding a WHERE clause to its SQL select statement.
Title: Re: How can i hide some rows in dbgrid?
Post by: majid.ebru on January 01, 2019, 04:55:22 am: Quote from: mangakissa on December 31, 2018, 08:48:49 am
use the filter of your dataset.

How?
Can you explain?
Title: Re: How can i hide some rows in dbgrid?
Post by: Handoko on January 01, 2019, 08:30:26 am: https://www.freepascal.org/docs-html/fcl/db/tdataset.filter.html
https://www.w3schools.com/SQl/sql_where.asp
Title: Re: How can i hide some rows in dbgrid?
Post by: Robert.Thompson on January 02, 2019, 09:32:01 pm: Newbie here so, beware.

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

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

Rob.
Title: Re: How can i hide some rows in dbgrid?
Post by: mangakissa on January 03, 2019, 08:11:08 am: A column is not a row
Title: Re: How can i hide some rows in dbgrid?
Post by: Robert.Thompson on January 03, 2019, 06:27:59 pm: "A column is not a row"

Yep, my mistake. :-[