Hi there,
 There is a problem regarding DropDownList Control. Actually i  am trying to assign the list a particular field from the access database. And after that by selecting any element on that dropdownlist i want that the selection be querried and the result should be displayed on the other dropdownlist.
Everthing is done successfully BUT....
 [PROBLEM] Each time the page posted back, the number of elements get doubled and trippled on the first and second dropdownlist. I tried not to postback and played with viewstate of the page but all in vain.
 Please think about it.

Here is the sample code i m trying to run.

void Page_Load(Object s,EventArgs e)
{
  objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/") + "aeg.mdb");
  objConn.Open();
  objCmd = new OleDbCommand("SELECT DISTINCT Country from Institutes",objConn);
  objReader = objCmd.ExecuteReader();
  while(objReader.Read())
   {
   DropDownList6.Items.Add(Convert.ToString(objReader["Country"]));
   }
}

Then on Selected Index change:

void DropDownList6_SelectedIndexChanged(object sender, EventArgs e) {

 objCmd = new OleDbCommand("SELECT DISTINCT City from Institutes where Country = '"+ DropDownList6.SelectedItem.Text + "'",objConn);
objReader = objCmd.ExecuteReader();

  while(objReader.Read())
   {
  DropDownList7.Items.Add(Convert.ToString(objReader["City"]));

    }

}

Mangol.