Create PROCEDURE Monthlypurchase AS BEGIN SELECT Sum(OrderAmount) AS OrderAmount FROM Purchases WHERE MONTH(getDate()) = Month(OrderDate) END
for This I used below in Controller: <pre lang="HTML">ViewBag.orderAmount = db.Monthlypurchase();
@ViewBag.orderAmount
System.Data.Entity.Core.Objects.ObjectResult`1[System.Nullable`1[System.Decimal]]
ViewBag.OrderAmounts = db.Monthlypurchase();
ViewBag.OrderAmounts = db.Monthlypurchase().FirstOrDefault();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)