menu and submenu with atored procedure

[jellybeannn]

Hi everyone, I've got a DepartmenstList and CategoriesList user controls, which works with stored procedures, when the a department is selected, only then is that departments categories listed. What I need help with is, when a department is selected I want the categories to display as a submenu to the selected department. I have no idea how to accomplish this with stored procedures involved.

Any help will be appreciated.

DepartmentsList.ascx

<asp:Repeater ID="Department" runat="server" >  
<HeaderTemplate>  
<ul>  
</HeaderTemplate>  
<ItemTemplate>  
<li>
      <asp:HyperLink ID="HyperLink1" Runat="server" 
      NavigateUrl='<%# Link.ToDepartment(Eval("DepartmentID").ToString())%>'
      Text='<%# HttpUtility.HtmlEncode(Eval("Name").ToString()) %>'
      ToolTip='<%# HttpUtility.HtmlEncode(Eval("Description").ToString()) %>'
      CssClass='<%# Eval("DepartmentID").ToString() == Request.QueryString["DepartmentID"] ? "DepartmentSelected" : "DepartmentUnselected" %>' />
</li>  
</ItemTemplate>  
<FooterTemplate>  
</ul>  
</FooterTemplate> 
</asp:Repeater>

DepartmentsList.ascx.cs

// Load department details into the DataList
    protected void Page_Load(object sender, EventArgs e)
    {
            // don't reload data during postback
        if (!IsPostBack)
        {
                // CatalogAccess.GetDepartments returns a DataTable object containing
                // department data, which is read in the ItemTemplate of the DataList
            Department.DataSource = CatalogAccess.GetDepartments();
                // Needed to bind the data bound controls to the data source
            Department.DataBind();
        }
     }

CategoriesList.ascx

<asp:Repeater ID="Category" runat="server" >  
<HeaderTemplate>  
<ul>  
</HeaderTemplate>  
<ItemTemplate>  
<li>
        <asp:HyperLink ID="HyperLink1" Runat="server" 
            NavigateUrl='<%# Link.ToCategory(Request.QueryString["DepartmentID"],Eval("CategoryID").ToString()) %>'
            Text='<%# HttpUtility.HtmlEncode(Eval("Name").ToString()) %>'
            ToolTip='<%# HttpUtility.HtmlEncode(Eval("Description").ToString()) %>'
            CssClass='<%# Eval("CategoryID").ToString() == Request.QueryString["CategoryID"] ? "CategorySelected" : "CategoryUnselected" %>' /> 
</li>  
</ItemTemplate>  
<FooterTemplate>  
</ul>  
</FooterTemplate> 
</asp:Repeater>

CategoriesList.ascx.cs

public partial class UserControls_CategoriesList : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
            // don't reload data during postback
        if (!IsPostBack)
        {
                // obtain the Id of the selected department
            string departmentId = Request.QueryString["DepartmentID"];
                // continue only if the DepartmentId exists in the query string
            if (departmentId != null)
            {
                    // Catalog.GetCategorieInDepartment(departmentId);
                    // object containg a category data, which is displayed by the dataList
                Category.DataSource =
                    CatalogAccess.GetCategoriesInDepartment(departmentId);
                    // needed to bind the data bound controls to the source
                Category.DataBind();
            }
        }
    }
}