Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim ODs = (From od In db.tblOrderDetails Join o In _ db.tblOrders On od.OrderID Equals o.OrderID Join c In _ db.tblCustomers On o.CustomerID Equals c.CustomerID Join s In _ db.tblSoftwares On od.SoftwareID Equals s.SoftwareID _ Where o.OrderID = IIf(intOrderID = 0, o.OrderID, intOrderID) And _ o.CustomerID = IIf(intCustID = 0, o.CustomerID, intCustID) _ Order By c.FirstName & " " & c.LastName _ Select CustName = c.FirstName & " " & c.LastName, _ od.OrderID, o.OrderDate, s.Title, od.Quantity, s.UnitPrice, Sub_Total = od.Quantity * s.UnitPrice).ToArray()
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.