protected void Page_Load(object sender, EventArgs e) { rec = new plantsoverflowEntities(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString); con.Close(); con.Open(); if(home.token == "home" || contact.token == "contact") { RadMenu1.Enabled = false;//make sure does not persist on other page loads RadMenu1.Visible = false; home.token = ""; contact.token = ""; } if (recipe.token == "recipe") { SqlCommand cmd = new SqlCommand("SELECT * FROM menurecipe", con); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet links = new DataSet(); adapter.Fill(links); RadMenu1.DataTextField = "ptext"; RadMenu1.DataFieldID = "id"; //RadMenu1.DataFieldParentID = "id"; RadMenu1.DataSource = links; RadMenu1.DataBind(); recipe.token = ""; } if (gardenguide.token == "gardenguide") { SqlCommand cmd = new SqlCommand("SELECT * FROM menuyear", con); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet links = new DataSet(); adapter.Fill(links); RadMenu1.DataTextField = "ptext"; RadMenu1.DataFieldID = "id"; //RadMenu1.DataFieldParentID = "id"; RadMenu1.DataSource = links; RadMenu1.DataBind(); gardenguide.token = ""; } if (kids.token == "kids") { SqlCommand cmd = new SqlCommand("SELECT * FROM menukids", con); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet links = new DataSet(); adapter.Fill(links); RadMenu1.DataTextField = "ptext"; RadMenu1.DataFieldID = "id"; //RadMenu1.DataFieldParentID = "id"; RadMenu1.DataSource = links; RadMenu1.DataBind(); kids.token = ""; } con.Close(); //comments to be loaded }
//private void LoadMenu() //{ // string pageName = this.Page.ToString().Substring(4, this.Page.ToString().Substring(4).Length - 5) + ".aspx"; // string[] page = pageName.Split('_'); // int id = 1; // switch (page[1]) // { // case "home.aspx": // id = 1; // break; // case "": // break; // case "": // break; // case "": // break; // case "": // break; // }; //} private void getMenu(int id) { RadMenu1.Items.Clear(); rec = new plantsoverflowEntities(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString); con.Open(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); string sql = "Select * from MainMenu"; SqlDataAdapter da = new SqlDataAdapter(sql, con); da.Fill(ds); dt = ds.Tables[0]; DataRow[] drowpar = dt.Select("ParentID=" + 0 + " and MenuID=" + 4); foreach (DataRow dr in drowpar) { RadMenuItem eg = new RadMenuItem(); eg.Text = dr["MenuText"].ToString(); eg.Value = dr["MenuID"].ToString(); RadMenu1.Items.Add(eg); } DataRow[] sm = dt.Select("ParentID >" + 0); foreach (DataRow dr in sm) { RadMenuItem mnu = new RadMenuItem(dr["MenuText"].ToString(), "#"); RadMenuItem rmi = RadMenu1.FindItemByValue(dr["ParentID"].ToString()); if (rmi != null) { RadMenu1.FindItemByValue(dr["ParentID"].ToString()).Items.Add(mnu); } } con.Close(); RadMenu1.DataBind(); }