microsoft.public.dotnet.framework.aspnet.webservices

Mikael Gustavsson

7/28/2003 8:16:00 AM

Hi Thomas!

If you have created a relation between for instance the Products table and
the Products2Genre tables and that in time to the Genre table then you can
just walk down the hierarchy.

//This will symbolize the fetching of the products
ProductDataSet ds = GetTheProducts();

string categoryName =
ds.Products[x].GetProduct2GenreRows()[y].GetGenreRows()[z].genrename

So in your case you could do it this way

foreach (ProductDataSet.Product2Genre productGen in
ds.Procducts[5].GetProduct2GenreRows())
{
foreach (ProductDataSet.Genre gen in productGen.GetGenreRows())
{
//Do what you want to do with the genre here
}
}

Well, I hope this helps you out a bit in the right direction

//Mikael

"Thomas Zaleski" <anonymous@devdex.com> wrote in message
news:Oa$zCe$RDHA.1552@TK2MSFTNGP10.phx.gbl...
> I have 5 tables in my dataset that I have pulled all records for from
> the database. The table structure look like this:
>
> Products(productid, productname)
> Product2Category(productid, categoryid)
> Category(categoryid, categoryname)
> Product2Genre(productid, genreid)
> Genre(genreid, genre name)
>
> So basically, when someone clicks on a category, i.e. categoryid = 5,
> then I would like to pull all associated genres (DISTINCT) for the
> products corresponding to category id = 5.
>
> How would I navigate and pull that data.
>
> Please let me know.
>
> Thanks.
>
> *** Sent via Developersdex http://www.develop... ***
> Don't just participate in USENET...get rewarded for it!