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

[Randy Furtado]

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-

[Administrator]

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*");