学步园

JS脚本引用   

<script src="/scripts/Jquery.autocomplete/jquery.autocomplete.js" type="text/javascript"></script>

 样式引用   

<style type="text/css" media="all">
        @import url("/scripts/Jquery.autocomplete/css/jquery.autocomplete.css");
    </style>

 

JS代码

       $(document).ready(function () {
            $("#<%=_SearchKeyGame.ClientID %>").autocomplete("./AjaxHandle/AutoComplete.ashx?type=game", {
                minChars: 0,
                max: 9,
                width: 150,

                matchContains: true,
                autoFill: false,
                formatItem: function (row, i, max) {

                    return row.name;
                },

                formatMatch: function (row, i, max) {
                    return row.name + " ";
                },

                formatResult: function (row) {
                    return row.name;
                }

            });
            jQuery("#<%=_SearchKeyGame.ClientID %>").result(function (event, data, formatted) {
                if (data) {
                    jQuery("#_SearchKeyGame").attr("value", data.name);
                }
                else {

                }

            });

            $("#<%=_SearchKeyPlat.ClientID %>").autocomplete("./AjaxHandle/AutoComplete.ashx?type=plat", {
                minChars: 0,
                max: 9,
                width: 150,

                matchContains: true,
                autoFill: false,
                formatItem: function (row, i, max) {
                  
                    return  row.name;
                },

                formatMatch: function (row, i, max) {
                    return row.name + " ";
                },

                formatResult: function (row) {
                    return row.name;
                }

            });

 AutoComplete。ashx返回JOSON值

    string queryStr = context.Request.QueryString["q"];
            context.Response.ContentType = "text/plain";
            context.Response.Cache.SetNoStore();
            string jsponString = "[";
            string where = string.Format(" (select  dbo.[f_GetPy](platname)) like '%{0}%' or platname like '%{0}%'", Common.Common.ToSql(queryStr));
            DataTable dt = new Models.Plat().GetDataTable(where,10);
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    jsponString += "{id:\"" + dt.Rows[i]["PlatID"].ToString() + "\",name:\"" + dt.Rows[i]["PlatName"].ToString() + "\"},";
                }
            }
            jsponString = jsponString.Trim(new char[] { ',' });

            jsponString += "]";
            context.Response.Write(jsponString);

            context.Response.End();