1<title>WebForm2</title>
1<script language="javascript">
2function load(){
3var drp2 = document.getElementById("DropDownList2");
4drp2.innerText="";
5for(var i = 0;i<=drp2.options.length -1;i++){
6drp2.remove(i);
7}
8var drp3 = document.getElementById("DropDownList3");
9for(var i = 0;i<=drp3.options.length -1;i++){
10drp3.remove(i);
11}
12var xmlhttp = new ActiveXObject("MSXML2.XMLHTTP");
13var oDoc = new ActiveXObject("MSXML2.DOMDocument");
14var state=document.getElementById("DropDownList1").value;
15xmlhttp.open("POST", "webform1.aspx?id="+state,false);
16xmlhttp.send("");
17var res=oDoc.loadXML(xmlhttp.responseText);
18var naItems = oDoc.selectNodes("//Market/Table/maName");
19var idItems = oDoc.selectNodes("//Market/Table/maId");
20var item;
21var id;
22for (item = naItems.nextNode(),id=idItems.nextNode(); item&&id; item = naItems.nextNode(),id=idItems.nextNode()){
23var nastr = item.nodeTypedValue;
24var idstr = id.nodeTypedValue;
25var newOption = document.createElement("OPTION");
26newOption.text =nastr;
27newOption.value = idstr;
28
29
30drp2.options.add(newOption);
31}
32load2();
33
34}
35function load2(){
36var drp2 = document.getElementById("DropDownList3");
37drp2.innerText="";
38for(var i = 0;i<=drp2.options.length -1;i++){
39drp2.remove(i);
40}
41var xmlhttp = new ActiveXObject("MSXML2.XMLHTTP");
42var oDoc = new ActiveXObject("MSXML2.DOMDocument");
43var state=document.getElementById("DropDownList2").value;
44xmlhttp.open("POST", "webform3.aspx?id="+state,false);
45xmlhttp.send("");
46var res=oDoc.loadXML(xmlhttp.responseText);
47var naItems = oDoc.selectNodes("//Market/Table/maName");
48var idItems = oDoc.selectNodes("//Market/Table/maId");
49var item;
50var id;
51for (item = naItems.nextNode(),id=idItems.nextNode(); item&&id; item = naItems.nextNode(),id=idItems.nextNode()){
52var nastr = item.nodeTypedValue;
53var idstr = id.nodeTypedValue;
54var newOption = document.createElement("OPTION");
55newOption.text =nastr;
56newOption.value = idstr;
57
58
59drp2.options.add(newOption);
60}
61
62}
63</script>
1<body ms_positioning="GridLayout" onload="load()">
2<form id="Form1" method="post" runat="server">
3<asp:dropdownlist id="DropDownList1" runat="server"></asp:dropdownlist>
4<asp:dropdownlist id="DropDownList2" runat="server"></asp:dropdownlist>
5<asp:dropdownlist id="Dropdownlist3" runat="server"></asp:dropdownlist>
6</form>
7</body>
-----------------------
namespace dropDown
{
///
1<summary>
2/// WebForm2 的摘要说明。
3/// </summary>
public class WebForm2 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList Dropdownlist3;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!this.IsPostBack)
{
SqlConnection con = new SqlConnection("server=localhost;database=star;uid=sa;pwd=");
SqlDataAdapter da = new SqlDataAdapter("select maId,maName from tabMarket where maCls=0",con);
DataSet ds = new DataSet();
da.Fill(ds,"op");
this.DropDownList1.DataSource=ds.Tables[0];
this.DropDownList1.DataTextField = "maName";
this.DropDownList1.DataValueField = "maId";
this.DropDownList1.DataBind();
this.DropDownList1.Attributes.Add("onchange","load()");
this.DropDownList2.Attributes.Add("onchange","load2()");
}
}
}
}
-----------------------
public class WebForm1 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
// Put user code to initialize the page here
//if(this.Request["state"]!=null)
//{
string id =this.Request["id"];
SqlConnection con = new SqlConnection("server=localhost;database=star;uid=sa;pwd=;");
SqlDataAdapter da = new SqlDataAdapter("select maName,maId from tabMarket where maParent=@id and maSt=1 ",con);
da.SelectCommand.Parameters.Add("@id",id);
DataSet ds = new DataSet("Market");
da.Fill(ds);
ds.WriteXml(Response.OutputStream);
Response.Flush ();
Response.End ();
//}
}
}
-----------------------------
public class WebForm3 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string id =Request["id"];
SqlConnection con = new SqlConnection("server=localhost;database=star;uid=sa;pwd=;");
SqlDataAdapter da = new SqlDataAdapter("select maName,maId from tabMarket where maParent=@id and maSt=1",con);
da.SelectCommand.Parameters.Add("@id",id);
DataSet ds = new DataSet("Market");
da.Fill(ds);
ds.WriteXml(Response.OutputStream);
Response.Flush ();
Response.End ();
}
}
------------------