Drop Down List Giving Incorrect Values

Hi everyone,

I have followed the following tutorial for my project:

https://www.youtube.com/watch?v=h_ViuyVs4AE

The issue that I have is that when I click an item in the first drop down box, it does not give the correct values in the second box, it only gives one value and it is incorrect. It should display all the Model_Name's(Vehicle_Model table) that are for each Make_Name(Vehicle_Make table).

Index.cshtml code:

@model GoogleMap.Models.MyPageViewModel
<script>
$(function () {
$("#ContID").change(function () {
$.get("/Map/GetModById", { MID: $("#ContID").val() }, function (data) {
$("#St").empty();
$.each(data, function (index, row) {
$("#St").append(" <option value='" + row.Model_ID + "'>" + row.Model_Name + "option>")
});
})
});
});
script>
@Html.DropDownListFor(p => p.SelectedMake_Id, ViewBag.Vehicle_Make as SelectList, "Select Vehicle Make", new { id = "ContID" })

MapController.cs code:

public class MapController : Controller
{
private GoogleMapEntities db = new GoogleMapEntities();
//Get the select ID???
int SelectedMake_Id = 0;
// GET: Map
public ActionResult Index()
{
GoogleMapEntities GE = new GoogleMapEntities();
List vehList = db.Vehicle_Details.ToList();
GoogleMapViewModel GMviewmodel = new GoogleMapViewModel();
List GMviewmodelList = new List();
//Populate the ViewModel
MyPageViewModel vm = new Models.MyPageViewModel();
vm.GoogleMapViewModelList = GMviewmodelList;
vm.SelectedMake_Id = SelectedMake_Id;
ViewBag.Vehicle_Make = new SelectList(db.Vehicle_Make, "Make_ID", "Make_Name");
return View(vm);
}
public JsonResult GetModById(int MID)
{
db.Configuration.ProxyCreationEnabled = false;
return Json(db.Vehicle_Model.Where(p => p.Model_ID == MID), JsonRequestBehavior.AllowGet);
}
[HttpPost]
public ActionResult Search(string Location)
{
GoogleMapEntities GE = new GoogleMapEntities();
////SELECT Make_Name DATA FROM DB1
// var result = GE.Vehicle_Model.Where(x => x.Model_Name.StartsWith(Location)).ToList();
var GetVeh = db.GetMapSearch().Where(x => x.Model_Name.StartsWith(Location)).ToList();
return Json(GetVeh, JsonRequestBehavior.AllowGet);
}
}

Look into this. I have created two ddl. One for state and city.

Controller code

public class RegistrationController : Controller

{

demoEcommerceEntities objEF = new demoEcommerceEntities();

// GET: Registration

public ActionResult Index()

{

bindState();

return View();

}

public void bindState()

{

var state = objEF.tblStates.ToList();

List li = new List();

li.Add(new SelectListItem { Text = "--Select State--", Value = "0" });

foreach (var m in state)

{

li.Add(new SelectListItem { Text = m.statename, Value = m.stateid.ToString() });

ViewBag.state = li;

}

public JsonResult getCity(int id)

{

var ddlCity = objEF.tblCities.Where(x => x.stateid == id).ToList();

List licities = new List();

licities.Add(new SelectListItem { Text = "--Select State--", Value = "0" });

if (ddlCity != null)

{

foreach (var x in ddlCity)

{

licities.Add(new SelectListItem { Text = x.CityName, Value = x.Cityid.ToString() });

}

return Json(new SelectList(licities, "Value", "Text", JsonRequestBehavior.AllowGet));

}

View

@Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.State, ViewBag.state as List, new { style = "width: 200px;" })

@Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })

Dropdown

@Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.City, new SelectList(string.Empty, "Value", "Text"), "--Select City--", new { style = "width:200px" })

@Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rohanjoy Bhattacharya9y ago
Look into this. I have created two ddl. One for state and city.
Controller code
public class RegistrationController : Controller
{
demoEcommerceEntities objEF = new demoEcommerceEntities();
// GET: Registration
public ActionResult Index()
{
bindState();
return View();
}
public void bindState()
{
var state = objEF.tblStates.ToList();
List li = new List();
li.Add(new SelectListItem { Text = "--Select State--", Value = "0" });
foreach (var m in state)
{
li.Add(new SelectListItem { Text = m.statename, Value = m.stateid.ToString() });
ViewBag.state = li;
}
}
public JsonResult getCity(int id)
{
var ddlCity = objEF.tblCities.Where(x => x.stateid == id).ToList();
List licities = new List();
licities.Add(new SelectListItem { Text = "--Select State--", Value = "0" });
if (ddlCity != null)
{
foreach (var x in ddlCity)
{
licities.Add(new SelectListItem { Text = x.CityName, Value = x.Cityid.ToString() });
}
}
return Json(new SelectList(licities, "Value", "Text", JsonRequestBehavior.AllowGet));
}
}
View

@Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.State, ViewBag.state as List, new { style = "width: 200px;" })
@Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })

Dropdown

@Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.City, new SelectList(string.Empty, "Value", "Text"), "--Select City--", new { style = "width:200px" })
@Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })