Displaying data in two grids from three tables
-
Dear All, I have two grids g1 and g2 and three tables t1,t2,t3. Basically there are only two tables t1 & t3 which have many to many relationship between them for which i have created t2. I want to show the data of t1 in g1 and data of t3 in g2 based on selected row of g1. Can any body tell me how can i do this? Currently i have created two relationships dr1 (between t1 & t2) and dr2 (between t2 & t3) and have databinding like this: g1.DataSource=t1; g2.DataSource=t1; g2.DataMember="dr1.dr2"; This scheme shows the data in g2 but not all the relevant rows in g2 are displayed. Instead just a single row against one row in g1 is displayed. Kindly give me some guidance in this regard. Regards, Wasif Ehsan.
-
Dear All, I have two grids g1 and g2 and three tables t1,t2,t3. Basically there are only two tables t1 & t3 which have many to many relationship between them for which i have created t2. I want to show the data of t1 in g1 and data of t3 in g2 based on selected row of g1. Can any body tell me how can i do this? Currently i have created two relationships dr1 (between t1 & t2) and dr2 (between t2 & t3) and have databinding like this: g1.DataSource=t1; g2.DataSource=t1; g2.DataMember="dr1.dr2"; This scheme shows the data in g2 but not all the relevant rows in g2 are displayed. Instead just a single row against one row in g1 is displayed. Kindly give me some guidance in this regard. Regards, Wasif Ehsan.
I'd go the easy way out & create two datasets that collect the information I want to display & bind the grids to them.
I think I'm going to call my next project "Chuck Norris". It's a sure way to guarantee it's unbreakable.
• • •
But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson