Predictive search isn't working?

Question

4.00/5 (1 vote)

See more:

This is aspx file code.

XML

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head id="Head1" runat="server">
    <title>AutoComplete Box with jQuery</title>
    <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            SearchText();
        });
        function SearchText() {
            $(".autosuggest").autocomplete({
                source: function (request, response) {
                    $.ajax({
                        type: "POST",
                        contentType: "application/json; charset=utf-8",
                        url: "Default.aspx/GetAutoCompleteData",
                        data: "{'username':'" + document.getElementById('txtSearch').value + "'}",
                        dataType: "json",
                        success: function (data) {
                            response(data.d);
                        },
                        error: function (result) {
                            alert("Error");
                        }
                    });
                }
            });
        }
    </script>
    </head>
    <body>
    <form id="form1" runat="server">
    <div class="demo"></div>
    <div class="ui-widget">
    <label for="tbAuto">Enter UserName: </label>
    <input type="text" id="txtSearch" class="autosuggest" />
    </div>
    </form>
    </body>
    </html>

This is .cs file code.

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Data.SqlClient;
    using System.Data;
    using System.Web.Services;

    public partial class demo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
         public static string getconnectionstring()
        {
            return System.Configuration.ConfigurationManager.ConnectionStrings[&quot;crudconnection&quot;].ConnectionString;
        }
        public static List&lt;string&gt; GetAutoCompleteData(string username)
        {
            List&lt;string&gt; result = new List&lt;string&gt;();
            SqlConnection con = new SqlConnection(getconnectionstring();

                using (SqlCommand cmd = new SqlCommand(&quot;select DISTINCT username from crudtable where username LIKE &#39;%&#39;+@SearchText+&#39;%&#39;&quot;, con))
                {
                    con.Open();
                    cmd.Parameters.AddWithValue(&quot;@SearchText&quot;, username);
                    SqlDataReader dr = cmd.ExecuteReader();
                    while (dr.Read())
                    {
                        result.Add(dr[&quot;username&quot;].ToString());
                    }
                    return result;
                }

        }
    }

The database "crud" has "crudtable" with columns (username,firstname,lastname,address,id).When i type anything in the textbox and pres button the ,Search isn't working.
Everything seems to be right but don't know where is the error.

Help friends.Thanks

Posted 3-Aug-12 21:56pm

Member 9326644

Updated 3-Aug-12 21:59pm

Sebastian T Xavier

v2

Add a Solution

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)

Christian Graus · Answer 1 · 2012-08-03T22:12:00

Default.aspx/GetAutoCompleteData" - does this look like a valid URL to you ? It doesn't to me.

If you want help, you need to tell us, what is not working ? What happens when you try to use it ? What have you done to debug it ? Is an AJAX call happening on the server ? Is it being made on the client ? Is your error message showing ? If so, have you changed it to show the actual error ?