-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: VBGURU
Message 2 in Discussion
www.aravinda.in www.code.aravinda.in www.fun.aravinda.in www.kedge.aravinda.in
www.live.aravinda.in www.search.aravinda.in The below code should give an
idea how to populate menu using sql server data private void PopulateMenu()
{
DataSet ds = GetDataSet();
Menu menu = new Menu(); foreach (DataRow parentItem in
ds.Tables["tblMenu"].Rows)
{
MenuItem mnuItem = new MenuItem((string)parentItem["CategoryName"]);
menu.Items.Add(mnuItem); foreach (DataRow childItem in
parentItem.GetChildRows("Children"))
{
MenuItem childrenItem = new MenuItem((string)childItem["ProductName"]);
mnuItem.ChildItems.Add(childrenItem);
}
} Panel1.Controls.Add(menu);
Panel1.DataBind();
} private DataSet GetDataSet()
{
SqlConnection myConnection = new SqlConnection(GetConnectionString());
SqlDataAdapter adCat = new SqlDataAdapter("SELECT * FROM tblMenu",
myConnection);
SqlDataAdapter adProd = new SqlDataAdapter("SELECT * FROM tblmnuChildren",
myConnection); DataSet ds = new DataSet();
adCat.Fill(ds, "tblMenu");
adProd.Fill(ds, "tblmnuChildren");
ds.Relations.Add("Children",
ds.Tables["tblMenu"].Columns["CategoryID"],
ds.Tables["mnuChildren"].Columns["CategoryID"]);
return ds;
} www.aravinda.in www.code.aravinda.in www.fun.aravinda.in
www.kedge.aravinda.in www.live.aravinda.in www.search.aravinda.in
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
