You are trying to build drill thru functionality from what i can see. You
are taking an unnecessary complex route. One approach which works well is to
have a details button along with each row displayed in the grid. Clicking
details on this button means you want details for that particular row, so
you grab the relevant row data, build a query with a whereclause based on
the selected row and go grab that specific data to display in the datagrid.
The new datagrid also contains a details button. In that way, you can drill
infinitely without having to keep track of anything, all you need is the
selected row to build your where clause part of the query. Make sense?
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...