Datagrid, binding and rowfilter

[sawpit]

Hello,

I have three DataTables linked hierarchically (parent-child-grandchild) and
bound to three data grids as follows:

dsConeSys = ConeSysDataSet. GetTallyDataSet (studyID, assessmentID);

bsTree.DataSour ce = dsConeSys;
bsTree.DataMemb er = "Tree";
dgvTree.DataSou rce = bsTree;
bnTree.BindingS ource = bsTree;

bsBranch.DataSo urce = bsTree;
bsBranch.DataMe mber = "TreeBranch "; // TreeBranch is a relation
dgvBranch.DataS ource = bsBranch;
bnBranch.Bindin gSource = bsBranch;

bsTally.DataSou rce = bsBranch;
bsTally.DataMem ber = "BranchTall y"; // BranchTally is a relation
dgvTally.DataSo urce = bsTally;
bnTally.Binding Source = bsTally;

where, the Tree-Branch-Tally DataTables represent the
parent-child-grandchild, bs* are binding sources, bn* are binding
navigators, dgv* are data grid views.

This all works fine, with the data in the three grids being nicely
synchronized. However, I want to be able to implement a RowFilter on the
Tally DataTable so only a subset of rows are displayed in the Tally grid. I
tried setting the RowFilter property on the Tally.DefaultVi ew,

dsConeSys.Tally .DefaultView.Ro wFilter = "AssessmentID=0 ";

but that didn't work. Any ideas would be much appreciated. Thanks in
advance.