BindingSource and Filter

[Eli Gazit]

Their seems to be a problem with the filter bar when working with bindingsource.
in the following code:
private void Form1_Load(object sender, EventArgs e)
{
this.childsTblTableAdapter.Fill(this.amitDataSet.ChildsTbl);
this.gridDataBoundGrid1.BeginUpdate();
currentTableName = "ChildsTbl";
// Bind the data using one of the methods:
if (BindWithBindingSource)
{
this.gridDataBoundGrid1.DataSource =
this.childsTblBindingSource;
}
else
{
this.gridDataBoundGrid1.DataSource =
amitDataSet.Tables[currentTableName];
}
//create the filter bar and display it
theFilterBar = new GridFilterBar();
theFilterBar.WireGrid(this.gridDataBoundGrid1);

this.gridDataBoundGrid1.EndUpdate();
}

when using the BindingSource to bind the data, the filter is missing.

[Administrator]

Hi Eli,

There has been no change in respect to the filtering on an arbitrary IBindingList/Collection(bindingSource). We still don''t support it.

As far as implementing the UI, there is not much difference between setting things up for a DataTable and a IBindingList. The problem is, once you have the desired filter requirements, how do you apply them to an arbitrary IBindingList object. In a DataTable, it is done through the DataTable.DefaultView.RowFilter property. This does all the work, all you have to do is set it. For arbitrary IBindingList, you would have to somehow do this same type of thing, ie. prepare a 2nd list that only holds items from the first list that satisfy the filter, and then set this as the grid''s datasource. The DataTable uses DefaulView to play teh role of this second list. So, in your filterbar, you could have to maintain a defaultview list for your IBindingList.

Also, minimally, I think your IBindingList would have to support IBindingList.Find and maybe IBindingList.Sort to have all the pieces come together. You need to use GridGroupingControl if you need this feature.

C:\program files\syncfusion\essential studio\3.2.1.0\Windows\Grid.Windows\samples\Grouping\FilterBar

Please let me know if you need any futher assistance.

Thanks for choosing Syncfusion Products.
Regards,
Haneef

[Hussain Almusaad]

We're using the Syncfusion GridDataBoundGrid with a BindingSource and would like to use the GridFilterBar. Have you started supporting this combination yet ?

Note that BindingSource has a Filter property. Can this be linked to the GridFilterBar ?

Otherwise does syncfusion have code to expose a BindingSource as a DataTable ?

Kind regards,
Hussain

[Jisha Joy]

Hi Hussain,

We still don't support it. We highly recommed you to use GridHroupingControl if you need this feature. It is our most complete featured bound grid. And as such, should be considered first for any application where you want a grid to display data in a external datasource.

Regards,

Jisha