Populating the Menu - Navigation Control

[Guest]

How do I populate the menu control in 2.0 from a database. I know this can be
done with the Tree Control. Any code snippets? Thanks in advance.

 

[Guest]

Just check the following snippet of code and let me know whether this is
usefule to you

private void PopulateMenu()
{
DataSet ds = GetDataSetFromDatabase();
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);
}
}


}

private DataSet GetDataFromDatabase()
{
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;
}

 

[ReyN]

on this page is an example of another way of progrmmatically populating
a Menu control, without using relations

http://authors.aspalliance.com/aspxtreme/sys/web/ui/webcontrols/MenuItemClassNavigateUrl.aspx