本博推荐文章快速导航: Sql Server2005 Transact-SQL 新兵器学习 MCAD学习 代码阅读总结 ASP.NET状态管理 DB(数据库) WAP WinForm Flex,Fms

实现无刷新闪烁二级联动下拉菜单(js实现)

相关文章导航
  1. Sql Server2005 Transact-SQL 新兵器学习总结之-总结
  2. Flex,Fms3相关文章索引
  3. FlexAir开源版-全球免费多人视频聊天室,免费网络远程多人视频会议系统((Flex,Fms3联合开发))<视频聊天,会议开发实例8>


先建立2个表



--父表
create table tb_parent(
--主键
ids int constraint pk_tb_parent_ids primary key,
parentName 
nvarchar(1000)
)
go

insert into tb_parent
    
select 1,'aaa'
    
union all
    
select 2,'bbb'
    
union all
    
select 3,'ccc'
go

 


--子表
create table tb_child(
parentId 
int  ,
childId 
int ,
childName 
nvarchar (1000),
--parentId外键
constraint fk_tb_child_tb_parent_parentId 
    
FOREIGN KEY (parentId)     
        
REFERENCES tb_parent(ids)
)
go


insert into tb_child
    
select 1,101,'a_1'
    
union all
    
select 1,102,'a_2'
go
insert into tb_child
    
select 2,201,'b_1'
    
union all
    
select 2,202,'b_2'
go
insert into tb_child
    
select 3,301,'c_1'
    
union all
    
select 3,302,'c_2'
    
union all
    
select 3,303,'c_3'
go

再创建3个过程


--得到父表数据
create proc proc_GetparentData
as
SELECT [ids][parentName] 
    
FROM [tb_parent]
go


--得到子表数据
create proc proc_GetchildData
as
SELECT [parentId][childId][childName] 
    
FROM [tb_child]
go

--由父id得到子表数据
create proc proc_GetchildDataBYparentId
@parentId int
as
SELECT [parentId][childId][childName] 
    
FROM [tb_child]
    
where parentId=@parentId
go

WebForm5.aspx

 1 <%@ Page language="c#" Codebehind="WebForm5.aspx.cs" AutoEventWireup="false" Inherits="webtest.WebForm5" %>
 2 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
 3 <HTML>
 4     <HEAD>
 5         <title>WebForm5</title>
 6         <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
 7         <meta content="C#" name="CODE_LANGUAGE">
 8         <meta content="JavaScript" name="vs_defaultClientScript">
 9         <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
10     </HEAD>
11     <body MS_POSITIONING="GridLayout">
12         <form id="Form1" method="post" runat="server">
13             父:<asp:dropdownlist id="DropDownList_parent" runat="server" onChange="changevalue(document.Form1.DropDownList_parent.options[document.Form1.DropDownList_parent.selectedIndex].value)"
14                 Width="272px"></asp:dropdownlist>
15             <br>
16             子:<asp:dropdownlist id="DropDownList_child" runat="server" Width="272px"></asp:dropdownlist>
17             <br>
18             <asp:label id="msgLabel" runat="server" Width="416px"></asp:label>
19             <br>
20             <asp:Button id="Buttonok" runat="server" Text="click"></asp:Button></form>
21     </body>
22 </HTML>

WebForm5.aspx.cs

  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Drawing;
  7using System.Web;
  8using System.Web.SessionState;
  9using System.Web.UI;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.HtmlControls;
 12using System.Text;
 13
 14using Microsoft.ApplicationBlocks.Data;
 15
 16namespace webtest
 17{
 18    public class WebForm5 : System.Web.UI.Page
 19    {
 20        protected System.Web.UI.WebControls.DropDownList DropDownList_parent;
 21        protected System.Web.UI.WebControls.DropDownList DropDownList_child;
 22        
 23        protected System.Web.UI.WebControls.Label msgLabel;
 24        protected System.Web.UI.WebControls.Button Buttonok;
 25
 26        readonly string conString="uid=sa;pwd=123;database=TestDataBase";
 27    
 28        private void Page_Load(object sender, System.EventArgs e)
 29        {    
 30                regJS();
 31                Bind();
 32        }

 33
 34        private void regJS()
 35        {
 36            SqlDataReader rs=this.GetchildData();
 37            StringBuilder sb=new StringBuilder(1000);
 38
 39            sb.Append("<Script Language=JavaScript>");
 40            sb.Append(Environment.NewLine);
 41            
 42            sb.Append("arr=new Array();");
 43            sb.Append(Environment.NewLine);
 44            
 45            int i=0;
 46            while(rs.Read())
 47            {
 48                sb.AppendFormat("arr[{0}]=new Array('{1}','{2}','{3}')",i,rs["parentId"],rs["childId"],rs["childName"]);
 49                sb.Append(Environment.NewLine);
 50                i=i+1;
 51            }

 52            
 53            if ( !rs.IsClosed )
 54            {
 55                rs.Close();
 56            }

 57
 58            sb.Append(Environment.NewLine);
 59            sb.AppendFormat("var counts={0}",i);
 60            sb.Append(Environment.NewLine);
 61            sb.Append("function changevalue(parentId)");
 62            sb.Append(Environment.NewLine);
 63            sb.Append("{");
 64            sb.Append(Environment.NewLine);
 65            sb.Append("document.Form1.DropDownList_child.length = 0;");
 66            sb.Append(Environment.NewLine);
 67            sb.Append("var i;");
 68            sb.Append(Environment.NewLine);
 69            sb.Append("for(i=0; i<counts; i++)");
 70            sb.Append(Environment.NewLine);
 71            sb.Append("{");
 72            sb.Append(Environment.NewLine);
 73            sb.Append("if(arr[i][0]==parentId)");
 74            sb.Append(Environment.NewLine);
 75            sb.Append("{");
 76            sb.Append(Environment.NewLine);
 77            sb.Append("document.Form1.DropDownList_child.options[document.Form1.DropDownList_child.length]=new Option(arr[i][2],arr[i][1]);");
 78            sb.Append(Environment.NewLine);
 79            sb.Append("}");
 80            sb.Append(Environment.NewLine);
 81            sb.Append("}");
 82            sb.Append(Environment.NewLine);
 83            sb.Append("}");
 84            sb.Append(Environment.NewLine);
 85            sb.Append("</script>");            
 86                        
 87            if!Page.IsClientScriptBlockRegistered("jsScript"))            
 88            {
 89                this.RegisterClientScriptBlock("jsScript",sb.ToString());
 90            }

 91        }

 92
 93        void Bind()
 94        {
 95            //获得父表
 96            this.DropDownList_parent.DataSource=SqlHelper.ExecuteReader(conString,CommandType.StoredProcedure,"proc_GetparentData");
 97            this.DropDownList_parent.DataTextField="parentName";
 98            this.DropDownList_parent.DataValueField="ids";
 99            this.DropDownList_parent.DataBind();
100
101            //根据父表id得子表
102            this.DropDownList_child.DataSource=GetchildData(Convert.ToInt32(this.DropDownList_parent.SelectedValue));
103            this.DropDownList_child.DataTextField="childName";
104            this.DropDownList_child.DataValueField="childId";
105            this.DropDownList_child.DataBind();
106        }

107
108        /// <summary>
109        /// 得到子表数据
110        /// </summary>
111        /// <returns></returns>

112        SqlDataReader GetchildData()
113        {
114            return SqlHelper.ExecuteReader(conString,CommandType.StoredProcedure,"proc_GetchildData");
115        }

116        
117        /// <summary>
118        /// 由父id得到子表数据
119        /// </summary>
120        /// <param name="parentId"></param>
121        /// <returns></returns>

122        SqlDataReader GetchildData(int parentId)
123        {
124            SqlParameter[] sqlParameter={new SqlParameter("@parentId",SqlDbType.Int)};
125            sqlParameter[0].Value=parentId;
126            return SqlHelper.ExecuteReader(conString,CommandType.StoredProcedure,"proc_GetchildDataBYparentId",sqlParameter);
127        }

128
129        Web 窗体设计器生成的代码
150
151        private void Buttonok_Click(object sender, System.EventArgs e)
152        {
153            this.msgLabel.Text = String.Format("选择的父数值={0},选择的子数值={1}", Request.Form.Get("DropDownList_parent"),Request.Form.Get("DropDownList_child"));
154        }

155    }

156}

157

说明:我在代码中用到了微软的数据访问块,按钮单击事件中请用Request.Form.Get方法取到下拉列表的数值

收藏与分享

收藏到QQ书签 添加到百度搜藏 添加到百度搜藏 添加到雅虎收藏 分享到饭否 收藏到就喜欢网络收藏夹

RSS订阅我 什么是RSS?

feedsky    http://wap.feedsky.com/aierongrss    E-mail
订阅到雅蛙       使用RSS邮天下订阅    订阅到有道阅读
订阅到抓虾    鲜果阅读器订阅图标    Add to Google
訂閱 Bloglines    哪吒提醒    Subscribe in NewsGator Online

东莞.net俱乐部

东莞.net俱乐部 欢迎您的加入

posted @ 2005-10-20 17:30  aierong  阅读(...)  评论(... 编辑 收藏