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/is...e/default.aspx

Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Natty Gur]

Hi,

I think that what you after :
http://msdn.microsoft.com/msdnmag/is...e/default.aspx

Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Homa]

Cool. Thanks.

Homa Wong

Natty Gur <na***@dao2com.com> wrote in message news:<uV**************@TK2MSFTNGP09.phx.gbl>...

Hi,

I think that what you after :
http://msdn.microsoft.com/msdnmag/is...e/default.aspx

Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Homa]

Cool. Thanks.

Homa Wong

Natty Gur <na***@dao2com.com> wrote in message news:<uV**************@TK2MSFTNGP09.phx.gbl>...

Hi,

I think that what you after :
http://msdn.microsoft.com/msdnmag/is...e/default.aspx

Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!