In this article, I am going to explain how to create cascading dropdownlist in asp.net mvc using jQuery to display multiple values. When the user selects the DropdownList, on the dropdown change jQuery, it loads the product price in a div tag.
Create a dropdroplist bind product using entity framework and also create a div tag.
Here I am using Northwind database. You can download it from following link.
Open Microsoft SQL management studio and right click on the database and attach it.
Step 1: Create an ado.net entity data model using table Products and generate entity for that.
Step 2: Right click on the "Controllers" folder and add "Home" controller. Copy and paste the following code.
private models db = new models();
public ActionResult Index()
{
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name");
return View();
}
[HttpPost]
public JsonResult GetProducts(int ProductId)
{
var mrp = db.Products.Where(x => x.ProductId == ProductId).First().MRP;
return Json(mrp.ToString());
}
Step 2: Copy and paste the following code in the design page index.cshtml.
<h2>DropdownList with productprice</h2>
<script type="text/javascript">
$(function () {
$('#ProductId').change(function() {
$.ajax({
type: "POST",
url: "/Home/GetProducts",
datatype: "Json",
data: { ProductId: $('#ProductId').val() },
success: function (data) {
$('#txtProductRate').html(data);
}
});
});
});
</script>
<div class="form-group">
<label class="col-sm-3control-label">Product:</label>
<div class="col-sm-9">
@Html.DropDownList("ProductId", null, "Select Product", new { Class = "form-control", Style = "width:180px;" })
<div id="txtProductRate" style ="color:green"></div>
</div></div>
Post your comments / questions
Recent Article
- Your system's memory configuration has changed since it entered hibernation.
- Save image to client browser using jQuery?
- Get filename of image jQuery?
- How to get the image src using JavaScript?
- System.Net.Http.Formatting, Version=5.2.3.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' which has a higher version than referenced assembly 'System.Net.Http.Formatting' with identity 'System.Net.Http.Formatting, Version=4.0.0.0
- Cordova Android build error "Cannot read property 'length' of undefined". An error occurred while running subprocess cordova.
- ERROR in The Angular Compiler requires TypeScript >=3.9.2 and <4.0.0 but 3.8.3 was found instead
- Code ENOLOCAL Could not install from "android" as it does not contain a package.json file.
Related Article