Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - What is the point of Relations?

Reply
 
Old 04-24-2009   #1 (permalink)
RDA


 
 

What is the point of Relations?

So in VS 2008 I have created an XSD file with a master table and a
child table bound by a relation. I have bound the master table to a
datagridview. However, I have no clue how to access the child table
(yet have it relate to the master table via the relation).

So, in short, what is the point of Relations? How can I access them?
Common sense tells me it should be easy to create a "nested
datagridview" or something to display the child table within the
master datagridview, but this is not straightforward.

Please help!

My System SpecsSystem Spec
Old 04-24-2009   #2 (permalink)
Miro


 
 

Re: What is the point of Relations?

It does like an automatic filter for you when you use the controls on a form
for example.

Are you looking for an example on how to display a master - detail using a
relation?



"RDA" <roy.anderson@xxxxxx> wrote in message
news:38ec08dc-8ead-4ea1-a12e-418186cba61b@xxxxxx
Quote:

> So in VS 2008 I have created an XSD file with a master table and a
> child table bound by a relation. I have bound the master table to a
> datagridview. However, I have no clue how to access the child table
> (yet have it relate to the master table via the relation).
>
> So, in short, what is the point of Relations? How can I access them?
> Common sense tells me it should be easy to create a "nested
> datagridview" or something to display the child table within the
> master datagridview, but this is not straightforward.
>
> Please help!
My System SpecsSystem Spec
Old 04-24-2009   #3 (permalink)
RDA


 
 

Re: What is the point of Relations?

YES. Please.


On Apr 24, 3:33*pm, "Miro" <m...@xxxxxx> wrote:
Quote:

> It does like an automatic filter for you when you use the controls on a form
> for example.
>
> Are you looking for an example on how to display a master - detail using a
> relation?
My System SpecsSystem Spec
Old 04-24-2009   #4 (permalink)
Cor Ligthert[MVP]


 
 

Re: What is the point of Relations?

Hi,

There is much more about relations and datagridview on this website, just
one

http://www.vb-tips.com/DatagridViewFormatting.aspx

Cor


"RDA" <roy.anderson@xxxxxx> wrote in message
news:8f87927a-0928-4ee4-b389-e7d7a36e6e04@xxxxxx
YES. Please.


On Apr 24, 3:33 pm, "Miro" <m...@xxxxxx> wrote:
Quote:

> It does like an automatic filter for you when you use the controls on a
> form
> for example.
>
> Are you looking for an example on how to display a master - detail using a
> relation?
My System SpecsSystem Spec
Old 04-27-2009   #5 (permalink)
Miro


 
 

Re: What is the point of Relations?

Think about this scenario

Lets say you have a master file and a detail file.
2 datagrids on a form.

You select * from master and select * from detail

in this scenario, if you have a relation, and the datagrids are setup to
link through the relation, as you select one record in the master, the
detail filters to be the records linked to the master.

Setting up the relation with "cacading updates and deletes" also delets the
child records for you
(providing they are loaded into your dataset).



"RDA" <roy.anderson@xxxxxx> wrote in message
news:8f87927a-0928-4ee4-b389-e7d7a36e6e04@xxxxxx
YES. Please.


On Apr 24, 3:33 pm, "Miro" <m...@xxxxxx> wrote:
Quote:

> It does like an automatic filter for you when you use the controls on a
> form
> for example.
>
> Are you looking for an example on how to display a master - detail using a
> relation?
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
How to remove "Microsoft point to point adapter" ? Vista General
What the point of D&S? Vista General
What is the point? Vista General
what does a Restore Point actually do? Vista General
Restore point filling drive to point of no free space Vista performance & maintenance


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46