title: dropdown list wont populate values from database
body: <p>Hello everyone i need help. Ive been having this problem for almost a day now. dropdown list won't populate from database</p>
  
  <p>Below is the code i am using:</p>
  
  <p>&lt;%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="PhotoAlbum.aspx.vb" Inherits="PhotoAlbum" %></p>
  
  <p>
  
  </p>
  
   
              
                  Members Of Ephesians 5:10 Photo Album!
              
          
  
  <pre><code>&lt;asp:SqlDataSource ID="categoriesDataSource" runat="server" 
      ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;" 
  
  
  
      SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]"&gt;
      &lt;SelectParameters&gt;
          &lt;asp:QueryStringParameter Name="UserId" QueryStringField="ID"/&gt;
      &lt;/SelectParameters&gt;
  &lt;/asp:SqlDataSource&gt;
  
  &lt;br /&gt;
  
  &lt;br /&gt;
  
  &lt;h1 style="font-weight:bold"&gt;Filter Pictures By Category:
     &lt;asp:DropDownList ID="categories" runat="server" 
                      AppendDataBoundItems="True" 
                DataSourceID="categoriesDataSource" AutoPostBack="True"
  </code></pre>
  
  <p>DataTextField="Name" DataValueField="CategoryID">
                          
                      
          </p>
  
  <pre><code>&lt;/asp:Content&gt;
  </code></pre>
  
  <p>i need help pls</p>