I am using Infragistics 7.1 on .Net 2.0. I have to create a webgrid (bound by strongly typed data set) to a table. In the second level of heirarchy I want to show records from same table as in first level having same value for an Id that is not part of primary key. So ID 1 can have 3 records (sub IDs - primary key - 1,2,3) of which 2 have Active column as false and 1 with active column as true. On the first level of heirarchy only the active row details are shown. And on the level 2 heirarchy of grid the in-active rows are shown. It is not necessary all IDs have more than 1 row. Active column is part of the same table.

 Can you please show me how to bind this relationship with grid.

 I can get the first level of hierarchy (pretty basic), but the second level is not showing up. I have created a strongly typed dataset and I am filling 2 tableadapters. Then I am setting relationship between the ID column and sub ID. But I am not able to see anything beyond first level. Nor do I see the expansion sign in the column on the grid on left of row selector column.

I need this soon.

Thanks!