Autocompete is not working

Question

0.00/5 (No votes)

See more:

, +

I have applied this upon an input type text, but it is not working. I need some guidance to show me where I am going wrong. This is javascript code and is not working:

JavaScript

$(document).ready(function () {
    $('#reasondescriptiontxtbox').autocomplete( {
        source: function (request, response) {
            $.ajax( {
                type: "POST",
                contentType: "application/json; charset=utf-8",
                url: "Default.aspx/getReason",
                data: "{'keywords':'" + request.term + "'}",
                dataType: "json",
                async: true,
                success: function (data) {
                    response(data.d);
                },
                error: function (result) {
                    //alert("Error");
                }
            });
        },
        minLength: 2
    });
});

code behind:

C#

[WebMethod]
public static IList<string> getReason(string keywords)
{
    int count = 0;
    IList<string> result = new List<string>();
    string constr 
        = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
    SqlConnection con1 = new SqlConnection(constr);
    SqlCommand cmd1 = con1.CreateCommand();
    cmd1.CommandText = "select distinct Code_Description from CODE_DESCRIPTION_277 where Code_Description '%" + keywords + "%'";

    try
    {
        con1.Open();
        SqlDataReader dr = cmd1.ExecuteReader();

        while (dr.Read())
        {
            count++;
            result.Add(dr["Code_Description"].ToString());

            if (count == 100)
                break;
        }

        con1.Close();

        return result;
    }
    catch
    {
        return null;
    }
}

Will I have to add some sort of jQuery file?

Posted 15-May-13 22:14pm

Qadri Jillani

Add a Solution

Comments

Madhav Hatwalne 16-May-13 4:20am

Have you added jQuery and jQuery UI files????

Qadri Jillani 16-May-13 6:07am

no if you know which file should be added so kindly let me know.thanx in advance

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jerrykid · Answer 1 · 2013-05-15T23:17:00

Solution 1

source: is a function and the return type of it must be an array, so you can try this:

C#

success: function (data) {
    return data;
},
error: function (result) {
    return [];
}

If it does not work, you can try to change

IList<string>

to

List<string>

instead.
Hope this help.

Posted 15-May-13 23:17pm

jerrykid

Updated 15-May-13 23:20pm

v2