CasCading DropDown List

Hello Soheb,

when your page is load at that time you need to fetch this dropdown data. and then after you fetch the listing page data at that time automatically shows, that text as well.

Thanks

Please refer to your previous question, I have an answer

https://www.c-sharpcorner.com/Forums/cascading-dropdown-list35

Hi,

To achieve this functionality, you can use Ajax to fetch the text values based on the selected IDs dynamically. Here's a high-level overview of the steps involved:

1. Create models for Country, State, and City with properties like ID and Name.
2. Implement cascading dropdown lists in your View using jQuery and Ajax.
3. Write controller actions to handle Ajax requests and return JSON data.
4. Use jQuery to make Ajax calls to these controller actions and update dropdown lists dynamically.

public class Country
{
    public int CountryId { get; set; }
    public string CountryName { get; set; }
}

public class State
{
    public int StateId { get; set; }
    public string StateName { get; set; }
    public int CountryId { get; set; } // Foreign key to Country
}

public class City
{
    public int CityId { get; set; }
    public string CityName { get; set; }
    public int StateId { get; set; } // Foreign key to State
}

Controller code 

public class HomeController : Controller
{
    private readonly YourDbContext _dbContext; // Replace YourDbContext with your actual DbContext

    public HomeController(YourDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    [HttpGet]
    public JsonResult GetStatesByCountry(int countryId)
    {
        var states = _dbContext.States.Where(s => s.CountryId == countryId)
                                       .Select(s => new { s.StateId, s.StateName })
                                       .ToList();
        return Json(states, JsonRequestBehavior.AllowGet);
    }

    [HttpGet]
    public JsonResult GetCitiesByState(int stateId)
    {
        var cities = _dbContext.Cities.Where(c => c.StateId == stateId)
                                       .Select(c => new { c.CityId, c.CityName })
                                       .ToList();
        return Json(cities, JsonRequestBehavior.AllowGet);
    }
}

Ajax Code

    @Html.DropDownListFor(model => model.CountryId, ViewBag.Countries as SelectList, "Select Country", new { id = "CountryId" })


    @Html.DropDownListFor(model => model.StateId, Enumerable.Empty(), "Select State", new { id = "StateId" })


    @Html.DropDownListFor(model => model.CityId, Enumerable.Empty(), "Select City", new { id = "CityId" })

Default Country when page load

public ActionResult Index()
{
    // Retrieve list of countries from database
    var countries = _dbContext.Countries.ToList();
    ViewBag.Countries = new SelectList(countries, "CountryId", "CountryName");

    return View();
}