Creating Dynamic Menus and Submenus in an ASP.NET Website

1. For this we first need to populate dropdown of Main Menu. Below is the code.
   
   1. protected void Page_Load(object sender, EventArgs e)
   2. {
   3. if (!IsPostBack)
   4. {
   5. FillddlMainMenu();
   6. }
   7. }
   9. public void FillddlMainMenu()
   10. {
   11. SqlConnection conn = new SqlConnection(connection);
   12. DataSet DS = new DataSet();
   13. SqlDataAdapter dataadapter = new SqlDataAdapter();
   14. SqlCommand cmd = new SqlCommand("Select MainMenuId,MainMenu from MainMenu", conn);
   15. //cmd.CommandType = CommandType.Text;
   16. dataadapter.SelectCommand = cmd;
   17. dataadapter.Fill(DS);
   18. ddlMainMenu.DataSource = DS;
   19. ddlMainMenu.DataBind();
   20. }
2. Double click on submit Button -> Now write the below code.
   
   1. protected void btnSubmenu_Click(object sender, EventArgs e)
   2. {
   3. int active;
   4. if (chkSActive.Checked)
   5. {
   6. active = 1;
   7. }
   8. else
   9. {
   10. active = 0;
   11. }
   12. SqlConnection conn = new SqlConnection(connection);
   13. string sql = "INSERT INTO SubMenu(SubMenu, Content, MenuOrder,ParentId, IsActive)VALUES('" + txtSubmenu.Text + "','" + txtSContent.Text + "'," + Convert.ToInt16(ddlSOrder.SelectedItem.Value) + "," + Convert.ToInt16(ddlMainMenu.SelectedItem.Value) + "," + active + ")";
   14. SqlCommand cmd = new SqlCommand(sql, conn);
   15. conn.Open();
   16. cmd.CommandType = CommandType.Text;
   17. cmd.ExecuteNonQuery();
   18. conn.Close();
   19. Response.Redirect("SuccessMsg.aspx");
   20. }

Step 8: Now to Show Menu Items we need to add another page. Add 2 Data lists for Main Menu(Horizontally) Submenus Items(Vertically).

Step 9: Now Write Code for populating Main Menu Items in datalist to show as menuBar.

Now we need to populate submenus on selected mainmenu link. We will write code on datalist ItemCommand event.

Step 10: datalist ->Properties ->Add ItemCommand Event.

Step 11: Run application (Press F5).

Summary

The Final Layouts Will be as given Below.

Summary

In this article, we discussed how to create a Web site with dynamic menus. The menus and related links were stored in a database and the menus were created at run-time by reading values from the database.