In this article I will explain how to bind dropdownlist using json data in asp.net with an example. On page load it attends to featch AJAX data from URL. Upon success, it fills product items based on the ajax call’s result.
HTML page:
<select id="cboProduct">
</select>
$(document).ready(function () {
$(".errorBlockMain").hide();
$.ajax({
type: 'POST',
url: '@Url.Action("BindProduct ", "Products", new { area = "Admin" })',
data: "{}",
contentType: 'application/json; charset=utf-8',
dataType: 'json',
success: function (data) {
$('#cboProduct').empty();
var inc = 0;
$.each(data, function (value) {
$("[id$='cboProduct']").append($("<option></option>").val(data[inc].ProductId).html(data[inc].Name));
inc = inc + 1;
});
},
error: function (xhr, ajaxOptions, thrownError) {
$(".errorBlockMain").html(xhr.responseText);
$(".errorBlockMain").show();
}
});
});
server Side:
[HttpPost]
public JsonResult BindProduct()
{
ProductItems mProductItems = (ProductItems) ProductItems.LoadListProduct ((string)HttpContext.Session["DBConnector"], "SELECT * FROM Product order by Product Idasc");
return Json(mProductItems, JsonRequestBehavior.AllowGet);
}
Post your comments / questions
Recent Article
- How to decode HTML character code in c#?
- How to save the xml file to a particular location?
- How to use if else statement in c++?
- How to use godaddy domain name with another godaddy hosting account?
- Restore of database 'DATABASE' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
- How to programmatically modifying the AppSetting value in web.config using c#?
- TypeError [ERR_INVALID_CALLBACK]: Callback must be a function. Received undefined
- How to calculate the age from jQuery ui datepicker using c#?
Related Article