Set Filter in GGC and GDBG

[Prof DISSOU Jamâl-Dine]

Hi,

1. How to set filter in GGC

2. How to set filter in GDBG

3. I have 2 GGC on a form, say (MasterGrid and DetailGrid), and I would like to bind the grids in master-details relationship. How to ?

Best regards,

Jamâl-Dine DISSOU

[Martin Cyr]

Perhaps you should check in the Sample Browser, there are lots of samples describing this in detail. Take a look at the DataBound -> GDBGCombo sample, it''s a nice start.

[Administrator]

1) You use the
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add method.

//samples
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add("[UnitPrice] > 20");
this.groupingGrid1.Engine.TableDescriptor.RecordFilters.Add("Country", FilterCompareOperator.Like, "U*");

2) You set the RowFilter property on the DataView associated with the grid.

CurrencyManager cm = (CurrencyManager) grid.BindingContext[grid.DataSource, grid.DataMember];
DataView dv = (DataView) cm.List;
dv.RowFilter = "[Col1] LIKE ''a*''";

3)See this sample.
\Syncfusion\Essential Studio\3.2.1.0\Windows\Grid.Windows\Samples\Grouping\MasterDetailForm