实现两个DropList联动

//首先要设置两个控件的AutoPostBack为true; 

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection cnn = new SqlConnection();
            cnn.ConnectionString = "Data Source=localhost;Initial Catalog=MMS;Integrated Security=True";
            cnn.Open();
            string mysql = "select * from Province";
            SqlCommand cmm = new SqlCommand(mysql, cnn);
            SqlDataReader dr = cmm.ExecuteReader();
            while (dr.Read())
            {
                ddl_uprovinceid.Items.Add(new ListItem(dr["Province"].ToString(), dr["Province"].ToString()));
            }
            cnn.Close();
        }
    }

//添加DropList的SelectIndexChanged事件

 protected void ddl_uprovinceid_SelectedIndexChanged(object sender, EventArgs e)
    {
        ddl_ucityid.Items.Clear();
        SqlConnection cnn = new SqlConnection();
        cnn.ConnectionString = "Data Source=localhost;Initial Catalog=MMS;Integrated Security=True";
        cnn.Open();
        string mysql = "select city from cities where provinceid in(select ProvinceID from Province where Province='" + ddl_uprovinceid.SelectedItem.Text + "');";
        SqlCommand cmm = new SqlCommand(mysql, cnn);
        SqlDataReader dr = cmm.ExecuteReader();
        while (dr.Read())
        {
            ddl_ucityid.Items.Add(new ListItem(dr["city"].ToString(), dr["city"].ToString()));
        }
        cnn.Close();
      
    }