title: Dropdown.SelectedItem.Text isnt setting value properly
body: <p>I have the following dropdown </p>
  
  <pre><code>&lt;asp:dropdownlist id="ddlCardStatus" runat="server" Width="150px"&gt;
    &lt;asp:ListItem Value="E0" Text="Active" &gt;&lt;/asp:ListItem&gt;
    &lt;asp:ListItem Value="E1" Text="Block"&gt;&lt;/asp:ListItem&gt;
  &lt;/asp:dropdownlist&gt;
  </code></pre>
  
  <p>My dropdown default selected text always remains <code>Active</code> even when I get <code>Block</code> in my dataset. </p>
  
  <p>I guess I'm setting it wrong
  Here's the code of setting value recieved from dataset</p>
  
  <pre><code>ddlCardStatus.SelectedItem.Text = ddlCardStatus.Items.FindByValue(
       IIf(IsDBNull(ds.Tables(0).Rows(0).Item("Status")), 0, 
                   ds.Tables(0).Rows(0).Item("Status"))).Value
  </code></pre>
  
  <p><strong>EDITED</strong> This is the part of the stored procedure that is selecting <code>Status</code></p>
  
  <pre><code>Select ID,case status when 'E0' then 'Active' when 'E1' then 'Block' end as 'Status' from temp
  </code></pre>