- using System;
- using System.Data;
- using System.Configuration;
- 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.Data.SqlClient;
- public partial class _Default : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!this.IsPostBack) //第一次加载页面
- {
- //创建数据库连接
- SqlConnection con = DBConnection.createConnection();
- con.Open();
- SqlCommand cmd;
- SqlDataReader sdr,sdr2;
- cmd = new SqlCommand();
- cmd.CommandText = "select * from TDepartment";
- cmd.Connection = con;
- sdr= cmd.ExecuteReader();
- this.ddlDep.DataSource = sdr;
- this.ddlDep.DataTextField = "depName";
- this.ddlDep.DataValueField = "depID";
- this.ddlDep.DataBind();
- sdr.Close();
- int depID = Convert.ToInt32(this.ddlDep.SelectedValue);
- cmd.CommandText = "select * from Emp where depID="+depID;
- cmd.Connection = con;
- sdr2 = cmd.ExecuteReader();
- while (sdr2.Read()) {
- this.lBoxEmp.Items.Add(new ListItem(sdr2.GetString(1),sdr2.GetInt32(0).ToString()));
- }
- sdr2.Close();
- con.Close();
- }
- }
- protected void ddlDep_SelectedIndexChanged(object sender, EventArgs e)
- {
- this.lBoxEmp.Items.Clear();
- SqlConnection con = DBConnection.createConnection();
- con.Open();
- SqlCommand cmd = new SqlCommand();
- int depID = Convert.ToInt32(this.ddlDep.SelectedValue);
- cmd.CommandText = "select * from Emp where depID="+depID;
- cmd.Connection = con;
- SqlDataReader sdremp = cmd.ExecuteReader();
- while (sdremp.Read()) {
- this.lBoxEmp.Items.Add(new ListItem(sdremp.GetString(1), sdremp.GetInt32(0).ToString()));
- }
- sdremp.Close();
- con.Close();
- }
- }
public class DBConnection
{
public DBConnection()
{ }
public static SqlConnection createConnection() {
SqlConnection con = new SqlConnection("server=.;database=Department;uid=sa;pwd=");
return con;
}
}