how to populate different records in row of a Grid?

Helo, I hav开发者_C百科e a two Grid where I have to display some records from the table. The table consists of employee names ,manager names and their comments. Now on the first gird I am fetching data of employee names. Now on the second grid I have to display data of manager names and their comments. The data is on the same table. On show button of the first grid it shows all the employees. then on AdvWebGrid.ClickLink or any selected user on the first grid , i have to display the manager names and their comments on the second grid. How can I do that ? Hope my problem is clear?

---

can you use hirarchy grid?mean when you click on employee name it open a grid just below that row?i think it will be best option for you as you can use datatable in one datatable fetch all employee from table and assign them to first datatable and in other datatable fetch all manager and comments after doing all this just assign both datatable two grid datasource and create a join between them and it will work perfectly...

links

http://www.infragistics.com/dotnet/netadvantage/aspnet/web-hierarchical-data-grid.aspx#Overview

http://helpcentral.componentone.com/nethelp/c1webparts/default.htm?turl=WordDocuments%2Fdisplayingahierarchicalgrid1.htm

http://msdn.microsoft.com/en-us/library/ff407273(office.14).aspx

http://aspalliance.com/articleViewer.aspx?aId=21&pId=