title: ASP.NET How to display 2 column in dropdownlist?
body: <p>I use dropdownlist with SQLDataSource to add on dropdownlist. Since there is only 1 DataTextField to display, how can i add second one to it? I want to display description and workprocess on the list, here HTML code,</p>
  
  <pre><code>&lt;asp:DropDownList ID="DropDownWorkProcess" runat="server" DataSourceID="SqlDataSource1" DataTextField="Description" DataValueField="WorkProcess"&gt;
      &lt;/asp:DropDownList&gt;
      &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [Description], [WorkProcess] as workprocess FROM [tblWorkProcess]"&gt;&lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>If that cannot work, is there other easier simple way from 3rd party such as AJAX Toolkit?</p>