Gyanesh, I'm not really inderstanding what you're asking for. Are you trying to populate the second drop down list with names that are in the region that was chosen on the first drop down list?
Cerebrus, that code is going to clear all the items in the list with each loop. That doesn't seem right. James On Jul 23, 10:28 am, Cerebrus <[email protected]> wrote: > while (dr.Read()) > { > DropDownList2.Items.Clear(); > DropDownList2.Items.Add(Convert.ToString(dr["RegionName"])) > > } > > On Jul 23, 4:20 pm, IT MILAN PITAM PURA <[email protected]> wrote: > > > > > 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(); > > } > > > }
