How to implement Autocomplete Extender textbox using database

<form id="form1" runat="server">

    <div align="center" id="ID1" runat="server" style="color: gray">

     <asp:ScriptManager ID="ScriptManager1" runat="server">

        <Services>

        <asp:ServiceReference Path="Web Service/AutoComplete.asmx" />

        </Services>

        </asp:ScriptManager>

    <h2 class="header2" align="Center">Person Details</h2>

    <script type="text/javascript" language="javascript">

    $("h2.header2").html("Background:color:Green);

    </script>

     <br />              

    <table class="table" align="center">

    <tr>

    <td class="td">

    <asp:Label ID="EmpId" runat="server" Text="Id" CssClass="controls"></asp:Label>

    </td>

    <td><asp:Label ID="lblId" runat="server"></asp:Label></td>

    </tr>

    <tr>

    <td class="td"><asp:Label ID="lblName" Text="Person Name" runat="server" CssClass="controls"></asp:Label></td>

    <td>

    <asp:TextBox ID="txtName" runat="server" onClick="validateName(this)"></asp:TextBox>

    <cc1:AutoCompleteExtender DelimiterCharacters=";, " CompletionListCssClass="autoComplete_CompletionListElement" 

    CompletionListItemCssClass="autoComplete_ListItem"  CompletionListHighlightedItemCssClass="autoComplete_HighLightedItem" OnClientPopulating="ShowIcon"

      ID="AutoCompleteExtenderText1" MinimumPrefixLength="1" runat="server" TargetControlID="txtName"

       ServiceMethod="GetNamesList" ServicePath="Web Service/AutoComplete.asmx" EnableCaching="true" CompletionInterval="1000">

    </cc1:AutoCompleteExtender>

    </td>

    </tr>

   </table>



Create a WebMethod in Web Service 



[WebMethod]

    public string[] GetNamesList(string prefixText, int count)

    {

        if (count == 0)

        {

            count = 10;

        }

        DataTable dt = GetNames(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();

    }

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Join Hands Change lives
Thanks & Regards
Straight Edge Society