title: Dropdown ASPX how to query from a list
body: <p>I'm trying to select from a database UNIQUE ID's and put them into a a list in the dropdown menu I know it seems easy but I'm a little noob.Could you help me. I've tried to interrogate the list somehow but I don't know if it's good then I tried to put it my asp is like this:</p>
  
  <pre><code>ID: &lt;asp:DropDownList ID="ProdtID" runat="server"&gt;&lt;/asp:DropDownList&gt;
  </code></pre>
  
  <p>The problem is it isn't showing anything </p>
  
  <pre><code>IDataReader ProductId = null;
  
  int n = 300;
  
  for (int i = 0; i &lt; n; i++)
  {
      string getProductName = "";
      NameValueCollection coll = HttpContext.Current.Request.Form;
      objProducts.productname = coll[ProdtID.UniqueID];
      ProductId = this.objProducts.getProductsData();
      this.objUtil.selectBindDs(ProdtID, ProductId, "PickPN", "PickPN_id");
      //Response.Write(NameValueCollection.[0].Value);
      ProdtID.DataSource = ProductID;
      ProdtID.DataBind();
  }
  </code></pre>