完成文本框自动完成示例 – 从数据库获取数据

本文关键字：数据库 获取 数据 文本 | 更新日期: 2023-09-27 17:56:41

我正在尝试自动完成一个带有数据库中名称的文本框。当我在文本框运行时输入时，没有任何反应。我一直在遵循本教程，但无法让它工作。http://www.dotnetodyssey.com/2015/01/14/autocomplete-textbox-using-jquery-asp-net-querying-database-complete-example/

源代码如下。Aspx 页面：

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
   <script type="text/javascript" src="jquery-1.11.2.min.js"></script>
<script type="text/javascript" src="jquery-ui.min.js"></script>
<link href="jquery-ui.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript">
    $(document).ready(function () {
        $("#txtNames").autocomplete({
            source: function (request, response) {
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "WebForm1.aspx/GetNames",
                    data: "{'namePrefix':'" + $("#txtNames").val() + "'}",
                    dataType: "json",
                    minLength: 2,
                    success: function (data) {
                        response(data.d)
                    },
                    error: function (response) {
                        alert("Error" + res.responseText);
                    }
                });
            }
        });
    });
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <label for="txtNames">Names:</label>
<asp:TextBox ID="txtNames" runat="server"></asp:TextBox>
    </div>
    </form>
</body>

</html>

背后的代码： 

 [WebMethod]
        public static string[] GetNames(string namePrefix)
        {
            List<string> Name = new List<string>();
            DataTable dtNames = new DataTable();
            string sqlQuery = "select distinct Name from Houses where Name like '" + namePrefix + "%'";
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            try
            {
                SqlConnection conn = new SqlConnection(connectionString);
                SqlDataAdapter da = new SqlDataAdapter(sqlQuery, conn);
                da.Fill(dtNames);
                foreach (DataRow row in dtNames.Rows)
                {
                    string name = Convert.ToString(row["Name"]);
                    Name.Add(name);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return Name.ToArray<string>();
        }

完成文本框自动完成示例 – 从数据库获取数据

下面是自动完成文本框的示例：

 private void LoadServices()
    {
        txtServiceName.AutoCompleteMode = AutoCompleteMode.Suggest;
        txtServiceName.AutoCompleteSource = AutoCompleteSource.CustomSource;
        txtServiceName.AutoCompleteCustomSource = colValues;
    }

和：

AutoCompleteStringCollection colValues = new AutoCompleteStringCollection();
    private void GetAllServices()
    {
        // get list of Windows services
        ServiceController[] services = ServiceController.GetServices();
        List<string> ac = new List<string>();
        // try to find service name
        foreach (ServiceController service in services)
        {
            ac.Add(service.ServiceName.ToString());
        }
        colValues.AddRange(ac.ToArray());
    }
相关文章：