1.html代码
5.Ajax.dll /Files/singlepine/Ajax.rar
<
HTML
>
< HEAD >
< title > Ajax实现无刷新三联动下拉框 </ 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 cityResult()
{
var city=document.getElementById("DropDownList1");
AjaxMethod.GetCityList(city.value,get_city_Result_CallBack);
}
function get_city_Result_CallBack(response)
{
if (response.value != null)
{
document.all("DropDownList2").length=0;
var piArray = response.value.split(",");
for(var i=0;i<piArray.length;i++)
{
var ary1 = piArray[i].toString().split("|");
document.all("DropDownList2").options.add(new Option(ary1[1].toString(),ary1[0].toString()));
}
}
return
}
//市区----------------------------------------
function areaResult()
{
var area=document.getElementById("DropDownList2");
AjaxMethod.GetAreaList(area.value,get_area_Result_CallBack);
}
function get_area_Result_CallBack(response)
{
if (response.value != null)
{
document.all("DropDownList3").length=0;
var piArray = response.value.split(",");
for(var i=0;i<piArray.length;i++)
{
var ary1 = piArray[i].toString().split("|");
document.all("DropDownList3").options.add(new Option(ary1[1].toString(),ary1[0].toString()));
}
}
return
}
</ SCRIPT >
</ HEAD >
< body MS_POSITIONING ="GridLayout" >
< form id ="Form1" method ="post" runat ="server" >
< TABLE id ="Table1" style ="Z-INDEX: 104; LEFT: 96px; POSITION: absolute; TOP: 32px" cellSpacing ="1"
cellPadding ="1" width ="300" border ="1" >
< TR >
< TD > 省市 </ TD >
< TD >
< asp:DropDownList id ="DropDownList1" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
< TR >
< TD > 城市 </ TD >
< TD >
< asp:DropDownList id ="DropDownList2" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
< TR >
< TD > 市区 </ TD >
< TD >
< asp:DropDownList id ="DropDownList3" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
</ TABLE >
</ form >
</ body >
</ HTML >
2.cs代码
< HEAD >
< title > Ajax实现无刷新三联动下拉框 </ 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 cityResult()
{
var city=document.getElementById("DropDownList1");
AjaxMethod.GetCityList(city.value,get_city_Result_CallBack);
}
function get_city_Result_CallBack(response)
{
if (response.value != null)
{
document.all("DropDownList2").length=0;
var piArray = response.value.split(",");
for(var i=0;i<piArray.length;i++)
{
var ary1 = piArray[i].toString().split("|");
document.all("DropDownList2").options.add(new Option(ary1[1].toString(),ary1[0].toString()));
}
}
return
}
//市区----------------------------------------
function areaResult()
{
var area=document.getElementById("DropDownList2");
AjaxMethod.GetAreaList(area.value,get_area_Result_CallBack);
}
function get_area_Result_CallBack(response)
{
if (response.value != null)
{
document.all("DropDownList3").length=0;
var piArray = response.value.split(",");
for(var i=0;i<piArray.length;i++)
{
var ary1 = piArray[i].toString().split("|");
document.all("DropDownList3").options.add(new Option(ary1[1].toString(),ary1[0].toString()));
}
}
return
}
</ SCRIPT >
</ HEAD >
< body MS_POSITIONING ="GridLayout" >
< form id ="Form1" method ="post" runat ="server" >
< TABLE id ="Table1" style ="Z-INDEX: 104; LEFT: 96px; POSITION: absolute; TOP: 32px" cellSpacing ="1"
cellPadding ="1" width ="300" border ="1" >
< TR >
< TD > 省市 </ TD >
< TD >
< asp:DropDownList id ="DropDownList1" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
< TR >
< TD > 城市 </ TD >
< TD >
< asp:DropDownList id ="DropDownList2" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
< TR >
< TD > 市区 </ TD >
< TD >
< asp:DropDownList id ="DropDownList3" runat ="server" ></ asp:DropDownList ></ TD >
</ TR >
</ TABLE >
</ form >
</ body >
</ HTML >
public
class
AjaxDropDownList : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.DropDownList1.DataSource=AjaxMethod.GetPovinceList();
this.DropDownList1.DataTextField="province";
this.DropDownList1.DataValueField="provinceID";
this.DropDownList1.DataBind();
Ajax.Utility.RegisterTypeForAjax(typeof(AjaxMethod));
this.DropDownList1.Attributes.Add("onchange","cityResult();");
this.DropDownList2.Attributes.Add("onchange","areaResult();");
}
}
Web Form Designer generated code#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/**//// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
3.AjaxMethod
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.DropDownList1.DataSource=AjaxMethod.GetPovinceList();
this.DropDownList1.DataTextField="province";
this.DropDownList1.DataValueField="provinceID";
this.DropDownList1.DataBind();
Ajax.Utility.RegisterTypeForAjax(typeof(AjaxMethod));
this.DropDownList1.Attributes.Add("onchange","cityResult();");
this.DropDownList2.Attributes.Add("onchange","areaResult();");
}
}
Web Form Designer generated code#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/**//// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
public
class
AjaxMethod
{
public static string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
GetDataSet#region GetDataSet
public static DataSet GetDataSet(string sql)
{
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
GetPovinceList#region GetPovinceList
public static DataSet GetPovinceList()
{
string sql="select * from povince";
return GetDataSet(sql);
}
#endregion
GetCityList#region GetCityList
[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
public static string GetCityList(int povinceid)
{
string sql="select * from city where father="+povinceid;
DataSet ds=GetDataSet(sql);
string str="";
for(int m=0;m<ds.Tables[0].Rows.Count;m++)
{
str+=","+ds.Tables[0].Rows[m]["cityID"].ToString()+"|"+ds.Tables[0].Rows[m]["city"].ToString();
}
str=str.Substring(1,str.Length-1);
return str;
}
#endregion
GetAreaList#region GetAreaList
[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
public static string GetAreaList(int cityid)
{
string sql="select * from area where father="+cityid;
DataSet ds=GetDataSet(sql);
string str="";
for(int m=0;m<ds.Tables[0].Rows.Count;m++)
{
str+=","+ds.Tables[0].Rows[m]["areaID"].ToString()+"|"+ds.Tables[0].Rows[m]["area"].ToString();
}
str=str.Substring(1,str.Length-1);
return str;
}
#endregion
}
4.数据库
/Files/singlepine/area.rar
{
public static string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
GetDataSet#region GetDataSet
public static DataSet GetDataSet(string sql)
{
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
GetPovinceList#region GetPovinceList
public static DataSet GetPovinceList()
{
string sql="select * from povince";
return GetDataSet(sql);
}
#endregion
GetCityList#region GetCityList
[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
public static string GetCityList(int povinceid)
{
string sql="select * from city where father="+povinceid;
DataSet ds=GetDataSet(sql);
string str="";
for(int m=0;m<ds.Tables[0].Rows.Count;m++)
{
str+=","+ds.Tables[0].Rows[m]["cityID"].ToString()+"|"+ds.Tables[0].Rows[m]["city"].ToString();
}
str=str.Substring(1,str.Length-1);
return str;
}
#endregion
GetAreaList#region GetAreaList
[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
public static string GetAreaList(int cityid)
{
string sql="select * from area where father="+cityid;
DataSet ds=GetDataSet(sql);
string str="";
for(int m=0;m<ds.Tables[0].Rows.Count;m++)
{
str+=","+ds.Tables[0].Rows[m]["areaID"].ToString()+"|"+ds.Tables[0].Rows[m]["area"].ToString();
}
str=str.Substring(1,str.Length-1);
return str;
}
#endregion
}
5.Ajax.dll /Files/singlepine/Ajax.rar