Remplir un menu depuis une base de données

 01/01/2019 |   Admin |  Sql Server


protected void makeMenu()

    {

        DataSet ds = GetDataSetForMenu();

 

        foreach (DataRow parentItem in ds.Tables["Categories"].Rows)

        {

            MenuItem categoryItem = new MenuItem((string)parentItem["CategoryName"]);

            menuAsp.Items.Add(categoryItem);

 

            foreach (DataRow childItem in parentItem.GetChildRows("Children"))

            {

                MenuItem childrenItem = new MenuItem((string)childItem["ProductName"]);

                categoryItem.ChildItems.Add(childrenItem);

            }

        }

    }

 

 

    private DataSet GetDataSetForMenu()

    {

        string connec = La ConnectionString;

 

        SqlConnection myConnection = new SqlConnection(connec);

        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;

 

    }   

 

Lire >>

  • 1