[DotNetDevelopment] Using Drop Down List.

[IT MILAN PITAM PURA]

Hi,
i am gyanesh. i just want to discuss a problem with you. the scenario
is as follows:
i am having two drop down list controls in my web page. the first drop
down is accessing regionid from a table and second drop down list is
accessing the regionname from the database and show it into the second
drop down list. now whenever i am selecting a value it adds the value
in the second drp down list. but i want when i am accessing an id from
the first drop down list it will reset the second and drop down list
and show the value automatically. for that i am providing u the code
which is written by me.

---------------------------
protected void DropDownList1_SelectedIndexChanged(object sender,
EventArgs e)
    {
           if (IsPostBack)
            {
                SqlConnection con = new SqlConnection
("server=del-00222-srvmr;database=adventureworks;user
id=sa;password=.");
                string info = DropDownList1.Text;
                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from cinema
where region...@id", con);
                cmd.Parameters.Add(new SqlParameter("@id", info));
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    DropDownList2.get
                }
                con.Close();
            }

    }