ASP.NET搜索框自动补全实现-优快云博客

本文链接：https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/20641115

A。前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="search.aspx.cs" Inherits="考试试题管理系统.search" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

B WebService1.asmx代码

[WebMethod]
        public string [] hello(string prefixText, int count)
        {
       SqlConnection conn = new SqlConnection(" server=8KQCDK6WIOTOHDM\\SQLEXPRESS; integrated security=true ;database=master");
       SqlDataAdapter sda = new SqlDataAdapter("select * from test where name like '" + prefixText + "%' ", conn);
            DataTable dt = new DataTable();
            sda.Fill(dt);

            List<String> list = new List<String>();
            foreach (DataRow item in dt.Rows)
            {
                list.Add(item["name"].ToString());
            }
            return list.ToArray();

}
}
}

AJAX查询