Implement jQuery typeahead Plugin with database in ASP.Net example

Hi,

please refer below script

<script type="text/javascript">
    $(function () {
        $('.typeahead').typeahead({
            hint: true,
            highlight: true,
            minLength: 1
        },
        {
            valueKey: 'id',
            displayKey: 'id',
            source: function (query, process) {

                $.ajax({
                    url: 'Default.aspx/GetCustomers',
                    data: "{ 'prefix': '" + query + "'}",
                    dataType: "json",
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    success: function (data) {
                        objects = [];
                        var xmlDoc = $.parseXML(data.d);
                        var xml = $(xmlDoc);
                        var customers = xml.find("Table");
                        var arrayData = $.map(customers, function (item) {
                            objects.push($(item).find("CustomerID").text());
                        });
                        process(objects);
                    },
                    error: function (response) {
                        debugger;
                        alert(response.responseText);
                    },
                    failure: function (response) {
                        debugger;
                        alert(response.responseText);
                    }
                });
            },
            updater: function (item) {
                console.log(this.map[item], item);
            },
            templates: {
                suggestion: function (x) {
                    debugger;
                    console.log(x)
                }
            }
        });
    })
</script>
<div>
     <div id="the-basics">
            <input class="typeahead" type="text" />
       </div>
 </div>

C#

[WebMethod]
public static string GetCustomers(string prefix)
{
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "select ContactName, CustomerId from Customers where " +
            "ContactName like @SearchText + '%'";
    cmd.Parameters.AddWithValue("@SearchText", prefix);
    return GetData(cmd).GetXml();
}

private static DataSet GetData(SqlCommand cmd)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataSet ds = new DataSet())
            {
                sda.Fill(ds);
                return ds;
            }
        }
    }
}

and also you just use normal select query(i.e. select id,name)