基于jquery的文本框与autocomplete结合使用(asp.net+json)
发布时间:2020-12-14 23:55:53 所属栏目:C语言 来源:网络整理
导读: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.
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,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", 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(); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |