CREATE TABLE [dbo].[empMaster] ( [empcode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [empname] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO
using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Linq;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Xml.Linq;using System.Data.SqlClient;using System.Collections.Generic;/// /// Summary description for AutoSuggest/// [WebService(Namespace = "http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. [System.Web.Script.Services.ScriptService]public class AutoSuggest : System.Web.Services.WebService{ [WebMethod] public string[] GetEmployeeList(string prefixText) { strQuery="select empcode,empname from empMaster"; SqlDataReader rdrSql; rdrSql=SqlHelper.ExecuteReader(strConn,CommandType.Text,strQuery); while (rdrSql.Read()) { String vempid=rdrSql.GetString(0); String vEmpid=rdrSql.GetString(1); string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem("Emp Name : " + vempname + " - Emp code : " + vEmpid, vEmpid); names.Add(item); } return names.ToArray(); } }
ScriptManager ID="ScriptManager1" runat="server" > ServiceReference Path="AutoSuggest.asmx" /> b) Add a label and name as lblEmpCode Label ID="lblEmpCode" runat="server"> c) Add javaScript tag. Add the function below: function GetCode(source, eventArgs ){ var textval=eventArgs.get_text(); var temp = new Array(); temp = textval.split('-'); var temp1=new Array(); temp1=temp[0].split(':'); var txtval=temp1[1]; //alert(txtval); var txtNameEl=document.getElementById("txtEmpName"); var elMyElement = document.getElementById("lblEmpCode"); elMyElement.innerHTML= eventArgs.get_value(); txtNameEl.innerText=txtval.trim(); }
AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" TargetControlID="txtEmpName" ServiceMethod="GetEmployeeList" ServicePath= "AutoSuggest.asmx" CompletionInterval="1" EnableCaching="true" CompletionSetCount="10" OnClientItemSelected="GetCode">