Unable to bind Cascading Dropdowns

My DB consists of Regions, Divisions & States. My application (ASP.NET MVC) application uses entityframework to bind data to DropDown.

[HttpGet]
public JsonResult GetDivisionsByRegions(string regionID = "")
{
try
{
List allDivisions = new List();
int ID = 0;
if (int.TryParse(regionID, out ID))
{
using (GeoEntities data = new GeoEntities())
{
allDivisions = data.Divisions.Where(div => div.RegionID == ID).OrderBy(div => div.DivisionID).ToList();
}
}
if (Request.IsAjaxRequest())
{
return new JsonResult
{
Data = allDivisions,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
else
{
return new JsonResult
{
Data = "Invalid Data",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
}
finally
{
}
}

Please help me out..

Try your GetDivisionsByRegions(...) method linke below i.e.

[HttpGet]
public ActionResult GetDivisionsByRegions(string regionID = "")
{
try
{
List allDivisions = new List();
int ID = 0;
if (int.TryParse(regionID, out ID))
{
using (GeoEntities data = new GeoEntities())
{
allDivisions = data.Divisions.Where(div => div.RegionID == ID).OrderBy(div => div.DivisionID).ToList();
}
}
if (allDivisions == null || allDivisions.Count <= 0)
{
result = this.Json(new {Error = "Invalid Data"}, JsonRequestBehavior.AllowGet);
return result;
}
result = this.Json(allDivisions, JsonRequestBehavior.AllowGet);
}
finally
{
}
return result;
}

1 Reply

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