Menu 怎么绑定数据库中的数据

Question

 Menu有三级菜单横向的 ！怎么绑定数据库中的数据 、
给个例子 ：前台+后台+数据库
谢谢，各位大大

Answer 1

protected string GetLeftMenu()
        {
            StringBuilder LeftList = new StringBuilder();
            try
            {
                DataTable Dt_TotleMenu = SqlHelper.ReturnDataTable("select * from Ziye_Menu", CommandType.Text);//取出所有数据
                DataRow[] drMenu = Dt_TotleMenu.Select("Menu_Fid=0 and Menu_able=1");//取出所有启用的父节点
                DataTable LeftMenuTable = new DataTable();//构建父节点的table
                LeftMenuTable = drMenu[0].Table.Clone();
                foreach (DataRow dr in drMenu)
                {
                    LeftMenuTable.ImportRow(dr);
                }                if (LeftMenuTable.Rows.Count != 0)
                {
                    for (int i = 0; i < LeftMenuTable.Rows.Count; i++)
                    {
                        LeftList.Append("<div class=\"accordionHeader\">");
                        LeftList.Append("<h2><span>Folder</span>" + LeftMenuTable.Rows[i]["Menu_Name"].ToString() + "</h2>");
                        LeftList.Append("</div>");
                        LeftList.Append("<div class=\"accordionContent\" style=\"display:block;\">");                        LeftList.Append("<ul class=\"tree treeFolder\">");                        //获取子节点的table
                        DataRow[] drSencondMenu = Dt_TotleMenu.Select("Menu_Fid='" + LeftMenuTable.Rows[i]["Menu_ID"] + "' and Menu_able=1");
                        DataTable SecondTable = new DataTable();
                        SecondTable = drSencondMenu[0].Table.Clone();
                        foreach (DataRow dr in drSencondMenu)
                        {
                            SecondTable.ImportRow(dr);
                        }
                        if (SecondTable.Rows.Count != 0)
                        {
                            //遍历拼接子节点的HTML
                            for (int j = 0; j < SecondTable.Rows.Count; j++)
                            {
                                LeftList.Append("<li><a href=\"" + SecondTable.Rows[j]["Menu_Url"] + "\" target=\"navTab\" rel=\"" + SecondTable.Rows[j]["Menu_Rel"] + "\">" + SecondTable.Rows[j]["Menu_Name"] + "</a></li>");
                            }
                        }
                        LeftList.Append("</ul>");
                        LeftList.Append("</div>");
                    }                }
                return LeftList.ToString();            }
            catch (Exception err)
            {
                return "没菜单";
            }
        }可以动态输出html

Answer 2

前台代码。<%=GetLeftMenu() %>