<%@ Control Language="c#" Inherits="Microsoft.Samples.SqlServer.AlsoBoughtControl" CodeFile="_AlsoBought.ascx.cs" %> <!-- ===================================================================== File: _AlsoBought.ascx for Adventure Works Cycles Storefront Sample Summary: List the most common additional products purchased with the current product Date: June 16, 2003 ===================================================================== This file is part of the Microsoft SQL Server Code Samples. Copyright (C) Microsoft Corporation. All rights reserved. This source code is intended only as a supplement to Microsoft Development Tools and/or on-line documentation. See these other materials for detailed information regarding Microsoft code samples. THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. ======================================================= --> <%-- This user controls lists other products that customers who purchased a product "also bought". --%> <table width="95%" cellpadding="0" cellspacing="0" border="0"> <tr> <td> <asp:Repeater ID="alsoBoughtList" runat="server"> <HeaderTemplate> <tr> <td class="MostPopularHead"> People who purchased items in your shopping cart also bought </td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td bgcolor="#d3d3d3"> <asp:HyperLink CssClass="MostPopularItemText" NavigateUrl='<%# "ProductDetails.aspx?ProductID=" + DataBinder.Eval(Container.DataItem, "ProductID")%>' Text='<%#DataBinder.Eval(Container.DataItem, "Name")%>' runat="server" /> <br> </td> </tr> </ItemTemplate> <FooterTemplate> <tr> <td bgcolor="#d3d3d3"> </td> </tr> </FooterTemplate> </asp:Repeater> </td> </tr> </table>