介绍 & lt; % @ Page 语言=癱#“, AutoEventWireup=皌rue", CodeFile=癉efault.aspx.cs",继承=癬Default", %的在,
,
& lt; ! DOCTYPE html>,
,
& lt; html xmlns=癶ttp://www.w3.org/1999/xhtml"祝辞,
& lt; head runat=皊erver"祝辞,
& lt; meta http-equiv=癈ontent-Type",内容=皌ext/html;, charset=utf-8"/祝辞,
,& lt; title> & lt;/title>,
时间/head> & lt;
& lt; body>,
,& lt; form id=癴orm1", runat=皊erver"祝辞,
& lt; div>大敌;
,
,& lt; asp: DropDownList ID=癲dlDep", runat=皊erver",将AutoPostBack=癟rue", OnSelectedIndexChanged=癲dlDep_SelectedIndexChanged"祝辞,
& lt;/asp: DropDownList>大敌;;
,& lt; br /祝辞,
,& lt; asp: ListBox ID=發BoxEmp", runat=皊erver"祝辞& lt;/asp: ListBox>,
,
& lt;/div>大敌;
& lt;/form>大敌;
时间/body> & lt;
& lt;/html> using 系统;,
using System.Collections.Generic,
using 来,
using 包含,
using System.Web.UI,
using System.Web.UI.WebControls,
using System.Data.SqlClient,
,
public partial class _Default :, System.Web.UI.Page
{,
,protected void employee (object ,发送方,EventArgs e),
{大敌;
,if (! this.IsPostBack),
{大敌;
,SqlConnection con =, DBCon.createConnection (),,
,con.Open (),,
,//显示部门,
,SqlCommand cmd =, new SqlCommand (“select *,得到Tdepartment",,反对),,
,SqlDataReader sdr =, cmd.ExecuteReader (),,
特别提款权,this.ddlDep.DataSource =,,,=,this.ddlDep.DataTextField “depName",,=,this.ddlDep.DataValueField “depID",,
,this.ddlDep.DataBind (),,
,sdr.Close (),,
,//显示员工,
,SqlCommand cmdEmp =new SqlCommand (“select *,得到emp where depID=? +, this.ddlDep .SelectedValue ,反对),,
,SqlDataReader sdrEmp =, cmdEmp.ExecuteReader (),,
,while (sdrEmp.Read ()),
{大敌;
列,this.lBoxEmp.Items.Add (new (sdrEmp.GetString (1) sdrEmp .GetInt32 (0) .ToString ())),,
}大敌;
,sdrEmp.Close (),,
,//关闭连接,
,con.Close (),,
}大敌;
}大敌;
,protected void ddlDep_SelectedIndexChanged (object ,发送方,EventArgs e),
{大敌;
,this.lBoxEmp.Items.Clear (),,
,SqlConnection con =, DBCon.createConnection (),,
,con.Open (),,
,SqlCommand cmdEmp =, new SqlCommand (“select *,得到emp where depID=? +, this.ddlDep.SelectedValue,,反对),,
,SqlDataReader sdrEmp =, cmdEmp.ExecuteReader (),,
,while (sdrEmp.Read ()),
{大敌;
列,this.lBoxEmp.Items.Add (new (sdrEmp.GetString (1), sdrEmp.GetInt32 (0) .ToString ())),,
}大敌;
,sdrEmp.Close (),,
,//关闭连接,
,con.Close (),,
}大敌;
} using 系统;,
using System.Collections.Generic,
using 来,
using 包含,
using System.Data.SqlClient,
,///,& lt; summary>,///,DBCon 的摘要说明,///,& lt;/summary>,
public class DBCon
{,
,public DBCon (),
{大敌;
,//,//TODO:在此处添加构造函数逻辑,
,//}大敌;
,public static SqlConnection createConnection (),
{大敌;
,SqlConnection con =, new SqlConnection(数据库“服务器=?部门;uid=sa; pwd=123456“),,
,return 诈骗;
}大敌;
null
这期内容当中小编将会给大家带来有关怎么在ASP.NET项目中实现一个级联下拉框效果,文章内容丰富且以专业的角度为大家分析和叙述,阅读完这篇文章希望大家可以有所收获。
用ASP.NET控件实现部门和员工的联动,参考过程如下
<>强效果图:,
<强>违约。aspx代码:
<强> default . aspx。cs代码:
<强> DBCon。cs代码
