C#---ASP页面的下拉框模糊查询功能

发布时间：2020-12-15 04:45:27 所属栏目：百科来源：网络整理

导读：? div class="cnblogs_code" = = = (DataRow dataRow , > dictionary = Dictionary , > (DataColumn dataColumn 二.?加入一般处理程序，将上一步的Json字符串写入HTTP响应输出流，传到前端页面 ? Class= %> span style="color: #0000ff;"using span style="

   = ==  (DataRow dataRow <,> dictionary =  Dictionary<,> (DataColumn dataColumn

二.?加入一般处理程序，将上一步的Json字符串写入HTTP响应输出流，传到前端页面

<%@ WebHandler Language= Class= %>

using System;
using System.Web;
using SysManage;
using System.Data;
public class Xcode : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string str = context.Request["type"];
string sql = string.Format("select * from XCode where XCODE like '{0}%'",str);
Database dt = new Database();
DataTable data = dt.ExecuteSql(sql);

    context.Response.Write(Data2Json.convertJson(data));
}

</span><span style="color: #0000ff;"&gt;public</span> <span style="color: #0000ff;"&gt;bool</span><span style="color: #000000;"&gt; IsReusable
{
    </span><span style="color: #0000ff;"&gt;get</span> { <span style="color: #0000ff;"&gt;return</span> <span style="color: #0000ff;"&gt;false</span><span style="color: #000000;"&gt;; }
}

}

    <span style="background-color: #f5f5f5; color: #0000ff;"&gt;function</span><span style="background-color: #f5f5f5; color: #000000;"&gt; dataFind() {

        </span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;var</span><span style="background-color: #f5f5f5; color: #000000;"&gt; fl </span><span style="background-color: #f5f5f5; color: #000000;"&gt;=</span><span style="background-color: #f5f5f5; color: #000000;"&gt; $(</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;input[name='Rblflcode']:checked</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;).val();
        $.ajax({
            contentType: </span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;application/json</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;,url: </span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;../Xcode.ashx?type=</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span> <span style="background-color: #f5f5f5; color: #000000;"&gt;+</span><span style="background-color: #f5f5f5; color: #000000;"&gt; fl,dataType: </span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;json</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;,success: </span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;function</span><span style="background-color: #f5f5f5; color: #000000;"&gt; (msg) {
                </span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;if</span><span style="background-color: #f5f5f5; color: #000000;"&gt; (msg </span><span style="background-color: #f5f5f5; color: #000000;"&gt;==</span> <span style="background-color: #f5f5f5; color: #0000ff;"&gt;null</span><span style="background-color: #f5f5f5; color: #000000;"&gt;) {
                }
                </span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;else</span> <span style="background-color: #f5f5f5; color: #0000ff;"&gt;if</span><span style="background-color: #f5f5f5; color: #000000;"&gt; (msg </span><span style="background-color: #f5f5f5; color: #000000;"&gt;!=</span> <span style="background-color: #f5f5f5; color: #0000ff;"&gt;null</span><span style="background-color: #f5f5f5; color: #000000;"&gt;) {
                    jQuery(</span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;function</span><span style="background-color: #f5f5f5; color: #000000;"&gt; ($) {
                        $(</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;#flxzTb</span><span style="background-color: #f5f5f5; color: #000000;"&gt;"</span><span style="background-color: #f5f5f5; color: #000000;"&gt;).autocomplete(msg,{
                            minChars: </span><span style="background-color: #f5f5f5; color: #000000;"&gt;0</span><span style="background-color: #f5f5f5; color: #000000;"&gt;,autoFill: </span><span style="background-color: #f5f5f5; color: #0000ff;"&gt;false</span><span style="background-color: #f5f5f5; color: #000000;"&gt;,</span><span style="background-color: #f5f5f5; color: #008000;"&gt;//</span><span style="background-color: #f5f5f5; color: #008000;"&gt;是否选多个,用","分开</span>

mustMatch: false,//是否全匹配,如数据中没有此数据,将无法输入
 matchContains: true,//是否全文搜索,否则只是前面作为标准
 scrollHeight: 300,scroll: true,width: $("#flxzTb").width(),multiple: false,formatItem: function (row,i,max) { //显示格式
return "" + "[" + row.XCODE + "]---" + row.flmc + " ";
},formatMatch: function (row,max) { //以什么数据作为搜索关键词,可包括中文,
return row.flmc;
},formatResult: function (row) {
return row.flmc ; //返回结果
 }
});
});
}
}
});
}
</script>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!