a strange way to display data from 2 tables (ASP.NET)

Hi,

What I'm trying to do is to create a dataset that combines 2 tables (lets call them Primary and Secondary) All Secondary table items are a subset of a Primary table item.

Seems easy right? I can pull of the info with a query but its displaying it the way I want that's a problem.

Essentially, what I want to do is list the info like this:

PRIMARY 1
--------------
Secondary 1
Secondary 2
Secondary 3

PRIMARY 2
--------------
Secondary 4
Secondary 5

This seems to me to require a repeat region within a repeat region though.

Has anyone ever done this?

Try

http://www.aspnet101.com/aspnet101/aspnet/codesample.aspx?code=nest

or Kevin has an extension on his site www.webexcel-dw.com

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004



Crenfax wrote:

Hi,

What I'm trying to do is to create a dataset that combines 2 tables
(lets call them Primary and Secondary) All Secondary table items are
a subset of a Primary table item.

Seems easy right? I can pull of the info with a query but its
displaying it the way I want that's a problem.

Essentially, what I want to do is list the info like this:

PRIMARY 1
--------------
Secondary 1
Secondary 2
Secondary 3

PRIMARY 2
--------------
Secondary 4
Secondary 5

This seems to me to require a repeat region within a repeat region
though.

Has anyone ever done this?