三级联动

1、三个下载列表框，按顺序一级——二级——三级
<asp:dropdownlist id="DDL_Root" runat="server"></asp:dropdownlist>
<asp:dropdownlist id="DDL_Trunk" runat="server"></asp:dropdownlist>
<asp:dropdownlist id="DDL_Leaf" runat="server"></asp:dropdownlist>

2、绑定第一个
//给一级、二级添加单击事件
DDL_Root.Attributes.Add("onchange","load(this.options[this.selectedIndex].value,'DDL_Trunk','DDL_Leaf')");

DDL_Trunk.Attributes.Add("onchange","load(this.options[this.selectedIndex].value,'DDL_Leaf','')");
//绑定第一个控件
if(Ds==null)
{
SqlDataAdapter APP_Ada=new SqlDataAdapter("Psp_ShowPopedomMenu "+Request.Cookies["AdminId"].Value,APP_SqlDb.SqlConn);
Ds=new DataSet("Menu");
APP_Ada.Fill(Ds,"Tree");
}
DataView Dv=Ds.Tables["Tree"].DefaultView;
Dv.RowFilter="i_ParentCode=0";
DDL_Root.DataSource=Dv;
DDL_Root.DataTextField="vc_TreeName";
DDL_Root.DataValueField="i_Id";
DDL_Root.DataBind();

//隐藏二级、三级控件
Td_Message.InnerHtml="<Script language=\"JavaScript\">document.getElementById(\"DDL_Trunk\").style.display=\"none\";document.getElementById(\"DDL_Leaf\").style.display=\"none\";";
//初始化一级控件的单击事件
Td_Message.InnerHtml+="load（"+DDL_Root.SelectedValue+",'DDL_Trunk','DDL_Leaf');</Script>";

3、JavaScript的函数
function load(state,obj,str)
{
var drp2=document.getElementById(obj);
if(drp2!=null)
{
var count=drp2.length;
alert(state);
for(var i = drp2.options.length;i>=0 ;i--)//清楚现有列表项
　{　
　drp2.remove(i);
　}　
var oHttpReq = new ActiveXObject("MSXML2.XMLHTTP");
var oDoc = new ActiveXObject("MSXML2.DOMDocument");
oHttpReq.open("POST", "DDLSelect.aspx?state="+escape(state), false);
oHttpReq.send("");
result = oHttpReq.responseText;
alert(result);
oDoc.loadXML(result);

return false;
items1 = oDoc.selectNodes("//CITY/Table/i_Id"); //读取所有请求大类所属小类的类名
items2 = oDoc.selectNodes("//CITY/Table/vc_TreeName"); //读取所有请求大类所属小类的编号
var itemsLength=items1.length;
if(itemsLength!=0)
{
var newvalue="";
drp2.style.display="";
for(i=0;i<itemsLength;i++) //将小类的类名和编号赋予DropDownList2 <BR>{ <BR>var newOption =

{
var newOption = document.createElement("OPTION");
newOption.value = items1[i].text;//cityId;
newOption.text = items2[i].text;//cityName;
drp2.options.add(newOption);
if(i==0)
newvalue=newOption.value;

}
if(str!="")
load(newvalue,str,"");

}
else
{
drp2.style.display="none";
if(str!="")
document.getElementById(str).style.display="none";
}
}
}
4、动态读取页面

if(this.Request["state"]!=null)
{
Response.Clear();
DataSet ds;

//ds=ArtPaper.Ds;

//if(ds==null)
{
ds=new DataSet("Menu");
Sql.TSqlDB APP_SqlDb=new Sql.TSqlDB("DBsmehen");
SqlDataAdapter APP_Ada=new SqlDataAdapter("Psp_ShowPopedomMenu "+Request.Cookies["AdminId"].Value+","+Request["state"],APP_SqlDb.SqlConn);
APP_Ada.Fill(ds,"Tree");
APP_SqlDb.Dispose();
}

XmlTextWriter writer = new XmlTextWriter(Response.OutputStream,System.Text.Encoding.UTF8);// Response.ContentEncoding);

writer.Formatting = Formatting.Indented;
writer.Indentation = 4;
writer.IndentChar = ' ';
ds.WriteXml(writer);
writer.Flush();
writer.Close();
ds.Dispose();

Response.End();
}

转载于:https://www.cnblogs.com/nosnowwolf/articles/439531.html