62,041
社区成员
发帖
与我相关
我的任务
分享
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" EnableScriptGlobalization="true" EnableScriptLocalization="true" >
<Services>
<asp:ServiceReference Path="~/WebService.asmx" />
</Services>
</asp:ToolkitScriptManager>
<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="ProductName"
ServicePath="WebService.asmx" ServiceMethod="GetProductList" CompletionSetCount="5"
MinimumPrefixLength="1"></asp:AutoCompleteExtender>
<asp:TextBox ID="ProductName" runat="server"></asp:TextBox>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// WebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消注释以下行。
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
public WebService()
{
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
public String[] GetProductList(string prefixText, int count)
{
string sqlcmd = string.Format("SELECT TOP {0} PRODUCTNAME FROM Basic_ProductInfo WHERE PRODUCTNAME LIKE '%" + @prefixText + "%'", @count);
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@prefixText",prefixText),
new SqlParameter("@count",count)
};
SqlConnect sqlconn = new SqlConnect();
DataTable table = sqlconn.SqlConDT(sqlcmd);
string[] arr = new string[table.Rows.Count];
if (table != null)
{
for (int i = 0; i < table.Rows.Count; i++)
{
arr[i] = table.Rows[i]["PRODUCTNAME"].ToString();
}
}
return arr;
}
}