Dynamic Repeater Control

[erin.sebastian]

Hello All,
I have 2 tables in my sql database, a table that holds different years
(ex, 2003,2004,2005,2006) and then another table that holds newsletter
information and the year is a foreign key to the year table (ex,
NewletterTitle,NewsletterfileName,Year)

What i want to do is dynamically show the content on the ASPX page like
so:

2005
newsletter1
newsletter2
newsletter3

2004
newsletter1

2003
newsletter1
newsletter2

or even better like this:

2004 2005
newsletter newsletter

2002 2001
newsletter newsletter
I'm not exactly sure if i can do this dynamically, i tried selecting
all of the year records out of the database and loop through those
while selecting all of the relevant records from the newsletter table
using the year data from the year table and then somehow adding this to
a repeater dynamically to display the results. Is this
understandable??? Can this be done dynamically??

Thanks,
Erin

[Karl Seguin [MVP]]

Don't know exactly what part you wanna do dynamically, but if you check out:
http://openmymind.net/index.aspx?documentId=8#7

it explains how to do nested bindings...I'm pretty sure it's what you'll be
looking for...

Karl

--
http://www.openmymind.net/
http://www.codebetter.com/
<er************@cowaninsurancegroup.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...

Hello All,
I have 2 tables in my sql database, a table that holds different years
(ex, 2003,2004,2005,2006) and then another table that holds newsletter
information and the year is a foreign key to the year table (ex,
NewletterTitle,NewsletterfileName,Year)

What i want to do is dynamically show the content on the ASPX page like
so:

2005
newsletter1
newsletter2
newsletter3

2004
newsletter1

2003
newsletter1
newsletter2

or even better like this:

2004 2005
newsletter newsletter

2002 2001
newsletter newsletter
I'm not exactly sure if i can do this dynamically, i tried selecting
all of the year records out of the database and loop through those
while selecting all of the relevant records from the newsletter table
using the year data from the year table and then somehow adding this to
a repeater dynamically to display the results. Is this
understandable??? Can this be done dynamically??

Thanks,
Erin