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

相关文章导航

Sql Server2005 Transact-SQL 新兵器学习总结之-总结

Flex,Fms3相关文章索引

FlexAir开源版-全球免费多人视频聊天室,免费网络远程多人视频会议系统((Flex,Fms3联合开发))<视频聊天,会议开发实例8>

先建立2个表

--父表

create table tb_parent(

--主键

ids int constraint pk_tb_parent_ids primary key,

parentName nvarchar(1000)

)

insert into tb_parent

select 1,'aaa'

union all

select 2,'bbb'

union all

select 3,'ccc'

--子表

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)

)

insert into tb_child

select 1,101,'a_1'

union all

select 1,102,'a_2'

insert into tb_child

select 2,201,'b_1'

union all

select 2,202,'b_2'

insert into tb_child

select 3,301,'c_1'

union all

select 3,302,'c_2'

union all

select 3,303,'c_3'

再创建3个过程

--得到父表数据

create proc proc_GetparentData

SELECT [ids], [parentName]

FROM [tb_parent]

--得到子表数据

create proc proc_GetchildData

SELECT [parentId], [childId], [childName]

FROM [tb_child]

--由父id得到子表数据

create proc proc_GetchildDataBYparentId

@parentId int

SELECT [parentId], [childId], [childName]

FROM [tb_child]

where parentId=@parentId

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;

14using Microsoft.ApplicationBlocks.Data;

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;

23 protected System.Web.UI.WebControls.Label msgLabel;

24 protected System.Web.UI.WebControls.Button Buttonok;

26 readonly string conString="uid=sa;pwd=123;database=TestDataBase";

28 private void Page_Load(object sender, System.EventArgs e)

29 {

30 regJS();

31 Bind();

32 }

34 private void regJS()

35 {

36 SqlDataReader rs=this.GetchildData();

37 StringBuilder sb=new StringBuilder(1000);

39 sb.Append("<Script Language=JavaScript>");

40 sb.Append(Environment.NewLine);

42 sb.Append("arr=new Array();");

43 sb.Append(Environment.NewLine);

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 }

53 if ( !rs.IsClosed )

54 {

55 rs.Close();

56 }

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>");

87 if( !Page.IsClientScriptBlockRegistered("jsScript"))

88 {

89 this.RegisterClientScriptBlock("jsScript",sb.ToString());

90 }

91 }

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俱乐部欢迎您的加入

我的系列文章

A.Sql Server2005 Transact-SQL 新兵器学习

B.MCAD学习

C.代码阅读总结

D.ASP.NET状态管理

E.DB(数据库)

F.WAP

G.WinForm

H.Flex

我的好文推荐

FlexAir开源版-全球免费多人视频聊天室,免费网络远程多人视频会议系统((Flex,Fms3联合开发))<视频聊天,会议开发实例8>

Sql Server2005 Transact-SQL 新兵器学习总结之-总结

MS SQL数据库备份和恢复存储过程(加强版本)

sql server中分布式查询随笔(链接服务器(sp_addlinkedserver)和远程登录映射(sp_addlinkedsrvlogin)使用小总结)

ASP.NET2.0国际化/本地化应用程序的实现总结(多语言,多文化页面的实现)

WAP开发资料站(最新更新)

自定义格式字符串随笔 (IFormattable,IFormatProvider,ICustomFormatter三接口的实现)

Mcad学习笔记之异步编程(AsyncCallback 委托,IAsyncResult接口,BeginInvoke方法,EndInvoke方法的使用小总结)

Mcad学习笔记之通过反射调用類的方法,屬性,字段,索引器(2種方法)

Mcad学习笔记之序列化(2进制和Soap序列化)

Mcad学习笔记之委托再理解(delegate的构造器,BeginInvoke,EndInvoke,Invoke4个方法的探讨)

ASP.NET状态管理之一（概括篇）

Flex,Fms学习笔记

本文转自aierong博客园博客，原文链接：http://www.cnblogs.com/aierong/archive/2005/10/20/258576.html，如需转载请自行联系原作者