Auto complete Textbox in asp.net using ajax and c#

This is my aspx File

<asp:ImageButton ID="frumgrp_srch_imgbtn" runat="server" ImageUrl="~/images/search.png" />
                    &nbsp;&nbsp;&nbsp;&nbsp;<br />
                    <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="frumgrp_srch_txt"
                                 EnableCaching="true"
       BehaviorID="AutoCompleteCities"
       ServiceMethod="GetCities" ServicePath="~/AutoComplete.asmx"  MinimumPrefixLength="1"      CompletionSetCount="5"
        FirstRowSelected="true">
        </asp:AutoCompleteExtender>

This Is My Cs File

using System;
using System;
using System.Collections.Generic;
using System.Web.Services;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

[WebService]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class AutoComplete : WebService
{
    public AutoComplete()
    {
    }

    [WebMethod]
    public string[] GetCompletionList(string prefixText, int count)
    {
        if (count == 0)
        {
            count = 10;
        }
        DataTable dt = GetRecords(prefixText);
        List<string> items = new List<string>(count);

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            string strName = dt.Rows[i][0].ToString();
            items.Add(strName);
        }
        return items.ToArray();
    }

    public DataTable GetRecords(string strName)
    {
        string strConn = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;
        SqlConnection con = new SqlConnection(strConn);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandType = System.Data.CommandType.Text;
        cmd.Parameters.AddWithValue("@Name", strName);
        cmd.CommandText = "Select Name from Test where Name like '%'+@Name+'%'";
        DataSet objDs = new DataSet();
        SqlDataAdapter dAdapter = new SqlDataAdapter();
        dAdapter.SelectCommand = cmd;
        con.Open();
        dAdapter.Fill(objDs);
        con.Close();
        return objDs.Tables[0];





    }
}

This is My asmx File
<![CDATA[<%@ WebService Language="C#" CodeBehind="~/App_Code/AutoComplete.cs" Class="AutoComplete" %>

I'm not able to execute this code. Infact the webservice it self is not getting called. Can Anyone help. Your help will be a great relief to me.
Eagerly Waiting For The Solution
Thanks in advance

I Know you already got the answer from all previous posts,
But here am providing you easy way to know about the Ajax Autocomplete control

Videos:

www.youtube.com/watch?v=2i50R-fHHlA[^]
www.youtube.com/watch?v=nYac4sxChdk[^]


Thanks
--RA

AutoComplete With DataBase and AjaxControlToolkit[^]
asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete[^]

You can either use XMLHttpRequest or using AJAX controls.

Below are demo for AJAX control AutoCompleteExtender:

Using Ajax AutoCompleteExtender for autosuggest[^]

XMLHTTPRequest:

Google-Like-Search-TextBox

Please refer:
AutoComplete With DataBase and AjaxControlToolkit[^]
Using Ajax AutoCompleteExtender for autosuggest[^]
ASP.Net AJAX Control Toolkit AutoCompleteExtender without using Web Services[^]

AutoComplete Demonstration[^]

Visit The Following link you will be getting your problem solutions.Using Ajax AutoCompleteExtender for autosuggest[^]

Autucomplete without using web service It should help you.-->Test.aspx(html code)

<form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
    </asp:ScriptManager>
    <div>
    <table>
        <tr>
            <td>
            <asp:TextBox ID="txtContactsSearch" runat="server"></asp:TextBox>
                <asp:AutoCompleteExtender ID="txtContactsSearch_AutoCompleteExtender"
                    runat="server" ServiceMethod="Getdata"  MinimumPrefixLength="1" CompletionInterval="1000"
                    EnableCaching="true" CompletionSetCount="1"
                    TargetControlID="txtContactsSearch" UseContextKey="True" >
                    </asp:AutoCompleteExtender>
            </td>
        </tr>
    </table>
    </div>
    </form>

Code behind -->Test.aspx.cs

[System.Web.Services.WebMethodAttribute(),System.Web.Script.Services.ScriptMethodAttribute()]
    public static List<string>  Getdata(string prefixText, int count, string contextKey)
    {
       //Make your database connection here
       string strSQL = "SELECT * FROM YourTable WHERE coloumnName Like '" + prefixText + "%'";
       //Get data in datatable 

        List<String> list = new List<String>();
        foreach(DataRow dr in dataTable.Rows)
        {
            list.Add(dr["coloumnName "].ToString());
        }
        return list;
    }

You can use XMLHttpRequest object[^]
also,
You can use jQuery for same.
Plugins/Autocomplete[^]
UI/API/1.8/Autocomplete[^]

Use this link for the solution http://www.dotnetfunda.com/articles/article224.aspx. and just replace the Script Manager tool with Tool Script Manager. Enjoy The Output......May be u have to change the like Clause also if needed in my case i used it as '+@Name+'

Hi

Make sure that the function / or Service method lies in Aspx page, not in a control of course.