AutoCompleteExtender

一  写在WebService里
<cc1:autocompleteextender id="AutoCompleteExtender1" runat="server" TargetControlID="TextBoxEnterpriseName" ServiceMethod="GetCompletionListEnterpriseName" MinimumPrefixLength="2" CompletionInterval="1000" EnableCaching="true" CompletionSetCount="15" ServicePath="ZhWebService.asmx">
</cc1:autocompleteextender>
<asp:textbox id="TextBoxEnterpriseName" runat="server"></asp:textbox>

using System;
using System.Web.Services;
using System.Data;
using System.Collections.Generic;
using System.Web.UI.WebControls;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class ZhWebService : WebService
{
    public ZhWebService()
    {

    }

    //获得企业名称
    [WebMethod]
    public string[] GetCompletionListEnterpriseName(string prefixText, int count)
    {
        if (count == 0)
        {
            count = 15;
        }
        string strSql = "select _qymc from P_Eng_qyjbxxb where _qymc like '" + prefixText + "%'";
        DataSet myDataSet = Utility.DbHelperSQL.Query(strSql);
        List<string> items = new List<string>(count);
        for (int i = 0; i < myDataSet.Tables[0].Rows.Count; i++)
        {
            items.Add(myDataSet.Tables[0].Rows[i][0].ToString());
        }
        return items.ToArray();
    }
}