A couple of questions from a novice

CartTotal = myCart.Sum(od => (decimal)od.Quantity * (decimal)od.UnitCost);

this is total calculation from MyShoppingCart.cs file

First where did the "od" come from and

Second

How do you translate that line to VB.Net?

I'd appreciate your reply, and Thanx again for everything, and God bless,, you're doing a great job.

cartTotal = myCart.Sum(Function(od) CDec(od.Quantity) * CDec(od.UnitCost))

I haven't tested this, it's just a tentative answer at the top of my head.

I hope it helps in some way.

I got it working with this and it works fine too

CartTotal = myCart.AsQueryable().Sum(Function(pkg) pkg.UnitCost * pkg.Quantity)

I will copy yours and try it out too.

I apprieciate your help and I am almost finished with the VB version, doing the final checkout.

To Maria,

I just replied to your post and it disappeared, well I was saying that I got it to work afterall, and thanx for your reply and you are right it is collection expression, but I will try your code too, mine worked just fine, I used the following

CartTotal = myCart.AsQueryable().Sum(Function(od) od.UnitCost * od.Quantity)

which is the same.

Thanx again for your post

Thanx for the code, it worked just as well as the one I had, however I have a new problem, eventhough I tried and tried, I just couldn't get this query to translate, I even resorted to use a translator for it, it kept giving me a lot of errors, so I was hoping to ask for your expertise one more time if you have the time or maybe someone you know could help with this.

here is the query in C#

var query = (from ProductOrders in db.OrderDetails

join SelectedProducts in db.Products on ProductOrders.ProductID equals SelectedProducts.ProductID

group ProductOrders by new

{

ProductId = SelectedProducts.ProductID,

ModelName = SelectedProducts.ModelName

} into grp

select new

{

ModelName = grp.Key.ModelName,

ProductId = grp.Key.ProductId,

Quantity = grp.Sum(o => o.Quantity)

} into orderdgrp

where orderdgrp.Quantity > 0

orderby orderdgrp.Quantity descending

select orderdgrp).Take(5);

It's along one but I'm sure it would be a peice of cake for someone like you.

Thanx again.

You just won't believe how rediculous the answer that found for that dilema, and how simple it was.

Thanx anyway and God bless.

"the name Session does not exist in the current context"

everywhere where I use:

Session["TailspinSpyworks_CartID"]

Any ideas?

I've added everything like you said, I have no build erros, everything looks fine, but when I click Add To Cart button there is nothing added in ShoppinCart table...

Argh...

I also run the original project source code ("tailspinspyworks.codeplex.com/ also gives me same error... :(

Thanks alto for Joe Stagner

msdn.microsoft.com/