public void ProductManagmentIntoGridView(bool reload, int id, int userId, int productId) { if (reload) { using (WarehouseServiceClient client = new WarehouseServiceClient("HTTP")) { prodManagList = client.GetItem(id, userId, productId); if (prodManagList == null) { //prodManagList = new List<WWS.ProductManagment>(); } productListForProdManag = ApplicationData.Products.Select(p => p.Value).ToList(); var pMJOinP = prodManagList.Join( productListForProdManag, p => p.ProductId, m => m.Id, (p, m) => new { Id = p.Id.Value, Product = m.Name, Quantity = p.Quantity, ActionDate = p.ActionDate, Action = p.Action, userId = p.UserId, Reason = p.Reason, Price = p.Price, supplierId = p.SupplierId, brand = p.Brand, } ); var userList = client.SelectActiveUsers(); var pMJoinPJoinUser = pMJOinP.Join( userList, p => p.userId, u => u.Id, (p, u) => new { Id = p.Id, Product = p.Product, Quantity = p.Quantity, ActionDate = p.ActionDate, Action = p.Action, User = u.Username, Reason = p.Reason, Price = p.Price, supplierId = p.supplierId, brand = p.brand, } ); ProductManagmentGridView.DataSource = pMJoinPJoinUser.ToList(); ProductManagmentGridView.Columns[0].Visible = false; } } }