基于ajax+jqueery的二级下拉框联动

最新推荐文章于 2024-05-06 17:34:57 发布

置顶 wanglei_samrtfish

最新推荐文章于 2024-05-06 17:34:57 发布

阅读量1.6k

点赞数

分类专栏： asp.net学习总结文章标签： ajax insert server xhtml security database

本文链接：https://blog.csdn.net/wanglei_samrtfish/article/details/7178903

版权

asp.net学习总结专栏收录该内容

103 篇文章 0 订阅

订阅专栏

--------前台页面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">

----- page2.aspx页面后台代码--------

---测试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

wanglei_samrtfish

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于ajax+jqueery的二级下拉框联动

--------前台页面page1.aspx 代码--------------------------------------------http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" > 无标题页
复制链接

扫一扫