Infralution Support

[shashi]

Hi,

I am using databinding to display the rows in the virtual tree.I want to filter the rows displayed for the virtual tree, hence i am applying filter to the datasource of the virtual tree,here the datasource is of type bindingsource.

After applying filter on the datasource variable of the virtual tree that is of type binding source,i called the methods resetbindings() on the datasource variable.

Virtual tree is not able to reload the filtered data.

Code structure :

taxMasterBindingSource.Filter = _filterString; //here vtTaxMaster.datasource=taxMasterBindingSource,_filterString is some valid filter string

taxMasterBindingSource.ResetBindings(false);

vtTaxMaster.UpdateRows(true);
vtTaxMaster.Update();


Can u suggest me some way out?

[Infralution]

The BindingSource.Filter property only works if you have set the BindingSource.DataSource to a DataView (not a DataSet or DataTable). The MSDN documenation says:

[shashi]

Thanks a lot ,the idea suggested by you is working.But as mentioned by you

Only underlying lists that implement the IBindingListView interface support filtering.

But BindingSource implements IBindingListView ,then y the filteration cannot be done directly on the BindingSource.

Please have a look on this.

[shashi]

Details:

MasterTable named as MTable
ChildTable named as CTable (linked to the MTable through a relation)

vtree1 has to show rows from MTable
vtree2 has to show rows from CTable(following to the parent relation)


Requirement for my desing was to have two virtual trees,where the first virtual trees shows all the rows from the MasterTable named as MTable and second virtual tree shows only the

rows that satisfiles the relation between the Master table and child table.

So, what i m doing is:

1.I have set the datasource for the first virtual tree to the dataset table MTable through a bindingsource,also as i dont want to show the child rows in the first virtual tree hence i have

removed the child property for the first virtual tree.

2.In the second virtual tree what i m doing is that i have set the datasource property to the Parent table,and as i only want to show the child rows ,i have deleted the cell bindings from

the databindings for the parent table.This step is only done to generate the appropriate databindings,when the databindigs are generated the datasource property for the second tree is

reset.

3.In the selection change event of the first tree i m setting the datasource property for the second tree by writing the code
virtualtree2.Datasource=Virtualtree1.selecteditem;



As the datasource for the first virtual tree is set to a datable the idea suggested by you is working fine for the virtual tree
that is if i m applying filter for for the datatable as
datatable.TableName.DefaultView.RowFilter = _filterString;

dsTaxPlan.MTable.DefaultView.RowFilter = _filterString;

but if i am doing the same for the second virtual tree filtering is not happening.

dsTaxPlan.CTable.DefaultView.RowFilter = _filterString;


Can u tell me a way out?

[Infralution]

When you set the Children property to a Relation in a DataRowRowBinding Virtual Tree Data uses the DataSet Relation to get the children for the parent row. To do this it uses the DataRowView.CreateChildView method. This means it is not using the DefaultView so setting the filter on the DefaultView won't filter the children. To do this you can handle the GetChildren event for the parent DataRowRowBinding (in your case for the MTable) and set the filter on the underlying Child DataView created by the binding. The sample code below demonstrates filtering the child orders for a customer in the sample Data Set Browser project: