set value in mvc view.

Question

Retrieve (Display) data from Database in TextBoxes in ASP.Net MVC

Sachin Singh · Answer

use ajax and on success fill all your inputs. $.ajax({ type: "post" , url: "/home/Edit" , dataType: "json" , contentType: "application/json;charset=utf-8" , data: {Id:userId}, traditional: true , cache: false , success:function(data){ $( "#txtName" ).val(data.Name); and so on } }) public ActionResult Edit( int Id) { var user= _context.Users.Where(x=>x.Id==Id).SingleOrDefault(); return Json(user, JsonRequestBehaviour.Allowget); }

Mageshwaran R · Answer

Hi Sourabh, try this code, Controller: private ApplicationDbContext db = new ApplicationDbContext(); public ActionResult Index() { return View(db.PersonalDetails.ToList()); //Get database Values } View: @model IEnumerable webapplication1.models.personaldetail > @{ ViewBag.Title = "Index" ; } h2 > Index h2 > p > @Html.ActionLink("Create New", "Create") p > table class = "table" > tr > th > FirstName th > th > LastName th > th > Age th > tr > @foreach (var item in Model) { tr > td > @Html.TextBoxFor( modelItem = > item.FirstName) td > td > @Html.TextBoxFor( modelItem = > item.LastName) td > td > @Html.TextBoxFor( modelItem = > item.Age) td > tr > } table >

Asma Khalid · Answer

Load the require textbox value into the view model property attach to it from the database. Your value will be loaded into the textbox. You can look into https://bit.ly/2YqZWzO for loading data from database into view model. Thanks & Regards, Asma Khalid