Hi im new to this funny world of ASP.NET (VB)
I know how to show records from a DB in a repeater, but now i need to do the following.
Table_1
main_title_ID
main_title_title
Table_2
price_ID
price_text
price_value
price_main_ID
i need to show all records as following.
show the main_title_title ordre by main_title_ID ASC
and then under that show the price lines where price_main_ID = main_title_ID
so i will get something like this in the repeater
Photo Album
- large 10$
- small 5$
NewYear Album
- color 5$
- small 7$
- large 10$
how do i get the main_title from one table in a DB and then the sublines from another table in a DB, where the price_main_ID (Table_2) = main_title_ID (Table_1)
now i use a ODB line like this. (like relation)
Dim cmd As New OleDbCommand("select * from tbl order by id asc", myAccessConnection)
To deal with datatable very article you can see;
http://www.dotnetfunda.com/articles/article131.aspx
http://www.asp.net/data-access/tutorials/adding-additional-datatable-columns-vb