load child and parent in seperate grids

[keko2004]

how can i load just the parent in 1 datagrid and as the user clicks on the data inside the grid to have it load the childs into a seperate grid? any help would be appreciated.

 

[cjard]

put an onclick handler so that when the parent gris is clicked, the reference for the child row is obtained and used to fill whatever dataset the child is bound to, with the child ref

this link also deals with methods for getting parent and child rows if you have told your dataset how the tables are related:
http://msdn2.microsoft.com/en-US/library/fxsa23t6(VS.80).aspx (many walkthroughs)