title: how to fill DropDownList from database in asp.net?
body: <p>how to fill DropDownList from database in asp.net ?</p>
  
  <p>and when i pick value from the DropDownList how to catch this event ?</p>
  
  <pre><code>Conn.Open();
  SQL = "SELECT distinct city FROM MEN";
  dsView = new DataSet();
  adp = new SqlDataAdapter(SQL, Conn);
  adp.Fill(dsView, "MEN");
  adp.Dispose();
  
  DropDownList1. ?????? (what do to ?)
  </code></pre>
  
  <p>thanks in advance</p>