LingerUI中3级联动的数据库.docxVIP

ligerui中3级联动的数据库例子分类：ASP.NETAJAX2011-09-29 22:092158人阅读评论(7)收藏举报在线测试例子:/example/combobox.aspx效果截图:后台数据库是sql2k,一共一张表,3级联动是通过匹配code来搞前台代码:[html]view plaincopyprint?%@ Page Language=C#AutoEventWireup=trueCodeBehind=combobox.aspx.csInherits=bobox %!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=/1999/xhtmlheadrunat=servertitle/titlelinkhref=../lib/ligerUI/skins/aqua/css/ligerui-all.cssrel=stylesheettype=text/css/scriptsrc=../lib/jquery/jquery-1.3.2.min.jstype=text/javascript/scriptscriptsrc=../lib/ligerUI/js/ligerui.min.jstype=text/javascript/scriptscriptsrc=../lib/json2.jstype=text/javascript/scriptstyletype=text/cssbody{padding:10px} .fl{float:left} /stylescripttype=text/javascriptvar cmb1,cmb2,cmb3; $(function () { cmb1=$(#cmb1).ligerComboBox({data: null, isMultiSelect: false,onSelected: function (newvalue){setdata(cmb2,/service/DataHandler.ashx?View=expcitystateid=+newvalue);}}); cmb2=$(#cmb2).ligerComboBox({data: null, isMultiSelect: false,onSelected: function (newvalue){setdata(cmb3,/service/DataHandler.ashx?View=expsubcitycityid=+newvalue);}}); cmb3=$(#cmb3).ligerComboBox({data: null, isMultiSelect: false }); setdata(cmb1,/service/DataHandler.ashx?View=expstate); //页面加载时，先加载cmb1的值}); function setdata(obj,url) { $.getJSON(url+r=+Math.round(Math.random() * 1000000).toString(), function(json) { obj.setData(json); //把json塞到下拉框里面去$(#txtjson).val(JSON2.stringify(json)); //把json转换为字符串，塞到textarea里，用到了json2.js } ); } function getid() { $.ligerDialog.success( $(#cmb1_val).val()+_+$(#cmb2_val).val()+_+$(#cmb3_val).val()+br/br/+ $(#cmb1).val()+_+$(#cmb2).val()+_+$(#cmb3).val() ); //下拉框取后台id的用法，每个ligerui的下拉框会创建一个id_val的hidden用来存放id } /script/headbodyformid=form1runat=serverdivstyle=display:inline-block;divclass=fl区域选择:/divdivclass=flinputid=cmb1//divdivclass=flinputid=cmb2//divdivclass=flinputid=cmb3//divdivclass=flstyle=padding-left:20pxinputtype=buttonclass=l-buttonvalue=获取IDstyle=width:100pxonclick=getid();//div/d