ASP.NET学习笔记--DropdownList&ListBox连动菜单

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Web;
5. using System.Web.Security;
6. using System.Web.UI;
7. using System.Web.UI.WebControls;
8. using System.Web.UI.WebControls.WebParts;
9. using System.Web.UI.HtmlControls;
10. using System.Data.SqlClient;
12. public partial class _Default : System.Web.UI.Page 
13. {
15.     protected void Page_Load(object sender, EventArgs e)
16.     {
17.         if (!this.IsPostBack) //第一次加载页面
18.         {
19.             //创建数据库连接
20.             SqlConnection con = DBConnection.createConnection();
21.             con.Open();
22.             SqlCommand cmd;
23.             SqlDataReader sdr,sdr2;
24.             cmd = new SqlCommand();
25.             cmd.CommandText = "select * from TDepartment";
26.             cmd.Connection = con;
27.             sdr= cmd.ExecuteReader();
28.             this.ddlDep.DataSource = sdr;
29.             this.ddlDep.DataTextField = "depName";
30.             this.ddlDep.DataValueField = "depID";
31.             this.ddlDep.DataBind();
32.             sdr.Close();
34.             int depID = Convert.ToInt32(this.ddlDep.SelectedValue);
35.             cmd.CommandText = "select * from Emp where depID="+depID;
36.             cmd.Connection = con;
37.             sdr2 = cmd.ExecuteReader();
38.           
39.             while (sdr2.Read()) {
40.                 this.lBoxEmp.Items.Add(new ListItem(sdr2.GetString(1),sdr2.GetInt32(0).ToString()));
41.             }
42.             sdr2.Close();
43.             con.Close();
44.         }
45.     }
47.     protected void ddlDep_SelectedIndexChanged(object sender, EventArgs e)
48.     {
49.         this.lBoxEmp.Items.Clear();
50.         SqlConnection con = DBConnection.createConnection();
51.         con.Open();
52.         SqlCommand cmd = new SqlCommand();
53.         int depID = Convert.ToInt32(this.ddlDep.SelectedValue);
54.         cmd.CommandText = "select * from Emp where depID="+depID;
55.         cmd.Connection = con;
56.         SqlDataReader sdremp = cmd.ExecuteReader();        
57.         while (sdremp.Read()) {
58.             this.lBoxEmp.Items.Add(new ListItem(sdremp.GetString(1), sdremp.GetInt32(0).ToString()));
59.         }
60.         sdremp.Close();
61.         con.Close();
63.         }   
64. }

public class DBConnection
{
 public DBConnection()
 { }

    public static SqlConnection createConnection() {
        SqlConnection con = new SqlConnection("server=.;database=Department;uid=sa;pwd=");
        return con;
    }
}