Ajax自动提示小细节

最新推荐文章于 2021-08-06 22:23:28 发布

原创最新推荐文章于 2021-08-06 22:23:28 发布 · 243 阅读

CC 4.0 BY-SA版权

1.页面：

<asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
            MinimumPrefixLength="1" ServiceMethod="GetCompletionList"
            ServicePath="~/WebService.asmx" TargetControlID="TextBox1"
            UseContextKey="True" CompletionSetCount="5">
        </cc1:AutoCompleteExtender>

2.webService

//若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
    [WebMethod]
    public string[] GetCompletionList(string prefixText)
    {
        List<string> ss=new List<string>();
        DataTable dt = AboutDB.getDt(prefixText);
        for (int i = 0; i < dt.Rows.Count;i++ )
        {
            ss.Add(dt.Rows[i][2].ToString());
        }
        return ss.ToArray();
    }

3.DAL

namespace DAL
{
    public class AboutDB
    {
        public static DataTable getDt(string str)
        {
            string sql = "select * from tbl_consign where V_CompName like @V_CompName ";
            SqlParameter[] parameters = {
     new SqlParameter("@V_CompName", "%"+str+"%")
            };
            DataTable dt= SQLHelper.Query(sql,parameters).Tables[0];
            return dt;
        }
    }