How to populate menu from the SiteMapDataSourc, Database, xml files.

  How to populate menu from the SiteMapDataSourc, Database, xml files.

Populating using the SiteMapDataSource:

  private void  CreateMenuControl()
    {

        Menu1.DataSource = GetSiteMapDataSource();
        Menu1.DataBind();         
            
    }
 
    private  SiteMapDataSource GetSiteMapDataSource()
    {
        XmlSiteMapProvider xmlSiteMap =  new  XmlSiteMapProvider();
        System.Collections.Specialized.NameValueCollection myCollection =  new  System.Collections.Specialized.NameValueCollection(1);
        myCollection.Add("siteMapFile", "Web.sitemap");
        xmlSiteMap.Initialize("provider", myCollection);
        xmlSiteMap.BuildSiteMap();

        SiteMapDataSource siteMap =  new  SiteMapDataSource();

         return  siteMap;
    }

Populating using Database:

  private void  PopulateMenu()
    {
        DataSet ds = GetDataSetForMenu(); 
        
        Menu menu =  new  Menu();
            
         foreach  (DataRow parentItem  in  ds.Tables["Categories"].Rows)
        {
            MenuItem categoryItem =  new  MenuItem(( string )parentItem["CategoryName"]);
            menu.Items.Add(categoryItem);

             foreach  (DataRow childItem  in  parentItem.GetChildRows("Children"))
            {
                MenuItem childrenItem =  new  MenuItem(( string )childItem["ProductName"]);
                categoryItem.ChildItems.Add(childrenItem);
            }
        }

        Panel1.Controls.Add(menu);
        Panel1.DataBind(); 

    }
    
   private  DataSet GetDataSetForMenu()
    {
        SqlConnection myConnection =  new  SqlConnection(GetConnectionString());
        SqlDataAdapter adCat =  new  SqlDataAdapter("SELECT * FROM Categories", myConnection);
        SqlDataAdapter adProd =  new  SqlDataAdapter("SELECT * FROM Products", myConnection);

        DataSet ds =  new  DataSet();
        adCat.Fill(ds, "Categories");
        adProd.Fill(ds, "Products"); 

        ds.Relations.Add("Children",ds.Tables["Categories"].Columns["CategoryID"],ds.Tables["Products"].Columns["CategoryID"]);
         return  ds; 

    }    

XML file to populate the menu:

Web.sitemap is also a simple xml file. But I just wanted to show that you can also populate the menu using ordinary XML file.

  private void  CreateMenuWithXmlFile()
    {
         string  path = @"C:\MyXmlFile.xml";
        DataSet ds =  new  DataSet();
        ds.ReadXml(path);

        Menu menu =  new  Menu();
        menu.MenuItemClick +=  new  MenuEventHandler(menu_MenuItemClick);


         for  ( int  i = 0; i < ds.Tables.Count; i++)
        {
            MenuItem parentItem =  new  MenuItem(( string )ds.Tables[i].TableName);
            menu.Items.Add(parentItem);


             for  ( int  c = 0; c < ds.Tables[i].Columns.Count; c++)
            {
                MenuItem column =  new  MenuItem(( string )ds.Tables[i].Columns[c].ColumnName);
                menu.Items.Add(column);


                 for  ( int  r = 0; r < ds.Tables[i].Rows.Count; r++)
                {
                    MenuItem row =  new  MenuItem(( string )ds.Tables[i].Rows[r][c].ToString());
                    parentItem.ChildItems.Add(row); 
                }
            }
            
          
        }

转载于:https://www.cnblogs.com/Amanda2007/archive/2007/11/26/972610.html