Dynamic Menu and Submenu with Cache Memory

Cs page

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using RelianceCommissionBAL;
using System.Web.Caching;
using RelianceCommissionDAL;

public partial class MasterPage : System.Web.UI.MasterPage
{
    DataTable DtSubMenu;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GenerateMenuItem();
        }
    }
    protected void lsLoginStatus_LoggedOut(object sender, EventArgs e)
    {
        Session.Clear();
        Session.Abandon();
    }
    public void GenerateMenuItem()
    {
        try
        {
            CommonBAL objCB = new CommonBAL();
            string userName = Convert.ToString(Session["UserName"]);
            TimeSpan ts = new TimeSpan(6, 0, 0);  
            DataSet DsMainMenu = new DataSet();
            if (Cache["MENU-SUBMENU"] == null)
            {
                DsMainMenu = objCB.GetNewFormRoleAllocation(null);
                Cache["MENU-SUBMENU"] = DsMainMenu;
                Cache.Insert("MENU-SUBMENU", DsMainMenu, null, Cache.NoAbsoluteExpiration, ts);
                LogData.InserLogData("MENU-SUBMENU- Caching Its processing with Database hit", this.Page.ToString());
            }
            else
            {
                DsMainMenu = (DataSet)Cache["MENU-SUBMENU"];
            }
            DtSubMenu = DsMainMenu.Tables[1].Select("UserName=" + "'" + userName + "'" + "").CopyToDataTable();
            RptMainMenu.DataSource = DsMainMenu.Tables[0].Select("UserName=" + "'" + userName + "'" + "").CopyToDataTable();
            RptMainMenu.DataBind();
        }
        catch (Exception ex)
        {
            string Errormsg = "Error Occurred In Binding Bucket Data " + PageVariableConstant.ErrorMsg;
            ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Xe54", "ShowAllMessages('" + Errormsg + "', 'e');", true);
            LogData.InserLogData(ex.ToString(), this.Page.ToString());
            ExceptionLogDAL.InsertExceptionLog(ex, "MasterPage.master.cs", "GenerateMenuItem", DateTime.Now, DateTime.Now, "GenerateMenuItem");

        }
    }
    protected void RptMainMenu_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            string MainMenuId = (e.Item.FindControl("hfMainMenuId") as HiddenField).Value;
            Repeater RptSubMenu = e.Item.FindControl("RptSubMenu") as Repeater;

            DataView dv = new DataView(DtSubMenu);
            dv.RowFilter = string.Format("ParentId={0}", Convert.ToInt32(MainMenuId));
            RptSubMenu.DataSource = dv;
            RptSubMenu.DataBind();
        }
    }

}

In DB

Create a menu Table in the Name and other columns if we want to like the img icon...etc of the menu, and set ID as the primary key. Create Submenu Table and add the menu Id as a foreign key in this table, according to shown below PFA.