How to read data from 3 tables so that quering every table according to the each item in one of the tables to get the following figure:

Title1
 Paragraph 1
   Bullet1
   Bullet2
 Paragraph 2
   Bullet1
   Bullet2
and so on......
I have tbl_Title,tbl_Paragraph,tbl_Bullet
I want the result in a datalist.
Thanks

There are a couple ways to do this.

Option 1
Create a query that gets you all the fields you need by joining together the tables required. Then you could spin thru the results and build your text result. You'll need to keep track of what the current title and paragraph is so you can tell when you get to a row that contains a new one.

Option 2
Fill a DataSet with the data from all three tables, and set up DataRelations between the tables. Then you can use nested databinding to display the results.

Here's a sample of how to do nested binding with a DataSet:
http://www.geekdork.com/samples/complexDatagrid.aspx


-Peter