JSON for generate - combobox value
var Isd = $('#Id').textbox('getValue');
var lIsd = $('#Line_Id').textbox('getValue');
get value from a text box for param that generate combobox value
var urlTrx = '/controller/method';
$.ajax({
url: urlTrx,
implement url to ajax call
type: 'POST',
ajax call type
dataType: "JSON",
ajax call data type
data: { reqID: Isd, lineID: lIsd },
ajax call pass data value that required for Controller.method in url
variable name must have same in method controller for sample method in controller:
public JsonResult GetVehicleName(String reqID, String lineID)
is have same variable name like JSON data (reqID, lineID):
data: { reqID: heq_request_Isd, lineID: heq_requestLine_Isd },
public JsonResult GetVehicleName(String reqID, String lineID)
{
String Query = "SELECT * from Tabel where id="+reqID+" and lineid="+lineID;
List<amodel> itemList = new List<amodel>();
SqlDataReader Reader = OkiDbTools.ReadDb(Query);
if (Reader.HasRows)
{
while (Reader.Read())
{
amodel Itm = new amodel();
Itm.Vehicle_Id = Reader.GetInt32(0);
Itm.Vehicle_Name = Reader.GetString(1);
itemList.Add(Itm);
}
}
Reader.Close();
Reader.Dispose();
return Json(itemList);
}
success: function (result) {
$('#Vehicle_Id').combobox({
valueField: 'Vehicle_Id',
textField: 'Vehicle_Name',
data: result
});
}
});}
populate json result to combobox
success: function (result) {
$('#Vehicle_Id').combobox({
valueField: 'Vehicle_Id',
textField: 'Vehicle_Name',
data: result
});
}
full AJAX CALL:
var Isd = $('#Id').textbox('getValue');
var lIsd = $('#Line_Id').textbox('getValue');
var urlTrx = '/HeqDispatchers/GetVehicleName';
$.ajax({
url: urlTrx,
type: 'POST',
dataType: "JSON",
//data: formData,
data: { reqID: heq_request_Isd, lineID: heq_requestLine_Isd },
success: function (result) {
$('#Vehicle_Id').combobox({
valueField: 'Vehicle_Id',
textField: 'Vehicle_Name',
data: result
});
}
});}
No comments:
Post a Comment