title: Data bound DropDownList
body: <p>I have a field 'oStatus' which I set as a List Box Value List in MS Access, with row source: Cancelled; Ordering; Pending; Processing and I have configured my DropDownList control to the data source. </p>
  
  <p>However when i click on the drop down in my webpage, the control only shows the field's result (Eg. Ordering). How can i can i get it to show other items in the dropdownlist as well? (Cancelled, Pending, Processing, etc.)</p>
  
  <pre><code>&lt;asp:DropDownList ID="DropDownList1" runa4="server" 
                          DataSourceID="AccessDataSource7" DataTextField="oStatus" 
                          DataValueField="oStatus"&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:AccessDataSource ID="AccessDataSource7" runat="server" 
                         DataFile="~/App_Data/DB.mdb" 
                          SelectCommand="SELECT [oStatus] FROM [ordersTable] WHERE (oOrderNo = ?)"&gt;
                          &lt;SelectParameters&gt;
                              &lt;asp:QueryStringParameter Name="?" QueryStringField="oOrderNo" /&gt;
                          &lt;/SelectParameters&gt;
                      &lt;/asp:AccessDataSource&gt;
  </code></pre>
  
  <p>MS Access</p>
  
  <p>Field: oStatus</p>
  
  <p>Row Source Type: Value List</p>
  
  <p>Row Source: Cancelled;Ordering;Pending;Processing</p>