Failed to load data from the database

Question

I do have a Blazor App with a Product Page. There are some products in the database that I do want to display when the Products tab is selected. However the products are not displayed.

However on LoadProducts i could not get anything from res.Value, there is no such thing. How to get the list on LoadProducts method?

private async Task LoadProducts()
    {

        try
        {
                var response = await ProductController.GetAllProducts();

                var res = response.Result;
                if (response.Value != null)
                {
                    ProductsList = response.Value;
                }
            else
            {
                throw new Exception("Error: Unable to retrieve products.");
            }
        }
        catch (Exception ex)
        {
            throw new Exception($"Error loading products: {ex.Message}");
        }
    }

Vishal Joshi · Answer

Hello Try to use ToList(). check out the below code sample ProductsList = response.Value.ToList() Thanks

Rositsa Ruseva · Answer

Maybe there should be another solution

Rajendra Taradale · Answer

Also, check if this variable assignment is happening from any other places(for example default/ new initialization) - ProductsList

Jaimin Shethiya · Answer

Hello, Your function haven't return any list so you need to return that list. Try below code private async Task > LoadProducts() { var productsList = new List (); try { var response = await ProductController.GetAllProducts(); var res = response.Result; if (response.Value != null) { productsList = response.Value.ToList(); } else { throw new Exception("Error: Unable to retrieve products."); } return productsList; } catch (Exception ex) { throw new Exception($"Error loading products: {ex.Message}"); } } Thanks

Failed to load data from the database

Answers (4)