query about json.

umair mohsin

Getting database records using json and viewmodel but no idea how to bind this with view(inside textboxes) in mvc.

In my application I am using json(used it to avoid page refresh) to fetch data from database.data is fetched and showing in an alert box but I have no idea how to display a single record value in an alert(this is only for test purpose,finally I will bind this record to a textbox in mvc). I am posting a chunk of code I am using in my application

Jquery Ajax

An html anchor tag(somewhere in a page) is hitting this method.table is there to show certain details of a database table from which record is to be fecthed.

function GetDetails(id) {
debugger
$.ajax({
url: "/JobSeeker/UpdateEducation/" + id,
type: "GET",
data: { "Id": id },
contentType: "application/json;charset=UTF-8",
dataType: "json",
success: function (result) {
alert(result);
},
error: function (response) {
alert(response.responseText);
}
});
return false;
}

Controller Method

Ajax hits this method in a controller,this method then fetching record processing this and return result in a json format. Please don’t reply me regarding this method, its perfectly showing me my database record in json format.

public JsonResult UpdateEducation( JSProfileVM vm,EducationDetail e,int?id)
{
var d = db.EducationDetails.Where(x => x.Id == id).SingleOrDefault();
//vm.GetEducation();
EducationDetail ed = new EducationDetail();
ed.DegreeTitle = d.DegreeTitle;
ed.FieldOfStudy = d.FieldOfStudy;
ed.Location = d.Location;
ed.CompletionYear = d.CompletionYear;
ed.Institution = d.Institution;
ed.Id = d.Id;
////Profile();
vm.Education = ed;
//ViewBag.Msg = "Profile Updated Successfully";
var json = JsonConvert.SerializeObject(vm);
return Json(json, JsonRequestBehavior.AllowGet);
}

The only issue is when goes to result in jquery ajax alert showing me whole data is json format and I have no idea how to show even a single record and bind this to textboxes. Please help me out.

4 Replies

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

Rijwan Ansari5y ago
Accepted answer
You can bind with input id and response as shown:

Ajax Function
function GetDetails(id) {
debugger
$.ajax({
url: "/JobSeeker/UpdateEducation/" + id,
type: "GET",
data: { "Id": id },
contentType: "application/json;charset=UTF-8",
dataType: "json",
success: function (result) {
if (result != null) {
                    $('#Degreetitle').val(result.Education.DegreeTitle);
            $('#FieldOfStudy').val(result.Education.FieldOfStudy);
                    $('#Location').val(responseresult.Education.Location);
            // like other fields
                } else {
                    alert("Something went wrong");
                }
//alert(result);
},
error: function (response) {
alert(response.responseText);
}
});
return false
}
HTML Parts
//Html samples for binding based on ID
"text" id="Degreetitle" placeholder="Degree Title" />
"text" id="FieldOfStudy"  placeholder="Field of Study" / >
"text" id="Location" placeholder="Location" />
Regards
Rijwan
+3
umair mohsin5y ago
Thanks for your endorsement to rijwan.
+2
Satya Karki5y ago
Hi,

You can bind with ID as suggested by @Rijwan.
Check this link for more details:

https://www.c-sharpcorner.com/blogs/get-the-data-from-asp-net-mvc-controller-using-jquery-ajax-and-bind-it-to-the-textbox
+3
Nitin Sontakke5y ago
I am NOT a web application development expert, but from whatever I know, you are mixing your approaches which you cannot.

So there are fixed paths for web application development and they cannot be mixed.

Given below are few examples:

Database -> ASP.NET WebAPI / WCF WebServices -> Ajax calls -> Angular / ReactJS / etc.

Database -> ASP.NET MVC

Database -> ASP.NET WebForms, etc.

Once a single request / response life cycle management system it chosen, no other management system should be interferring it with it.

For example, once you have chosen ASP.NET Web Forms, you should not change the state of controls with Ajax calls. If you do that ASP.NET Web Forms management system will be unaware of state change and will behave erratically.

Hope it helps!

I am sure someone else will reply as well.
+1