title: Load Databind DropDownList inside ListView
body: <p>I have a ListView control that contains a DropDownList control inside the <code>ItemTemplate</code> tag.
  I am trying to load the existing list items to the DropDownList using the codes below inside the <code>ItemCommand</code> event of the ListView control:</p>
  
  <pre><code>DropDownList ddlItem = (DropDownList)e.Item.FindControl("ddlItem");
  
  con.Open();
  SqlCommand cmd = new SqlCommand();
  cmd.Connection = con;
  cmd.CommandText = "SELECT ID, Name FROM Items";
  SqlDataReader data = cmd.ExecuteReader();
  ddlItem.DataSouce = data;
  ddlItem.DataTextField = "Name";
  ddlItem.DataValueField = "ID";
  ddlItem.DataBind();
  con.Close();
  </code></pre>
  
  <p>After binding the items, I want to choose the selected items based from the database records.</p>
  
  <p>Am I missing something?</p>