(ext.) ASP. Repeater and Level two menu

Let's start with a picture that shows the menu we want to implement:

This menu only achieves level 2 ha.

The method I used was to nest 2 repeater.

First look at the table structure in the database:

Data:

On the code:

aspx

2. <asp:repeater id="Rptmenus" runat="server "
4. onitemdatabound="Rptmenus_itemdatabound">
6. <headertemplate>
8. <ul class="mnuLevel01">
10. <li id="Mnuhome"><a href="#"> Home </a> </li>
12. </headertemplate>
14. <ItemTemplate>
16. <li class="Multiitem">
18. <a target= "<% #DataBinder. Eval (Container.DataItem," target")%>" href= "<% #DataBinder. Eval (Container.DataItem, "Url")%> "><% #DataBinder. Eval (Container.DataItem," Title ")%></a>
20. <asp:repeater id="Rptsubmenus" runat= "server">
22. <headertemplate>
24. <ul class="mnuLevel02">
26. </headertemplate>
28. <ItemTemplate>
30.                      <li> <a href= "<%# DataBinder.Eval (Container.DataItem, "Url")  %> "><% #DataBinder. Eval (Container.DataItem, "Title")  %>a></li > 
32. </ItemTemplate>
34. <footertemplate>
36. </ul>
38. </footertemplate>
40. </asp:repeater>
42. </li>
44. </ItemTemplate>
46. <footertemplate>
48. </ul>
50. </footertemplate>
52. </asp:repeater>

CS Code:

2. Private DataSet dsmenus;//Menu
6. protected void Page_Load (object sender, EventArgs e)
8. {
10. Binding Main Menu
12. String connstr = "Data source=ip address; Initial catalog= database name; User id=sa;password= password; ";
14. SqlConnection conn = new SqlConnection (CONNSTR);
16. Conn. Open ();
20. String cmdtext = "SELECT * from Ep_menus WHERE status=1 ORDER by OrderID asc,id ASC";
22. SqlCommand cmd = new SqlCommand (CMDTEXT, conn);
26. SqlDataAdapter adapter = New SqlDataAdapter (Cmdtext, connstr);
28. Dsmenus = new DataSet ();
30. Adapter. Fill (Dsmenus);
34. DataView Dvtopmenus = new DataView (Dsmenus.tables[0]);
36. dvtopmenus.rowfilter = "[parent]=0";
38. Rptmenus.datasource = dvtopmenus;
40. Rptmenus.databind ();
42. }
44. protected void Rptmenus_itemdatabound (object sender, RepeaterItemEventArgs e)
46. {
48. if (e.item.itemtype = = ListItemType.Item | | E.item.itemtype = = ListItemType.AlternatingItem)
50. {
52. Repeater Rptsmenus = (Repeater) e.item.findcontrol ("Rptsubmenus");
54. DataRowView DRV = (DataRowView) e.Item.DataItem;
58. int Pmenu = Convert.ToInt32 (drv["id"]);//parent menu ID
60. if (Pmenu! = 0)
62. //{
64. DataView Dvsubmenus = new DataView (Dsmenus.tables[0]);
66. dvsubmenus.rowfilter = "[parent]=" + pmenu;
70. if (Dvsubmenus.count > 0)
72. {
74. Rptsmenus.datasource = dvsubmenus;
76. Rptsmenus.databind ();
78. }
80. //}
82. }
84. }

Here is just a general idea and code, specific repeater and other information please refer to other tutorials.

(ext.) ASP. Repeater and Level two menu