Hiding Columns in NestedTables

Hi, I have a GridGroupingControl which I am using to display an Nth level nested DataSet. Once I have set the DataSource and DataMember properties of the Grid to the DataSet and Table[0].TableName, how can I hide all the Columns in all the nested tables that I don''t want displyed. My aim is to get the Grid to look as similar as possible to a TreeView type control with extra hidden data in each DataRow which I can access when the row is selected. Therefore I only want the "description" column to be visible to the user, and not all the other value columns.

Hi Jeremy, you would have to step into the RelationDescriptors and use the RelationDescriptor.ChildTableDescriptor to get access to the nested table schema. See following example: // main table descriptor GridTableDescriptor td = this.gridGroupingControl1.TableDescriptor; // nested table descriptor while (td.Relations.Count > 0) { GridTableDescriptor td = td.Relations[0].ChildTableDescriptor; // hide columns in nested table td.Columns.Clear(); td.Columns.Add("Description"); } Stefan

Thx Stefan that is just the job... ;-) >Hi Jeremy, > >you would have to step into the RelationDescriptors and use the RelationDescriptor.ChildTableDescriptor to get access to the nested table schema. > >See following example: > > > > // main table descriptor > GridTableDescriptor td = this.gridGroupingControl1.TableDescriptor; > > // nested table descriptor > while (td.Relations.Count > 0) > { > GridTableDescriptor td = td.Relations[0].ChildTableDescriptor; > > // hide columns in nested table > td.Columns.Clear(); > td.Columns.Add("Description"); > } > > > >Stefan >