Realtions Problem

[Steven Licciardi]

Hello,

I have created an MSDE database with one central table containing one
primary key, there are several other tables connected to that table via
relationships. I have managed to use the DataAdapter class to fill a
dataset with the contents of the main table. dAdapter.fill(ds), with a
selection command of "SELECT * FROM maintable". This all works fine, I
would now like the user to be able to select one entry from maintable and to
be able to now fill the dataset with all the related tables containing all
the related information. How do I do this? Currently I only get the
contents of one table in the dataset. Is there a select command of the form
: SELECT * from database WHERE id IN maintable IS idnum INCLUDING RELATED
DATA, for example?

Thanks,

Steven

 

[Gavin Joyce]

Hi,

You will need to build a multi-tabled DataSet and fill each table with the
related data. It could take a while, or you could use a tool like
nTierGen.NET which will do it all for you. http://www.nTierGen.NET/

HTH,
Gavin Joyce

--
___________________________________________________________
nTierGen.NET Code Generator - http://www.nTierGen.NET/

Stored Procedures (Get, GetPaged, Insert, Update, Delete)
Data Access Layer - C#
Business Rules Layer - C# & VB.NET
Strongly-Typed DataSets - C#
Web Services - C#
___________________________________________________________

 

[Steven Licciardi]

Thanks,

I'll look into it.

Steven

Hi,

You will need to build a multi-tabled DataSet and fill each table with the
related data. It could take a while, or you could use a tool like
nTierGen.NET which will do it all for you. http://www.nTierGen.NET/

HTH,
Gavin Joyce

--
___________________________________________________________
nTierGen.NET Code Generator - http://www.nTierGen.NET/

Stored Procedures (Get, GetPaged, Insert, Update, Delete)
Data Access Layer - C#
Business Rules Layer - C# & VB.NET
Strongly-Typed DataSets - C#
Web Services - C#
___________________________________________________________
and