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

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

谢谢，各位大大 --------------------编程问答--------------------

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 --------------------编程问答--------------------

引用 1 楼 wxr0323 的回复:

C# code
protected string GetLeftMenu()
        {
            StringBuilder LeftList = new StringBuilder();
            try
            {
                DataTable Dt_TotleMenu = SqlHelper.Return……

谢谢，，有没前台的代码 --------------------编程问答-------------------- 顶1楼 --------------------编程问答--------------------

引用 2 楼 qq_20122 的回复:

引用 1 楼 wxr0323 的回复:
C# code
protected string GetLeftMenu()
{
StringBuilder LeftList = new StringBuilder();
try
{
DataTable Dt_TotleMenu = SqlHelper.Return……

谢谢，，有没前台的代码

前台代码。。。。

<%=GetLeftMenu() %> --------------------编程问答--------------------

补充：.NET技术 ,  ASP.NET