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.
Unfortunately, activation email could not send to your email. Please try again.

Filter Hierarchical GridDataBoundGrid

Thread ID:





40578 Feb 7,2006 09:50 AM Feb 9,2006 09:29 AM Windows Forms 3
Tags: GridControl
Administrator [Syncfusion]
Asked On February 7, 2006 09:50 AM

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 10:41 AM

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 07:45 AM

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 09:29 AM

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.

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.