wstevens
Member
Hi all
I am trying to do the following, I have 2 table with one to many relationship via a index.
I would like to populate a datagridview with the records from the first table and add the records with the same Index from the second table but not as rows but as columns
so to sum it up
Table 1
PID | Name
0 | John
Table 2
BID | PID | TelephoneType | TelephoneNo
1 | 0 | Home | 000 000 0000
2 | 0 | Office | 111 111 1111
DataGridview
PID | Name | Home | Office
0 | John | 000 000 0000 | 111 111 1111
This is how I want my datagridview in my application to look like. Im using VS 2005 Pro Edition. Is this possible keeping into consideration that I need to be able to cascade updates from either records back to there individual tables.
Thank you for your help in advance
I am trying to do the following, I have 2 table with one to many relationship via a index.
I would like to populate a datagridview with the records from the first table and add the records with the same Index from the second table but not as rows but as columns
so to sum it up
Table 1
PID | Name
0 | John
Table 2
BID | PID | TelephoneType | TelephoneNo
1 | 0 | Home | 000 000 0000
2 | 0 | Office | 111 111 1111
DataGridview
PID | Name | Home | Office
0 | John | 000 000 0000 | 111 111 1111
This is how I want my datagridview in my application to look like. Im using VS 2005 Pro Edition. Is this possible keeping into consideration that I need to be able to cascade updates from either records back to there individual tables.
Thank you for your help in advance