Hi.
I am currently facing a problem which isnt direclty related to telerik, but i still hope to get some advice.
I have found like hundreds of internet posts about building 1 grid with a related dataset, so that childs get displayed in the same grid.
But, i am currently trying to achieve the same stuff with 2 DataGrids with a DataSet that has a many-to-many relation.
So in thirst Grid i want to have my "Parent Elements", when i select a specific row i get in my second grid all the related elements of the selected grid.
There is the first Problem because i only found the GetChildRows method of the DataRow and this will give me the "Middle Table" (so the Table that makes a many-to-many Relation possible). What i am currently making is stepping threw those ChildRows and fetching the acutal Rows of the Third Table. I dont really believe thats the way it should be done, so please tell me how to get the actual related stuff.
Second is there a way to automatically insert/update the "Middle Table", my adapters do have the commands attached to it. But since i am losing the stuff in my first step, the object relation is gone. I am currently force to update it manually.
So hope you guys can help me out.
I am currently facing a problem which isnt direclty related to telerik, but i still hope to get some advice.
I have found like hundreds of internet posts about building 1 grid with a related dataset, so that childs get displayed in the same grid.
But, i am currently trying to achieve the same stuff with 2 DataGrids with a DataSet that has a many-to-many relation.
So in thirst Grid i want to have my "Parent Elements", when i select a specific row i get in my second grid all the related elements of the selected grid.
There is the first Problem because i only found the GetChildRows method of the DataRow and this will give me the "Middle Table" (so the Table that makes a many-to-many Relation possible). What i am currently making is stepping threw those ChildRows and fetching the acutal Rows of the Third Table. I dont really believe thats the way it should be done, so please tell me how to get the actual related stuff.
Second is there a way to automatically insert/update the "Middle Table", my adapters do have the commands attached to it. But since i am losing the stuff in my first step, the object relation is gone. I am currently force to update it manually.
So hope you guys can help me out.