Good data grid for VCL and FMX

[MartinPe 0]

Hello,

 

Any good data grid that works with dataset that can soft and filter directly from the grid?

 

Thanks.

[Serge_G 87]

Hi,

perhaps TMSFNCGrid

[aehimself 396]

SMComponents does that and their grid comes with many other interesting features while being as simple as possible. It's even free...!

I almost ended up replacing my own DBGrid descendant with these when I had enough of tinkering around trying to fix it's issues 🙂

[Brian Evans 108]

There are a fair number of Delphi grids still in active development. One is Developer Express :  VCL Data Grid. It is expensive but has a lot of features and is the one I use. It has a provider mode where it basically handles querying the database for you when doing sorting / filtering in the grid itself which works much better on larger datasets than the more common pull all data locally (which it also supports). It has a bit of learning curve but once figured out you get a lot functionality with little or no code. 

 

VCL DataGrid - High Performance Grid for Delphi & C++Builder (devexpress.com)

 

Read question too fast. It does not support FMX. They tested the water with FMX but seems there was not enough demand from their current customers to make it viable. 

Edited June 28, 2023 by Brian Evans

[MartinPe 0]

17 hours ago, Serge_G said:

Hi,

perhaps TMSFNCGrid

It does not support sort / filtering with a dataset.

[Fr0sT.Brutal 900]

I use EhLib

[Uwe Raabe 2059]

7 minutes ago, Fr0sT.Brutal said:

I use EhLib

For FMX?

[Fr0sT.Brutal 900]

56 minutes ago, Uwe Raabe said:

For FMX?

Ah, sorry, didn't notice FMX requirement.

[Bob Devine 11]

On 6/28/2023 at 11:36 PM, MartinPe said:

It does not support sort / filtering with a dataset

One of my favourite features of the FNCGrid is it's virtual mode, which is actually the only mode I use. Allows you to manipulate the underlying data in any way you want and then just update the view. Also means that large datasets aren't a problem.

[MartinPe 0]

On 6/30/2023 at 5:48 AM, Bob Devine said:

One of my favourite features of the FNCGrid is it's virtual mode, which is actually the only mode I use. Allows you to manipulate the underlying data in any way you want and then just update the view. Also means that large datasets aren't a problem.

Thanks for the tip. 

[Attila Kovacs 629]

On 6/29/2023 at 5:53 PM, Uwe Raabe said:

For FMX?

Is there a component that supports both at the same time?

[Uwe Raabe 2059]

5 minutes ago, Attila Kovacs said:

Is there a component that supports both at the same time?

As already mentioned, TMS FNC Grid, but also TeeGrid from Steema.

 

Technically these are not strictly the same component, because it must be derived from either a VCL or FMX TControl, but for the developer it comes quite near.

[Attila Kovacs 629]

I see, that means, the answer is "no".  thx

[Pieter 0]

On 7/7/2023 at 10:12 PM, Attila Kovacs said:

I see, that means, the answer is "no".  thx

We just released a BETA for our next gen data-grid which has filtering / sorting capabilities in combination with a dataset.

 

https://www.tmssoftware.com/site/blog.asp?post=1244

[Tapper 0]

TeeGrid from Steema, it's really good and quite cheap.

 

https://www.steema.com/product/gridvcl