I work on asp.net mvc auto complete project .I face issue I can't display EmployeeName on input text Id LineManagerName when change auto complete employeeId
list of employeeid auto complete display success but I can't get employeename for selected employee id on input text LineManagerName
code working success and auto complete working perfect only need to display Employee Name when employeeId changed
@Html.EditorFor(model => model.LineManager, new { htmlAttributes = new { @class = "form-control", id = "txtLineManagerId" } }) <input type="text" id="LineManagerName" class="form-control" /> public ActionResult GetAllEmployeeBasedSearchText(string searchText) { JDEUtility jde = new JDEUtility(); List<object> employeeListCriteria = new List<object>(); employeeListCriteria = jde.GetAllEmployeeBasedSearchText(searchText); return Json(employeeListCriteria, JsonRequestBehavior.AllowGet); } public static List<object> GetAllEmployeeBasedSearchText(string searchText) { OleDbConnection con = new OleDbConnection(connectionString); string query = ""; query = "SELECT cast(EMP.YAAN8 as varchar(20)) as EmployeeID,EMP.YAALPH AS EmployeeName FROM CRPDTA.F060116 EMP WHERE cast(EMP.YAAN8 as varchar(20)) LIKE '%" + searchText + "%' WITH UR"; List<object> ApplicationsDataValues = new List<object>(); try { using (var command = con.CreateCommand()) { command.CommandText = query; command.CommandType = CommandType.Text; command.Connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { ApplicationsDataValues.Add(new { EmployeeID = reader.GetFieldValue<string>(0) }); } reader.Close(); } } con.Close(); return ApplicationsDataValues; } catch (Exception e) { return new List<object>(); } } $(document).ready(function () { $("#txtLineManagerId").autocomplete({ source: function (request, response) { var searchText = $("#txtLineManagerId").val(); console.log("search text" + searchText) $.ajax({ url: '@Url.Action("GetAllEmployeeBasedSearchText", "Resignation")', data: { searchText: searchText }, method: "GET", dataType: "json", success: function (data) { response($.map(data, function (item) { console.log("data is" + item.EmployeeID); return { label: item.EmployeeID, value: item.EmployeeID }; })) } }); } }); });