aspx
| <%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataListNesting.aspx.cs" Inherits="DataListNesting" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>DataListNesting</title> </head> <body> <form id="form1" runat="server"> <div> <asp:DataList ID="DataList1" runat="server" OnItemDataBound="DataList1_ItemDataBound" DataSourceID="SqlDataSource1"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("OrderID") %>'></asp:Label> <asp:Label ID="Label2" runat="server" Text='<%# Eval("CustomerID") %>'></asp:Label> <asp:DataList ID="DataList2" runat="server" DataSourceID="SqlDataSource2"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("ProductID") %>'></asp:Label> <asp:Label ID="Label2" runat="server" Text='<%# Eval("UnitPrice") %>'></asp:Label> <asp:Label ID="Label3" runat="server" Text='<%# Eval("Quantity") %>'></asp:Label> </ItemTemplate> </asp:DataList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=.\sqlexpress;Initial Catalog=Northwind;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="select ProductID, UnitPrice, Quantity from [Order Details] where orderID = @orderID"> <SelectParameters> <asp:Parameter Name="orderID" /> </SelectParameters> </asp:SqlDataSource> </ItemTemplate> </asp:DataList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.\sqlexpress;Initial Catalog=Northwind;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="select OrderID, CustomerID from Orders"></asp:SqlDataSource> </div> </form> </body> </html> |

