title: ASP.NET dropdownlist binding does not work
body: <p>In ASP.NET I'm trying to bind the text of a dropdownlist with data from a database. In the list I got all the correct values that are used for that certain column, but the shown value does not correspond to the one in the database. For value B the value is shown correctly, but for the other values it is showing value A.
  Does anyone as an idea?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>The DropDownList is used as a column in a Gridview and I tried to add the values in multiple ways. For the Column with value 'Lijndienst' it is working fine, but for all the other it just shows 'Green transport' </p>
  
  <pre><code> &lt;asp:TemplateField HeaderText="Transport"&gt;
          &lt;ItemTemplate&gt;
              &lt;asp:Label ID="lblTransport" runat="server" Text='&lt;%# Bind("Transport") %&gt;' Visible="false" &gt;&lt;/asp:Label&gt;
              &lt;asp:DropDownList ID="ddlTransport" runat="server" Width="150px" Height="20px" &gt;
                  &lt;%--&lt;asp:ListItem Text="Geen transport"&gt;&lt;/asp:ListItem&gt;
                  &lt;asp:ListItem Text="Lijndienst"&gt;&lt;/asp:ListItem&gt;
                  &lt;asp:ListItem Text="Intercity"&gt;&lt;/asp:ListItem&gt;
                  &lt;asp:ListItem Text="Firma Piping"&gt;&lt;/asp:ListItem&gt;
                  &lt;asp:ListItem Text="Firma E&amp;I"&gt;&lt;/asp:ListItem&gt;
                  &lt;asp:ListItem Text="Zwaar"&gt;&lt;/asp:ListItem&gt;--%&gt;
              &lt;/asp:DropDownList&gt;
          &lt;/ItemTemplate&gt;
      &lt;/asp:TemplateField&gt;
  
   DropDownList ddlTransport = (e.Row.FindControl("ddlTransport") as DropDownList);
          Label lblTransport = (e.Row.FindControl("lblTransport") as Label);
          ddlTransport.DataSource = GetData("SELECT Transport FROM Transport", "Transport");
          ddlTransport.DataTextField = "Transport";
          ddlTransport.DataValueField = "Transport";
          ddlTransport.DataBind();
          ddlTransport.SelectedValue = lblTransport.Text;
  </code></pre>