title: DataBinding DropDownList in C#/ASP.NET
body: <p>I have a search.aspx page that has this:</p>
  
  <pre><code>  &lt;asp:DropDownList id="ddlPopulation" runat="server" DataTextField="population" DataValueField="pid"&gt;
                  &lt;/asp:DropDownList&gt;
  </code></pre>
  
  <p>I then have a data bind on page_load:</p>
  
  <pre><code> StringBuilder sql = new StringBuilder();
  
      // Define sql
      sql.Append("SELECT pid, population ");
      sql.Append("FROM populations ");
      sql.Append("ORDER BY pid ASC ");
  
     IDataReader reader = SqlHelper.GetDataReader(sql.ToString());
  
      ddlPopulation.DataSource = reader;
      ddlPopulation.DataBind();
  </code></pre>
  
  <p>How do I:</p>
  
  <ol>
  <li>Add a default value/text pair to the list not in the database, like All populations?</li>
  <li>How do I get to do a string replace on the population data field before its shown on screen?</li>
  </ol>