FilterDescriptor With RadTreeView WinForms

Thanks Dinko - very helpful. After understanding this multi threaded issue, I have changed the logic of the thread that changes the datasets.

I have been using a method to receive sql notifications form SQL server using service broker and triggers. When those notifications come in, I now enqueue these messages onto a queue using an external thread as they happen.

Because a timer appears to process on the UI thread, I now poll those enqueued messages and push those changes to the dataset. This appears to work really well for insert/update/delete from SQL server. 

The final step was to reset bindings on the tree view once data is pushed through using some code to ensure that the hierarchy persists. 

So now my application is able to react to changes in the SQL server database from other users. Very happy with the result.

Thanks again Dinko for your responses. They were really helpful. I think we can close this one off now.

Hi James,

Thank you for the provided details.

You can try using RadTreeView Custom Filtering which is a flexible mechanism for filtering RadTreeView nodes by using custom logic. It has a higher priority than the applied FilterDescriptors. The nodes come one by one in the FilterNode() predicate in which you can determine whether to be visible or not depending on your logic. It is important to note that when a child node matches the filter criteria, it has to be marked as visible, as well as all of its parent nodes up to the top. This means that when a node is passed to the filter predicate you have to traverse its Nodes collection down to the bottom recursively and check whether at least one child node matches the filter. If such a child node exists, the parent node that is currently being passed to the filter predicate has to be marked as visible. 

I hope that this approach will work for you.

Regards,
Dinko | Tech Support Engineer
Progress Telerik

Hi Dinko,

Thank you very much for your input. I have got around the issue by using LINQ to provide the filter (in my case using where DeletionStatus is false).

      this.clientBindingSource.DataSource = (from DS in this.crmDataSet.Client
                                             orderby DS.FullName
                                             where ((!DS.DeletionStatus) && (DS.RowState != DataRowState.Deleted))
                                             select DS).AsDataView();

This loads the RadTreeView with the right filter (note this has been simplified to highlight the issue I have).

I use a tree view called tvProjectClient and set this up as below:

      this.tvProjectClient.DataSource = clientBindingSource;
      this.tvProjectClient.ValueMember = "ClientID";
      this.tvProjectClient.DisplayMember = "FullName";
      this.tvProjectClient.RadContextMenu = this.rcmClient;

Now I have an issue when changing DeletionStatus in the client dataset. I change the dataset by changing DeletionStatus to true for a particular client. Then I use the following to reset bindings.

clientBindingSource.ResetBindings(false);

This may work for one or two changes but then it will not bind correctly. All of a sudden, the arrows do not work to expand/collapse as well.

Interesting enough when I add projects to the RadTreeView (see below), changing the DeletionStatus has the desired effect and appears/disappears as I change DeletionStatus multiple times.

      RelationBinding projRelation = new RelationBinding(this.ProjectBindingSource, "Name", "ClientId", "ClientId", "ProjectId");
      projRelation.RelationName = "Project";

      this.tvProjectClient.RelationBindings.Add(projRelation);

I have tried all sorts of methods but there either appears to be a bug or I am simply not setting this up correctly. As I have stated, using relation binding for project seems to work as expected. If I change the datasource to project instead of client, the behaviour persists. I would really appreciate your input on this.

I must note I am very impressed how the data binding just works in general which is wonderful. However, I have this particular issue that is stumbling me a little.

Thanks, James