62,074
社区成员
发帖
与我相关
我的任务
分享
<%@ Register
Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxtool" %>
<body>
<form id="form1" runat="server">
<ajaxtool:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/BackStage/City.asmx" />
</Services>
</ajaxtool:ToolkitScriptManager>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<ajaxtool:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1" CompletionSetCount="12" ServiceMethod="GetCompleteList" ServicePath="City.asmx" MinimumPrefixLength="1">
</ajaxtool:AutoCompleteExtender>
</form>
</body>
/// <summary>
/// CityData1 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
[System.Web.Script.Services.ScriptService]
public class City : System.Web.Services.WebService
{
public City()
{ }
A380lines.BLL.CityData bll_city = new BLL.CityData();
[WebMethod]
[System.Web.Script.Services.ScriptMethod]
public string [] GetCompleteList(string prefixText,int count)
{
List<string> items = new List<string>(count);
DataSet ds = A380lines.SQLServerDAL.DbHelperSQL.Query("select top "+count+" cnname from citydata where cnname like '"+prefixText+"% ' group by cnname order by cnname");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
items.Add(ds.Tables[0].Rows[i]["cnname"].ToString());
}
}
return items.ToArray();
}
}