今天试了一下ajax dropdownlist联动,实际上是先写在一个XmlTextWriter(Response.OutputStream，然后再response回去（等同于一个ＸＭＬ），里面有很多要注意的地方,比如dropdownlist的清空，遍历XML,等等，都用红色标记了，网上的例子很多,但不一定对,经过一番调试，终于ＯＫ了，
test1.aspx
<%@ Page language="c#" Codebehind="test1.aspx.cs" AutoEventWireup="false" Inherits="SC.test1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>test1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<script language="javascript">
function load(statevalue){
var drp2 = document.getElementById("DropDownList2");
//清空DropDownList2
while(drp2.length > 0)
{ drp2.options.remove(0);}
//
var oHttpReq = new ActiveXObject("MSXML2.XMLHTTP");
var oDoc = new ActiveXObject("MSXML2.DOMDocument");
// alert(statevalue);
oHttpReq.open("POST", "test2.aspx?statevalue="+statevalue, false);
oHttpReq.send("");
result = oHttpReq.responseText;
oDoc.loadXML(result);
// alert(result);
var nodes = oDoc.documentElement.childNodes;
for(i=0;i<nodes.length;i++)
{
var PP = nodes[i].childNodes;
var newOption = document.createElement("OPTION");
newOption.text = PP[0].text ;
newOption.value = PP[1].text;
drp2.options.add(newOption);
}
}
function change(obj)
{
alert(obj.options[obj.selectedIndex].value);
document.getElementById("tip").value = obj.options[obj.selectedIndex].value;
}
</script>
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DropDownList id="DropDownList1" runat="server"></asp:DropDownList>
<asp:DropDownList id="DropDownList2" runat="server"></asp:DropDownList>
<asp:TextBox ID="tip" Runat="server"></asp:TextBox>
<asp:Button id="Button1" style="Z-INDEX: 101; LEFT: 352px; POSITION: absolute; TOP: 32px" runat="server"
Text="Button"></asp:Button>
</form>
</body>
</HTML>
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Xml;
using System.Data.SqlClient;
using MyConfig;
using Microsoft.ApplicationBlocks.Data;
using AjaxPro;
namespace SC
{
/// <summary>
/// test1 的摘要描述。
/// </summary>
public class test1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.TextBox tip;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
private void Page_Load(object sender, System.EventArgs e)
{
// 在這裡放置使用者程式碼以初始化網頁
if(!this.IsPostBack)
{
SqlConnection con = new SqlConnection(MyConfig.MyConfigSectionHandler.ConnectionString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select State,statevalue from Astate ",con);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
this.DropDownList1.DataSource = ds.Tables[0];
this.DropDownList1.DataTextField = "State";
this.DropDownList1.DataValueField = "statevalue";
this.DropDownList1.DataBind();
this.DropDownList1.Attributes.Add("onchange","load(this.options[this.selectedIndex].value)");
this.DropDownList2.Attributes.Add("onchange","change(this)");
}
}
#region Web Form 設計工具產生的程式碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
/// 這個方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
Response.Write(this.tip.Text);
}
}
}
test2.aspx.
<%@ Page language="c#" Codebehind="test2.aspx.cs" AutoEventWireup="false" Inherits="SC.test2" %>
test2.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Xml;
using System.Data.SqlClient;
using MyConfig;
using Microsoft.ApplicationBlocks.Data;
using AjaxPro;
namespace SC
{
/// <summary>
/// test2 的摘要描述。
/// </summary>
public class test2 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
// 在這裡放置使用者程式碼以初始化網頁
if(this.Request["statevalue"]!=null)
{
string statevalue = this.Request["statevalue"].ToString();
SqlConnection con = new SqlConnection(MyConfig.MyConfigSectionHandler.ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select city,cityvalue from Acity where statevalue = '"+statevalue+"'",con);
DataSet ds = new DataSet("thiscity");
da.Fill(ds);
string filename = "c://myxml.xml";
System.IO.FileStream myFileStream = new System.IO.FileStream(filename,System.IO.FileMode.Create);
ds.WriteXml(myFileStream);
myFileStream.Close();
/*写出来是这样的ＸＭＬ文件
<thiscity>
<Table>
<city>韶關</city>
<cityvalue>4</cityvalue>
</Table>
<Table>
<city>廣州</city>
<cityvalue>5</cityvalue>
</Table>
<Table>
<city>汕頭</city>
<cityvalue>6</cityvalue>
</Table>
</thiscity>
*/
XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding);
writer.Formatting = Formatting.Indented;
writer.Indentation = 4;
writer.IndentChar =' ';
ds.WriteXml(writer);
writer.Flush();
Response.End();
writer.Close();
}
}
#region Web Form 設計工具產生的程式碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
/// 這個方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
2268
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
