《ASP.NET》数据绑定―DropDownList、ListBox的图文代码详解

<span style="font-family:KaiTi_GB2312;font-size:18px;">     

 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

        {

            this.ListBox1.Items.Clear();

            SqlConnection con2 = DB.createConnection();

            SqlCommand cmd1 = new SqlCommand("select * from city where proID=" + this.DropDownList1.SelectedValue, con2);

            SqlDataReader sdr1 = cmd1.ExecuteReader();

            while (sdr1.Read())

            {

                this.ListBox1.Items.Add(new ListItem(sdr1.GetString(2),sdr1.GetInt32(0).ToString()));

            }

        }</span>