programatic way to filter in grid control (databound and grid)

hi. i''m looking for a sample or description of how i can affect filtering on a grid programatically. what i have is a master data set from which i am building multiple grid views. i have a SQL like wizard that allows the user to customize the view at which point i will build the grid behind the scenes. user example: select col1, col2, col3 where col4 > 0 and col5 = ''ABC'' group by col1 here i want to instantiate a grouping grid hide/unhide certain columns, group by and filter programatically. thanks-

There is no grouping functionality n our GridDataBoundGrid. If you need grouping, you should use the GridGroupingControl. To group by a "State" column, use code like this.gridGroupingControl1.TableDescriptor.GroupedColumns.Add("State"); To see only certain columns, add only those columns to the Columns collections. this.gridGroupingControl1.TableDescriptor.Columns.Add("State"); this.gridGroupingControl1.TableDescriptor.Columns.Add("City"); To filter, use code like: this.gridGroupingControl1.TableDescriptor.RecordFilters.Add("City", FilterCompareOperator.Like, "B*");