We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filter Hierarchical GridDataBoundGrid

Thread ID:





40578 Feb 7,2006 02:50 PM UTC Feb 9,2006 02:29 PM UTC WinForms 3
Tags: GridControl
Administrator [Syncfusion]
Asked On February 7, 2006 02:50 PM UTC

Is it possible to filter 2-level GDBG after data has been loaded? I use dataset with two tables as DataSource. Then I would like to filter data on both levels when user checks/unchecks checkbox "Hide not active" or "Hide not completed", etc. I tried DefaultView.RowFilter and DataViewManager but with no success.

Administrator [Syncfusion]
Replied On February 7, 2006 03:41 PM UTC

My code: dataset.Tables["Table0"].DefaultView.RowFilter = filterCreteria1; dataset.Tables["Table1"].DefaultView.RowFilter = filterCreteria2; grid.DataSource = dataset; How can I make grid to be filtered?

Administrator [Syncfusion]
Replied On February 8, 2006 12:45 PM UTC

Hi Olga, The DataViewManager can be used to filter the child table and after setting the RowFilter reset the DataBinding of the grid. And the currencyManager.List can be used as the DataView to filter the root level table. Here is a sample. Regards, Calvin.


Administrator [Syncfusion]
Replied On February 9, 2006 02:29 PM UTC

Calvin, Thank you for the sample. I''ve already resolved this problem by similar way: dvm = new DataViewManager(dataSet); dvm.DataViewSettings[tableName1].RowFilter = filterString1; dvm.DataViewSettings[tableName2].RowFilter = filterString2; grid.DataSource = dvm; It also works!


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon