using typed dataset with data relations?

Hi,

I'm working with the dataset designer, which, via its wizard can generate 
both a fill method and one to return a datatable. So I can use these to get a 
specific datatable back, but I can't traverse a relationship, because the 
other table doesn't exist! So I assume I need to maybe manually declare an 
instance of the typed dataset, but then how do I fill it? Can I use one of 
the methods generated for me? Are the relations I "designed" implicitly in 
place? Examples I see show using an SQLDataAdapter, but I'd rather not 
recreate the sql when it's been created for me. Any thoughts? Examples?

Thanks for any help...

-Ben

Date:Wed, 8 Aug 2007 11:56:00 -0700 Author:

Re: using typed dataset with data relations?

I'm not sure this is your issue, but did you see www.developer.com? It 
features a new article that discusses this issue (I think).

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"benji"  wrote in message 
news:D3612466-30F7-44AA-A08A-A70B69D8DCA3@microsoft.com...

> Hi,
>
> I'm working with the dataset designer, which, via its wizard can generate
> both a fill method and one to return a datatable. So I can use these to 
> get a
> specific datatable back, but I can't traverse a relationship, because the
> other table doesn't exist! So I assume I need to maybe manually declare an
> instance of the typed dataset, but then how do I fill it? Can I use one of
> the methods generated for me? Are the relations I "designed" implicitly in
> place? Examples I see show using an SQLDataAdapter, but I'd rather not
> recreate the sql when it's been created for me. Any thoughts? Examples?
>
> Thanks for any help...
>
> -Ben

Date:Wed, 8 Aug 2007 15:16:36 -0700 Author:

Re: using typed dataset with data relations?

Hi Bill,

Could you include a link or article title?

-Ben

"William Vaughn" wrote:


> I'm not sure this is your issue, but did you see www.developer.com? It 
> features a new article that discusses this issue (I think).
> 
> -- 
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
> 
> "benji"  wrote in message 
> news:D3612466-30F7-44AA-A08A-A70B69D8DCA3@microsoft.com...
> > Hi,
> >
> > I'm working with the dataset designer, which, via its wizard can generate
> > both a fill method and one to return a datatable. So I can use these to 
> > get a
> > specific datatable back, but I can't traverse a relationship, because the
> > other table doesn't exist! So I assume I need to maybe manually declare an
> > instance of the typed dataset, but then how do I fill it? Can I use one of
> > the methods generated for me? Are the relations I "designed" implicitly in
> > place? Examples I see show using an SQLDataAdapter, but I'd rather not
> > recreate the sql when it's been created for me. Any thoughts? Examples?
> >
> > Thanks for any help...
> >
> > -Ben 
> 
>

Date:Thu, 9 Aug 2007 09:00:06 -0700 Author:

Re: using typed dataset with data relations?

Sure... http://www.developer.com/db/article.php/3693236

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"benji"  wrote in message 
news:1C08D807-A6D4-4537-BA9C-D7C1FD2408A6@microsoft.com...

> Hi Bill,
>
> Could you include a link or article title?
>
> -Ben
>
> "William Vaughn" wrote:
>
>> I'm not sure this is your issue, but did you see www.developer.com? It
>> features a new article that discusses this issue (I think).
>>
>> -- 
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant, Dad, Grandpa
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com
>> www.betav.com/blog/billva
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no 
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "benji"  wrote in message
>> news:D3612466-30F7-44AA-A08A-A70B69D8DCA3@microsoft.com...
>> > Hi,
>> >
>> > I'm working with the dataset designer, which, via its wizard can 
>> > generate
>> > both a fill method and one to return a datatable. So I can use these to
>> > get a
>> > specific datatable back, but I can't traverse a relationship, because 
>> > the
>> > other table doesn't exist! So I assume I need to maybe manually declare 
>> > an
>> > instance of the typed dataset, but then how do I fill it? Can I use one 
>> > of
>> > the methods generated for me? Are the relations I "designed" implicitly 
>> > in
>> > place? Examples I see show using an SQLDataAdapter, but I'd rather not
>> > recreate the sql when it's been created for me. Any thoughts? Examples?
>> >
>> > Thanks for any help...
>> >
>> > -Ben
>>
>>

Date:Thu, 9 Aug 2007 10:32:44 -0700 Author:

Re: using typed dataset with data relations?

Thanks Bill, this got me on the right track.

"William Vaughn" wrote:


> Sure... http://www.developer.com/db/article.php/3693236
> 
> -- 
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
> 
> "benji"  wrote in message 
> news:1C08D807-A6D4-4537-BA9C-D7C1FD2408A6@microsoft.com...
> > Hi Bill,
> >
> > Could you include a link or article title?
> >
> > -Ben
> >
> > "William Vaughn" wrote:
> >
> >> I'm not sure this is your issue, but did you see www.developer.com? It
> >> features a new article that discusses this issue (I think).
> >>
> >> -- 
> >> ____________________________________
> >> William (Bill) Vaughn
> >> Author, Mentor, Consultant, Dad, Grandpa
> >> Microsoft MVP
> >> INETA Speaker
> >> www.betav.com
> >> www.betav.com/blog/billva
> >> Please reply only to the newsgroup so that others can benefit.
> >> This posting is provided "AS IS" with no warranties, and confers no 
> >> rights.
> >> __________________________________
> >> Visit www.hitchhikerguides.net to get more information on my latest book:
> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> >> -----------------------------------------------------------------------------------------------------------------------
> >>
> >> "benji"  wrote in message
> >> news:D3612466-30F7-44AA-A08A-A70B69D8DCA3@microsoft.com...
> >> > Hi,
> >> >
> >> > I'm working with the dataset designer, which, via its wizard can 
> >> > generate
> >> > both a fill method and one to return a datatable. So I can use these to
> >> > get a
> >> > specific datatable back, but I can't traverse a relationship, because 
> >> > the
> >> > other table doesn't exist! So I assume I need to maybe manually declare 
> >> > an
> >> > instance of the typed dataset, but then how do I fill it? Can I use one 
> >> > of
> >> > the methods generated for me? Are the relations I "designed" implicitly 
> >> > in
> >> > place? Examples I see show using an SQLDataAdapter, but I'd rather not
> >> > recreate the sql when it's been created for me. Any thoughts? Examples?
> >> >
> >> > Thanks for any help...
> >> >
> >> > -Ben
> >>
> >> 
> 
>

Date:Tue, 14 Aug 2007 13:14:02 -0700 Author: