尽管json成功，jquery autocomplete仍无法正常工作 [英] jquery autocomplete not working though json is success

问题描述

task1.aspx

task1.aspx

<script type="text/javascript" src="jsfiles/validation.js"></script>
    <script type="text/javascript" src="jsfiles/SearchScript.js"></script>
    <link rel="stylesheet" href="windowfiles/dhtmlwindow.css" type="text/css" />
    <script language="javascript" type="text/javascript" src="windowfiles/dhtmlwindow.js"></script>
    <link href="css/jquery-ui.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="jsfiles/jquerymin.js" language="javascript"></script>
    <script type="text/javascript" src="jsfiles/jquery-ui.min.js" language="javascript"></script>
    <link href="jquery-ui-1817/development-bundle/demos/demos.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" >

        $(function () {
            var cache = {}, lastXhr;
            $("#Grid_RouteDetailCode_ftxtLocationName").autocomplete({
                minLength: 1,

                source: function (request, response) {
                    var term = request.term;
                    if (term in cache) {
                        response(cache[term]);
                        return;
                    }

                    lastXhr = $.getJSON("GetAutoComplete.aspx?r=" + Math.random() + "&name=" + request.term, request, function (data, status, xhr) {

                        cache[term] = data;

                        if (xhr === lastXhr) {
                            response(data);
                        }
                    });
                },
                select: function (event, ui) {
                    // document.getElementById("birds").value == ui.item.id;
                    //var a = ui.item.id;
                    document.getElementById("locationroute").value = ui.item.id;
                    // document.getElementById("TextBox1").value = ui.item.id;
                    //alert(ui.item.id);
                }
            });

        });

GetAutoComplete.aspx.vb （来自以下代码让json成功）

GetAutoComplete.aspx.vb(from the below code am getting json success)

Imports System.Data, System.Data.SqlClient, System.Configuration

Partial Class GetAutoComplete
    Inherits System.Web.UI.Page
    Dim con As SqlConnection
    Dim cmd As SqlCommand
    Dim read As SqlDataReader
    Dim collected_Names As String = ""
    Dim sa As String = ConfigurationManager.ConnectionStrings("AVLS_MDT_HMS_TTK_FINALConnectionString").ToString()
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        con = New SqlConnection(sa)
        con.Open()
        Dim str_Name As String = Trim(Request.QueryString("name"))
        Dim query As String = "select  distinct(Location_Name),id from TMS_Route_Detail_Table where Location_Name like '" & str_Name & "%'"
        cmd = New SqlCommand(query, con)
        read = cmd.ExecuteReader()
        Dim shar As String = ""
        collected_Names = "["

        Do While read.Read()
            collected_Names += "{""" & "id"":""" & read(1) & """,""label"":""" & read(0).ToString().ToUpper() & """,""value"":""" & read(1) & """" & "},"
        Loop
        read.Close()
        con.Close()
        If (collected_Names.Length > 1) Then
            collected_Names = collected_Names.Remove(collected_Names.Length - 1, 1)
        End If
        collected_Names += "]"

        Response.Write(collected_Names)
    End Sub
End Class

推荐答案

（ function （）{
var cache = {}，lastXhr;

(function () { var cache = {}, lastXhr;

（ < span class =code-string>＃Grid_RouteDetailCode_ftxtLocationName）。autocomplete（{
minLength： 1 ，

source： function （request，response）{
var term = request.term;
if （在缓存中）{
response（cache [term]） ;
return ;
}

lastXhr =

("#Grid_RouteDetailCode_ftxtLocationName").autocomplete({ minLength: 1, source: function (request, response) { var term = request.term; if (term in cache) { response(cache[term]); return; } lastXhr =

.getJSON（ GetAutoComplete.aspx？r = + 数学 .random（）+ & name = + request.term，request， function （data，status，xhr）{

cache [term] = data;

if （xhr === lastXhr）{
响应（数据）;
}
}）;
}，
select： function （event，ui）{
// document.getElementById（birds）。value == ui.item.id;
/ / var a = ui.item.id;
document .getElementById（ locationroute）。value = ui.item.id;
// document.getElementById（TextBox1）。value = ui.item.id;
// alert（ui.item.id）;
}
}）;

}）;

.getJSON("GetAutoComplete.aspx?r=" + Math.random() + "&name=" + request.term, request, function (data, status, xhr) { cache[term] = data; if (xhr === lastXhr) { response(data); } }); }, select: function (event, ui) { // document.getElementById("birds").value == ui.item.id; //var a = ui.item.id; document.getElementById("locationroute").value = ui.item.id; // document.getElementById("TextBox1").value = ui.item.id; //alert(ui.item.id); } }); });

GetAutoComplete.aspx.vb （来自以下代码让json成功）

GetAutoComplete.aspx.vb(from the below code am getting json success)

Imports System.Data, System.Data.SqlClient, System.Configuration

Partial Class GetAutoComplete
    Inherits System.Web.UI.Page
    Dim con As SqlConnection
    Dim cmd As SqlCommand
    Dim read As SqlDataReader
    Dim collected_Names As String = ""
    Dim sa As String = ConfigurationManager.ConnectionStrings("AVLS_MDT_HMS_TTK_FINALConnectionString").ToString()
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        con = New SqlConnection(sa)
        con.Open()
        Dim str_Name As String = Trim(Request.QueryString("name"))
        Dim query As String = "select  distinct(Location_Name),id from TMS_Route_Detail_Table where Location_Name like '" & str_Name & "%'"
        cmd = New SqlCommand(query, con)
        read = cmd.ExecuteReader()
        Dim shar As String = ""
        collected_Names = "["

        Do While read.Read()
            collected_Names += "{""" & "id"":""" & read(1) & """,""label"":""" & read(0).ToString().ToUpper() & """,""value"":""" & read(1) & """" & "},"
        Loop
        read.Close()
        con.Close()
        If (collected_Names.Length > 1) Then
            collected_Names = collected_Names.Remove(collected_Names.Length - 1, 1)
        End If
        collected_Names += "]"

        Response.Write(collected_Names)
    End Sub
End Class

这篇关于尽管json成功，jquery autocomplete仍无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！