display search result in textbox in mvc3

Question

I want to search a specific record and fill textboxes of mvc3 by searched result...
I'm using MVC Razor view Engine and unable to fill textboxes of the MVC3 by searched result generated from the database(sql Server 2008)

Thank's

With Regards

Pradeep Patel (Pune)

Pradeep Patel · Answer

Finally I've done by my own

Pradeep Patel · Answer

This is a Controller else if (b1.Equals("Search")) { con.Open(); try { cmd = new SqlCommand("sp_SearchEmpById"); cmd.Parameters.AddWithValue("@id", e1.Id); cmd.CommandType = CommandType.StoredProcedure; dr=DataAccessLayer.FetchSpRecords(cmd); if (dr.Read()) { EmpModel Model = new EmpModel(); Model.Name = dr["Name"].ToString(); Model.Address = dr["Address"].ToString(); return View(Model); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { con.Close(); } } This is my View @model MvcApplication2.Models.EmpModel @{ ViewBag.Title = "Add Employees"; //var grid = new WebGrid(source: Model, defaultSort: "Id", rowsPerPage: 3); } Add Emp Records @ViewBag.Message @using (Html.BeginForm("AddEmp", "Home", FormMethod.Post)) { Id: @Html.TextBoxFor(e=>e.Id) Name: @Html.TextBoxFor(e => e.Name,(SelectList)ViewBag.Name) Address: @Html.TextBoxFor(e => e.Address) } My controller fetches records properly but I'm unable to fill fetched records in textbox es.. Please check above code ...

Jaganathan Bantheswaran · Answer

I could not find any image attached. anyway, on button click you can do an ajax call to the search action and success fucntion you can update the textbox. $('#btnSearch').on('click', function(){ $.ajax({ url: "@(Url.Action("Action", "Controller"))", type: "POST", data: { id: $('#empID').val()}, cache: false, async: true, success: function (result) { // fill text box here } }); });

Pradeep Patel · Answer

Question is related with MVC3 with razor view engine.. I've uploaded an image wherein Emp Id textbox have to enter an Eemp Id like Emp101 and if i click on search button It should search a record and if record is available then all textboxes of related record should be fill out. Please view uploaded Image first.. I don't know how to code for searching in MVC3 Thanx And Regards Pradeep Patel 8483094947

Jaganathan Bantheswaran · Answer

Can you show us the code? How & where & when you are filling the textboxes?