--------前台页面page1.aspx 代码--------------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="page1.aspx.cs" Inherits="web9.page1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>无标题页</title>
<script src="jquery-1.3.2.min.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
$("#bTrade").change(function(){
$("#sTrade").load("page2.aspx?id=" + $("#bTrade").val());
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<select name="bTrade" id="bTrade">
<option value="-1">所属省份</option>
<%=provicename%>
</select>
<select name='sTrade' id="sTrade">
<option value='-2'>城市</option>
</select>
</form>
</body>
</html>
----------页面page1.aspx后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Data.SqlClient;
namespace web9
{
public partial class page2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("server=(local) ; database=test3;integrated security=true;");
public string cityname = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder st = new StringBuilder();
SqlCommand comm = new SqlCommand("select * from cityinfo where pid=" + Request.QueryString["id"].ToString(), conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
st.Append("<option value=" + dr["pid"].ToString() + ">----" + dr["cname"].ToString() + "----</option>");
}
dr.Close();
conn.Close();
cityname = st.ToString();
Response.Write(cityname);
Response.End();
}
}
}
-----------page2.aspx页面前台代码--------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="page2.aspx.cs" Inherits="web9.page2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>
----- page2.aspx页面后台代码--------
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Data.SqlClient;
namespace web9
{
public partial class page2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("server=(local) ; database=test3;integrated security=true;");
public string cityname = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder st = new StringBuilder();
SqlCommand comm = new SqlCommand("select * from cityinfo where pid=" + Request.QueryString["id"].ToString(), conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
st.Append("<option value=" + dr["pid"].ToString() + ">----" + dr["cname"].ToString() + "----</option>");
}
dr.Close();
conn.Close();
cityname = st.ToString();
Response.Write(cityname);
Response.End();
}
}
---测试sql脚本
---省
create table provinceinfo
(pid int primary key identity(1,1),
pname varchar(20)
)
go
insert into provinceinfo values('湖北');
insert into provinceinfo values('湖南');
select *from provinceinfo
--市
create table cityinfo
(
cid int primary key identity(100,1) ,
cname varchar(20),
pid int references provinceinfo (pid)
)
go
insert into cityinfo values('武汉',1);
insert into cityinfo values('黄冈',1);
insert into cityinfo values('长沙',2);
insert into cityinfo values('岳阳',2);
select *from cityinfo