Id is displaying instead of Name on product

Question

Hi, I have 3 tables Product ............. ProductID ProductName 1 Apple 2 Lenovo Orders ............ OrderId OrderName 1 aaa 2 bbb Items ........... Id Name OrderId ProductID 1 dd 1 2 2 frr 1 1 3 ruur 2 1 i have one form and grid view in grid view i jave one button after clicking of that button i have to display relevant values on form based upon OrderId In form relevant values are dispaying properly except at product in Product it was dispalying only Id insted of Name Could please any body help me I am sharing here my edit script code Code ............................ $scope.Edit = function (OrderId) { debugger; $scope.invoice = true; var id = OrderId; //var id = $scope.employees[index].OrderId; $.post("/invoice/Edit/", { orderID: id }, function (r) { debugger; $scope.OrderId = r.Orders.OrderId; $scope.OrderName = r.Orders.OrderName; $scope.myData = []; for (var i = 0; i var customer = {}; customer.OrderId = r.Items[i].Names; customer.OrderName = r.Items[i].Name; customer.Id = r.Items[i].Id; customer.Product = r.Items[i].ProductID; customer.Name = r.Items[i].Name; $scope.myData.push(customer); } }); } View ................... {{invoice.id}} {{invoice.Product}} {{invoice.Name}} {{$index+1}} -- Select Product --

Piyush Pansuriya · Answer

List listItem = new List (); var items = (from i in db.Items5 join p in db.Products on i.ProductID equals p.ProductID where i.OrderId == orderID select new { Id = i.Id, Name=i.Name, ProductID =i.ProductID, ProductName = p.ProductName, }).ToList(); foreach (var item in items) { listItem.Add( new Items5 { Id = item.Id,Name=item.Name, ProductID=item.ProductID, ProductName=item.ProductName}); } Add Property ProductName is class Item5 string ProductName { get ; set ;}

Mahesh Reddy · Answer

Could please check this is my query for Items List listItem = new List (); var items = (from i in db.Items5 where i.OrderId == orderID select new { Id = i.Id, Name=i.Name, ProductID =i.ProductID, }).ToList(); foreach (var item in items) { listItem.Add(new Items5 { Id = item.Id,Name=item.Name, ProductID=item.ProductID}); }

Prem Anandh J · Answer

You have to change the SQL query . Write Join query with Items and Product table. So that u can get Product name also Still having doubt , share the select query of Items

Mahesh Reddy · Answer

Hi, Thnaks for your reply while debugging it was showing undefiend in Items table i have Name,Id,OrderId and ProductID Probelm is that it has been displaying only productid i need productName

Prem Anandh J · Answer

customer.ProductName= r.Items[i].ProductName; Add Product name in for loop