Having trouble retrieving nested JSON values for a dropdown list

Question

Having trouble retrieving nested JSON values for a dropdown list

Below is some example JSON data

https://i.sstatic.net/zl3XR.png

At the moment, I am successfully able to retrieve Bank HooMan by using

var b = details.b.Select(x => x.Bank).FirstOrDefault();

when I put a breakpoint in the controller. However, my issue lies in how to select Hooman for @Html.DropDownListFor

Here is what I have attempted so far:

@Html.DropDownListFor(m => m.BankID, new SelectList(ViewBag.BankList, "BankID", "BankName", Model.b.Select(x => x.Bank).FirstOrDefault()), new { @class = "form-control" })

Unfortunately, this method does not seem to select HooMan. I have also tried utilizing SelectList on the model like this:

details.BankList = new SelectList(JsonConvert.DeserializeObject<List<BankLists>>(await OperationServices.GetBankListAsync()),
                                        "BankID", "BankName", details.b.Select(x => x.Bank).FirstOrDefault());
//View
@Html.DropDownListFor(m => m.BankID, Model.BankList, new { htmlAttributes = new { @class = "form-control" } })

However, I still encounter the same issue where the dropdownlist is unable to select the data. Is there something that I may be overlooking? Additionally, I need to access values within acs.

EDIT (as requested by Tomato32):

BankList is also in JSON format which we deserialize into a model. I can populate the list and add it to the dropdown, but I am struggling to select the value from the nested JSON mentioned above.

https://i.sstatic.net/8zXuW.png

javascript c#.net asp.net-core model-view-controller

Answer 1

Answer №1

Hey there, apologies for the delayed response. You have chosen BankName for the Dropdownlist, which prevents it from selecting the correct value.

You can use JQuery to set the selected value without making extensive changes to the code. Here's a helpful example. Hope this resolves your issue :))

1) Inside the controller

var selectedBank = bankData.b.Select(t => t.Bank).FirstOrDefault();  //Retrieve the selected bank name

ViewBag.SelectedBankID = banklist.FirstOrDefault(t => t.BankName == selectedBank).BankID; //Obtain the BankID

2) In the View

<script>
        $(document).ready(function () {
            $('#BankID').val('@ViewBag.SelectedBankID');
        });
    </script>

Answer 2

Hey there, apologies for the delayed response. You have chosen BankName for the Dropdownlist, which prevents it from selecting the correct value.

You can use JQuery to set the selected value without making extensive changes to the code. Here's a helpful example. Hope this resolves your issue :))

1) Inside the controller

var selectedBank = bankData.b.Select(t => t.Bank).FirstOrDefault();  //Retrieve the selected bank name

ViewBag.SelectedBankID = banklist.FirstOrDefault(t => t.BankName == selectedBank).BankID; //Obtain the BankID

2) In the View

<script>
        $(document).ready(function () {
            $('#BankID').val('@ViewBag.SelectedBankID');
        });
    </script>

Having trouble retrieving nested JSON values for a dropdown list

Answer №1

Similar questions

Distributing utility functions universally throughout the entire React application

Having difficulty linking a click event to an Anchor tag within a React component

The Material UI dialog is causing issues for CKEditor 4

Formatting strings with positive or negative numbers can be achieved using Utilities.formatString

Bookshelfjs fails to return a promise when updating multiple data

Utilize the fetch function within a Vuex action

My gadget is caught in a loop, the conditions are failing to function properly

What is the most efficient way to calculate the current percentage of time that has elapsed today

Error: The program could not locate the entry point for the application: WebDev.WebServer40.EXE

Users of the website will be required to log in again after approximately 1 to 5 minutes of not being active

Exceeding the maximum update depth can occur if a component triggers a setState function within the useEffect hook

Can you explain the purpose of the filters within this function and elaborate on how exactly we are achieving the return value?

What are the HTML5 elements that include the "load event" within their onload attribute?

What are the most efficient methods to minimize the number of queries when retrieving data?

Trouble arises when trying to insert a script tag into a live code editor using HTML

What is the best C# driver option for connecting to MongoDB?

Unsuccessful AJAX request failing to trigger success callback

Having trouble inserting a date into a MySQL database from C# code

Unresolved CORS Issue in Vue.js Using Axios with undefined Proxy Response

Issue with ASP Handler failing to send error message to ajax request in a managed hosting environment