DESIGN THE PAGE LIKE THIS :
<form id="form1" runat="server">
<asp:ScriptManager ID="sm" runat="server"></asp:ScriptManager>
<div>
<center>
<asp:TextBox ID="tb" runat="server"></asp:TextBox><asp:AutoCompleteExtender ID="AutoCompleteExtender1" TargetControlID="tb" CompletionSetCount="12" CompletionInterval="1" MinimumPrefixLength="2" ServicePath="~/WebService.asmx" ServiceMethod="x"
runat="server">
</asp:AutoCompleteExtender>
</center>
</div>
</form>
WEBSERVICE CODE :
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
DataClassesDataContext o = new DataClassesDataContext(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString());
int i;
[WebMethod]
public string[] x(string prefixText)
{
i = 0;
var m = from y in o.EMPs where y.NAME.StartsWith(prefixText) select y;
string[] s = new string[m.Count()];
foreach (var n in m)
{
s[i] = n.NAME;
i++;
}
return s;
}
}
<form id="form1" runat="server">
<asp:ScriptManager ID="sm" runat="server"></asp:ScriptManager>
<div>
<center>
<asp:TextBox ID="tb" runat="server"></asp:TextBox><asp:AutoCompleteExtender ID="AutoCompleteExtender1" TargetControlID="tb" CompletionSetCount="12" CompletionInterval="1" MinimumPrefixLength="2" ServicePath="~/WebService.asmx" ServiceMethod="x"
runat="server">
</asp:AutoCompleteExtender>
</center>
</div>
</form>
WEBSERVICE CODE :
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
DataClassesDataContext o = new DataClassesDataContext(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString());
int i;
[WebMethod]
public string[] x(string prefixText)
{
i = 0;
var m = from y in o.EMPs where y.NAME.StartsWith(prefixText) select y;
string[] s = new string[m.Count()];
foreach (var n in m)
{
s[i] = n.NAME;
i++;
}
return s;
}
}
No comments:
Post a Comment