Displaying data in tabular format in asp from database

[teju]

Hello,
I have to display all the data from the database in tables in ASP. I am able to get the data but the problem is of displaying one to many relations.Like below Title1 has two records but how would i display in the table
Title1 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

Tite2 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

My loop is getting all the data together. I don't know hoe to seperate that

Could any one help with this.

Many thanks,
Teju

[jhardman]

Hello,
I have to display all the data from the database in tables in ASP. I am able to get the data but the problem is of displaying one to many relations.Like below Title1 has two records but how would i display in the table
Title1 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

Tite2 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

My loop is getting all the data together. I don't know hoe to seperate that

Could any one help with this.

Many thanks,
Teju

I'm not sure I got you exactly. I once had to display a long list of works written by different authors. The authors were in one table and the works in another. So essentially I had a list of authors, and under each was a table of their works. Is this something similar to what you want? How is your db table set up? Is it more than one table?

Jared

[teju]

Hello,
Actually, I wanted to display one to many relationship data on the ASP page. SO that it shouldn't display the duplicate titles.

I got it from asp faq web

Thanks for your help