今天我們來一起用ASP.net實現一個級聯，這個小不點應該是會經常用到的的。
咱們簡單的畫兩個窗體。文本框會根據下拉框所選的內容顯示不同的內容。
具體實現效果如下
步驟一：
準備工作，建立相應的數據庫。
顯示效果如下
附腳本如下
?| 1234567891011121314151617181920212223242526 | create database departmentuse departmentcreate table TDepartment(depID int PRimary key,depName varchar(30) not null)insert into TDepartment values(1,'教務')insert into TDepartment values(2,'高校')insert into TDepartment values(3,'辦公室')create table emp(empID int primary key,empName varchar(30) not null,depID int foreign key references TDepartment(depID))insert into emp values(1,'小馬',1)insert into emp values(2,'小丹',1)insert into emp values(3,'小妹',1)insert into emp values(4,'馬丹妹',3) |
步驟二：
新建項目為 ASP.ne Web 窗體應用程序。在窗體中畫 圖中的兩個控件。DropDownList 和ListBox，分別命名為 ddlDep 和lBoxEmp。同時將DropDownList中AutoPostBack屬性設置為TRUE(目的是讓每次重選列表能有響應)。我們需要在formload 和ddlDep_SelectedIndexChanged 時間中編寫相應的代碼。其中ddlDep_SelectedIndexChanged是選中空間ddlDep在右側屬性-事件中雙擊時間SelectedIndexChanged
?| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 | using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;//數據庫namespace department{public partial class WebForm1 : System.Web.UI.Page{protected System.Web.UI.WebControls.ListBox lBoxEmp;protected System.Web.UI.WebControls.DropDownList ddlDep;protected void Page_Load(object sender, EventArgs e){if (!this.IsPostBack){SqlConnection con = DBcon.createConnection();con.Open();//顯示部門SqlCommand cmd = new SqlCommand("select * from TDepartment", con);SqlDataReader sdr = cmd.ExecuteReader();this.ddlDep.DataSource = sdr;this.ddlDep.DataTextField = "depName";this.ddlDep.DataValueField = "depID";this.ddlDep.DataBind();sdr.Close();//顯示員工SqlCommand cmdEmp = new SqlCommand("select * from emp where depID=" + this.ddlDep.SelectedValue, con);SqlDataReader sdrEmp = cmdEmp.ExecuteReader(); ;while (sdrEmp.Read()){
|
