title: dropdownlist values and text need trimmed
body: <p>I have a dropdownlist which is being populated by a sqldatasource and when I look at the HTML created afterwards there's a lot of spaces in the value and text. This must because the length of the fields in the database is 50.</p>
  
  <p>e.g.</p>
  
  <p>The HTML is like this</p>
  
  <pre><code>        &lt;select name="DropDownList1" onchange="javascript:setTimeout('__doPostBack(\'DropDownList1\',\'\')', 0)" id="DropDownList1" style="height:23px;width:148px;"&gt;
      &lt;option value="IT  Dev                                           "&gt;IT  Dev                                           &lt;/option&gt;
      &lt;option value="Marketing                                         "&gt;Marketing                                         &lt;/option&gt;
      &lt;option value="HR                                                "&gt;HR                                                &lt;/option&gt;
      &lt;option selected="selected" value="Finance                                           "&gt;Finance                                           &lt;/option&gt;
      &lt;option value="Corporate                                         "&gt;Corporate                                         &lt;/option&gt;
      &lt;option value="IT Support                                        "&gt;IT Support                                        &lt;/option&gt;
  
  &lt;/select&gt;
  </code></pre>
  
  <p>The controls source is:</p>
  
  <pre><code>        &lt;asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
              DataValueField="dept_name" Height="23px" Width="148px"&gt;
              &lt;asp:ListItem Text="All" Value="%"&gt;&lt;/asp:ListItem&gt;
          &lt;/asp:DropDownList&gt;
  
          &lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="&lt;%$ ConnectionStrings:scConnString %&gt;"
              SelectCommand="SELECT dept_name FROM depts"&gt;&lt;/asp:SqlDataSource
  </code></pre>
  
  <p>Can I trim the values in my sql, or the items in the dropdownlist after it has been populated?</p>
  
  <p>Any ideas?</p>