FilterRow not working

[Sat Sandhu]

Hi,

I have a GridGroupingControl that is bound to a DataSet. The dataset has two tables in it, tableA and tableB (the child).

I do:
tableA.DefaultView.RowFilter = "[column1] LIKE 'a*'";
gridControl.Refresh();

Nothing happens - grid still shows rows where column1 value does not start with "a"

Any idea?
Ta
Sat

[Administrator]

Hi Sat,

Use the TableDescriptor.RecordFilter property to manages the rowfilter in a grid. Here is a code snippet

//For maintable...
//Addthe filter...
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add("[parentID] = 1");
//Remove the filter..
this.gridGroupingControl1.TableDescriptor.RecordFilters.Remove("parentID");

//For any table...
//Addthe filter...
this.gridGroupingControl1.GetTableDescriptor(""TableName"").RecordFilters.Add("[parentID] = 1");
//Remove the filter..
this.gridGroupingControl1.GetTableDescriptor("TableName").RecordFilters.Remove("parentID");

Best Regards,
Haneef