Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie123
Starting Member
15 Posts |
 Posted - 2008-07-24 : 14:16:42
|
| I'm programming in vb.net using visual studio 2008. I have one table that represents all patient IDs and financial information and another table that represents all patient IDs and patient information. I would like to (in a datagridview) be able to display the patient's name, which is located in the patient information table, and join it so that the financial information table will show the patients names as well as the patients financial information. I know this is a simple join, but, where would I put this so that it would show up in the datagridview? Ideally, I would like the datagridview to display all of the columns in the financial table (which it already does, that's the dgv's datasoruce) and relate the patient number to the patient name (which is stored in the patient information table) and have the patients name display right next to all of the other information in the dgv..how would i go about doing this? |
|
|
jamie123
Starting Member
15 Posts |
Posted - 2008-07-24 : 15:24:47
|
| actually, what i really wanna do is be able to define the relationship in the dataset, since both tables are located in the dataset (already did this)..and I want to know how to access and extract data from the newly created relation.Thanks! |
 |
|
|
|
|
|
combining datasources in a dgv