Part 7: Adding Featureshttp://www.asp.netThu, 23 Aug 2012 13:18:33 GMTumbracoComments for Part 7: Adding FeaturesenComment Posted by jrbradyhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-7Mon, 15 Nov 2010 17:11:56 GMT00000000-0000-0000-0000000010956For all of you VB programmers who may be new to this, I will save you the headache I went through in translating the C# code for the Page_Load event of the PopularItems control:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Using db As New CommerceEntities

Try

Dim query = (From ProductOrders In db.OrderDetails

Join SelectedProducts In db.Products On ProductOrders.ProductID Equals SelectedProducts.ProductID

Group ProductOrders By

ProductId = SelectedProducts.ProductID,

ModelName = SelectedProducts.ModelName

Into grp = Group

From orderGrp In grp

Select ModelName, ProductId, Quantity = grp.Sum(Function(o As OrderDetail) o.Quantity) Distinct

Where Quantity > 0 Order By Quantity Descending).Take(5)

RepeaterItemsList.DataSource = query

RepeaterItemsList.DataBind()

Catch ex As Exception

Throw New Exception("ERROR: Unable to Load Popular Items - " & ex.Message.ToString(), ex)

End Try

End Using

End Sub

]]>Comment Posted by nosnetromhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-7Tue, 17 May 2011 17:09:16 GMT00000000-0000-0000-0000000013199I am getting an error when implementing the AlsoPurchased control; it does not seem to be picking up the product ID from the querystring (or anywhere else, for that matter). I declared "private int _ProductID;" in the codebehind to the AlsoPurchased control, just after the public partial class AlsoPurchased. Any ideas? TIA!

]]>Comment Posted by noblebathttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-7Thu, 23 Aug 2012 13:18:33 GMT00000000-0000-0000-0000000016267<uc1:AlsoPurchased ID="AlsoPurchased1" runat="server" ProductId='<%# Eval("ProductID") %>' /> is not picking up the ProductID in the data source control for the property ProductId of the user control.

]]>