Filtering a DataTable

[NickSwift]

I have a dataset with 3 data tables and two relationships.
I set a rowfilter on the first data table (via the "DefaultView" property, with RowStateFilter set to "CurrentRows). This filter works correctly (checked by row counts of datatable).

However, as soon as I assign this to the datasource of a control (in my example, a DataGrid), the filter is lost, giving me the full record set.

Has anyone any ideas on solving this theorectically simple issue!???

Thanks
Nick.

 

[NickSwift]

Solved myself, may be useful information for anyone out there.

When assigning a filter to a dataset table/view, this must be done after the datatable has been attached to a datasource for a displaying control (such as a grid).