Group Records and display in Tree Structure

[tmramach]

I have a 4 level grouping of Data Records stored in SQL Server 2005 and I would like to display them in a Data Grid where I can expand and collapse groups depending on my wish. The Account Head has 4 levels of grouping, and the data fields are Debit and Credit and some other data. I wish to see the totals when groups are collapsed and when expanded all the data should be displayed in the heirarchy in a treeview. Can someone help in guiding me through this. A sample project in Visual Studio 2008 would be highly appreciated.

 

[cjard]

sounds like you need a custom control something like a Tree GridView

Mark Rideout's Blog : Customizing the DataGridView to support expanding/collapsing (ala TreeGridView)