using typed dataset with data relations?

[Guest]

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

 

[William Vaughn]

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)

 

[Guest]

Hi Bill,

Could you include a link or article title?

-Ben

 

[William Vaughn]

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)
-----------------------------------------------------------------------------------------------------------------------

 

[Guest]

Thanks Bill, this got me on the right track.

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)