Query and Display an order list using DataList

[Homa]

Hi to all,

My database has two tables: order and orderItem. the order table has
(idOrder, name, address, etc) and the orderItem table has (idOrder,
idProduct, Quantity)

I want to present the information using DataList so that for each item
(in itemTemplate) it shows the order information as well as the
orderItems.

I place another DataList inside the itemTemplate of the outer one to
display the orderItems. But I don't know how to do it.

And is this a good practice? or I should just display them using table
tag and do it in the itemCreate Event?

Thanks for concern,
Homa Wong

 

[Natty Gur]

Hi,

I think that what you after :
http://msdn.microsoft.com/msdnmag/issues/03/10/CuttingEdge/default.aspx

Natty Gur[MVP]
Phone Numbers:
Office: +972-(0)9-7740261
Fax: +972-(0)9-7740261
Mobile: +972-(0)58-888377

 

[Homa]

Cool. Thanks.

Homa Wong