Re: SQL Relations vs. DataRelations?

From: Peter (Peter_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 10:33:30 -0700

William,

Thanks for the reply. I guess my question is if I setup a relationship
between two tables on the SQL Server side isn't it suppose to be reflected
iwhen I drop the two tables onto my form and then generate the Dataset - it
shows the two tables and all the field member so why leave out the
relationship?

Peter

"William (Bill) Vaughn" wrote:

> The relationships defined in a DataSet can be anything you choose--whether
> or not they're reflected in the relationships on the server DBMS. You have
> to define them yourself, however.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "Peter" <Peter@discussions.microsoft.com> wrote in message
> news:5BD10B9F-2986-4B96-8D70-10A0452816CA@microsoft.com...
> > Hello,
> >
> > Thanks for reviewing my question. I would like to know if I create a
> > relationship via the SQL server's diagram is that replicated in the
> > Dataset's
> > relations property? It seems not to to be the case because if you look at
> > the dataset via VS.NET editor, it only shows the two tables but no
> > relationships. If I create a relationship via SQL server and then I have
> > to
> > create a relationship the dataset, this would be redundant. Can you shed
> > some light on this?
> >
> > Many Thanks
> > Peter
>
>
>

Relevant Pages