set value in mvc view.

5y805Learn iOS Programming

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

3 Replies

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

Sachin Singh5y ago
Accepted 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);
}
0
Mageshwaran R5y ago
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>Indexh2>

    <p>
        @Html.ActionLink("Create New", "Create")
    p>
    <table class="table">
        <tr>

            <th>FirstNameth>
        <th>LastNameth>
        <th>Ageth>
        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>
0
Asma Khalid5y ago
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
0