JQuery下拉框模糊查询

1、2012-04-1014:24C#+jQuery+div实现下拉框信息提示模糊搜索结果（百度、google搜索提示框）实现效果：用户输入查询字符串，当文本框内容变化时，显示下拉框为用户提示完整信息，并可以实现选中所查信息后获得对应ID而进行更进一步的关联显示。（比如搜某一公司，选中公司后在根据公司ID获得公司产品）。推荐jQueryAutocomplete插件：（演示地址）http:/jquery.bassistance.de/autocomplete/demo/?主人博客：http:/bassistance.de/（还有好多有用的Plugins）手动实现：在输入框所在的页面：引入jquery

2、开发包：样式及脚本bodyfont:11pxarial;.suggest_link_altbackground-color:#FFFFFF;text-align:right;cursor:hand;padding:2px6px2px6px;z-index:101;.suggest_linkbackground-color:#FFFFFF;padding:2px6px2px6px;z-index:101;.suggest_link_overbackground-color:#E8F2FE;padding:2px6px2px6px;z-index:101;#search_suggestz-inde

3、x:100;position:absolute;background-color:#FFFFFF;text-align:left;border:1pxsolid#000000;#search_suggestRz-index:100;position:absolute;background-color:#FFFFFF;text-align:left;border:1pxsolid#000000;/*input*/.input_onmargin:2px8px0pt10px;height:18px;border:1pxsolid#999;background-color:#FFFFCC;.input

4、_offmargin:2px8px0pt10px;height:18px;border:1pxsolid#CCC;background-color:#FFF;.input_movemargin:2px8px0pt10px;height:18px;border:1pxsolid#999;background-color:#FFFFCC;.input_out/*height:16px;默认高度*/margin:2px8px0pt10px;height:18px;border:1pxsolid#CCC;background-color:#FFF;functionDivSetVisible(divid

5、,frameid,state)varDivRef=document.getElementById(divid);varIfrRef=document.getElementById(frameid);if(state)DivRef.style.display=block;IfrRef.style.width=DivRef.offsetWidth;IfrRef.style.height=DivRef.offsetHeight;IfrRef.style.top=DivRef.style.top;IfrRef.style.left=DivRef.style.left;IfrRef.style.zInd

6、ex=DivRef.style.zIndex-1;IfrRef.style.display=block;elseDivRef.style.display=none;IfrRef.style.display=none;/当输入框的内容变化时，调用该函数functionsearchSuggest()if($(#txtSearch).val()!=&$(#txtSearch).val()!=null)$.ajax(type:GET,url:././AJAX.aspx,data:type=searchCompany&searchText=+escape($(#txtSearch).val(),succ

7、ess:function(result)varsourceText=result.split(*);if(sourceText.length1)DivSetVisible(search_suggest,DivShim,true);/$(#search_suggest).show();$(#search_suggest).html();for(vari=0;isourceText.length-1;i+)vars=+sourceTexti.split(,)1+;$(#search_suggest).html($(#search_suggest).html()+s);$(#search_sugge

8、st).html($(#search_suggest).html()+关闭提示/div);elseDivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide(););elseDivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide();functionsuggestOver(div_value)div_value.className=suggest_link_over;functionsuggestOut(div_value)div_va

9、lue.className=suggest_link;functionsetSearch(obj,id)$(#txtSearch).val(obj);$(#hidCompId).val(id);$.ajax(type:GET,url:././AJAX.aspx,data:type=getCompanyJob&companyId=+id,success:function(result)$(#drpPost).empty();varsourceText=result.split(*);if(sourceText.length1)for(vari=0;isourceText.length-1;i+)

10、$(+sourceTexti.split(,)1+).appendTo(#drpPost);$(#search_suggest).html();DivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide();HTML:/r*1TCl,r*1IIAJAX.aspx实现：AJAX.aspx.cs:stringsearchText=RequestsearchText;StringBuilderresult=newStringBuilder(100);if(!string.IsNullOrEmpty(searchText)SqlDataReaderdr=null;trydr=SqlHelper.ExecuteReader(SqlHelper.ConnectionString,CommandType.Text,selecttop20Identifier,CompanyfromUserInfowherecompanylike%+keywords+%,newSqlParameter(keywords,sea