title: How to bind SQL Server Time value to dropdown list in ASP.Net Web forms?
body: <p>I'm trying to figure out why this wont work.  Any help or insight would be appreciated.  I'm trying to bind to a Time column in the selected value for a drop down list:</p>
  
  <pre><code>&lt;asp:DropDownList ID="lblReadyTime" runat="server"
      DataTextFormatString="{0:htt}"
      SelectedValue='&lt;%#Bind("ReadyTime", "{0:htt}")%&gt;'&gt;
      &lt;asp:ListItem Text="12AM" Value="12AM" /&gt;
      &lt;asp:ListItem Text="1AM" Value="1AM" /&gt;
      &lt;asp:ListItem Text="2AM" Value="2AM" /&gt;
      &lt;asp:ListItem Text="3AM" Value="3AM" /&gt;
      &lt;asp:ListItem Text="4AM" Value="4AM" /&gt;
      &lt;asp:ListItem Text="5AM" Value="5AM" /&gt;
      &lt;asp:ListItem Text="6AM" Value="6AM" /&gt;
      &lt;asp:ListItem Text="7AM" Value="7AM" /&gt;
      &lt;asp:ListItem Text="8AM" Value="8AM" /&gt;
      &lt;asp:ListItem Text="9AM" Value="9AM" /&gt;
      &lt;asp:ListItem Text="10AM" Value="10AM" /&gt;
      &lt;asp:ListItem Text="11AM" Value="11AM" /&gt;
      &lt;asp:ListItem Text="12PM" Value="12PM" /&gt;
      &lt;asp:ListItem Text="1PM" Value="1PM" /&gt;
      &lt;asp:ListItem Text="2PM" Value="2PM" /&gt;
      &lt;asp:ListItem Text="3PM" Value="3PM" /&gt;
      &lt;asp:ListItem Text="4PM" Value="4PM" /&gt;
      &lt;asp:ListItem Text="5PM" Value="5PM" /&gt;
      &lt;asp:ListItem Text="6PM" Value="6PM" /&gt;
      &lt;asp:ListItem Text="7PM" Value="7PM" /&gt;
      &lt;asp:ListItem Text="8PM" Value="8PM" /&gt;
      &lt;asp:ListItem Text="9PM" Value="9PM" /&gt;
      &lt;asp:ListItem Text="10PM" Value="10PM" /&gt;
      &lt;asp:ListItem Text="11PM" Value="11PM" /&gt;
  &lt;/asp:DropDownList&gt;
  </code></pre>