ASPxNavBar 代码绑定数据的方法

方法一：

 public void MyGetDate()
    {
        string sSql = @"select * from sModule where ParentIndex='0' and SystemId='1000'";

        DataTable table = CommClass.GetDataTable(sSql);

        ASPxNavBar1.Groups.Clear();

        int i = 0;

        foreach (DataRow dr in table.Rows)
        {
            ASPxNavBar1.Groups.Add(dr["ModuleName"].ToString());           

            this.MyGetSecond(dr["ModuleId"].ToString(),i++);
        }

    }

    public void MyGetSecond(string sParent,int i)//加子集
    {
        DevExpress.Web.ASPxNavBar.NavBarItem item = null;

        string sSql = String.Format(@"select * from sModule where ParentIndex='{0}' and  SystemId='1000'",sParent);// ParentIndex='0' and
        //string sSql = "select Did, MenuName from WebMenu where MenuKind=1 order by SeqIndex";
        DataTable table = CommClass.GetDataTable(sSql);

        if (table.Rows.Count > 0)
        {
            foreach (DataRow row in table.Rows)
            {
                string sDid = row["Did"].ToString();
                string sName = row["ModuleName"].ToString();
                string sUrl = string.Format("webArticle.aspx?menudid={0}", sDid);

                item = new DevExpress.Web.ASPxNavBar.NavBarItem(sName, sName, "", sUrl);

                ASPxNavBar1.Groups[i].Items.Add(item);
            }
        }
    }

 

 

方法二：

 string strSql = @"select * from sModule where SystemId='1000' and ParentIndex=0";
        DataTable table = CommClass.GetDataTable(strSql);

        foreach (DataRow  dr in table.Rows)
        {
            DevExpress.Web.ASPxNavBar.NavBarGroup NavBarGroup1=new DevExpress.Web.ASPxNavBar.NavBarGroup(dr["ModuleName"].ToString());
            this.ASPxNavBarsModule.Groups.Add(NavBarGroup1);

            strSql = @"select * from sModule where ParentIndex=" + dr["ModuleId"].ToString() + " order by ModuleIndex desc";
            DataTable dt = CommClass.GetDataTable(strSql);
            foreach (DataRow dr1 in dt.Rows)
            {
                DevExpress.Web.ASPxNavBar.NavBarItem NavBarItem1=new DevExpress.Web.ASPxNavBar.NavBarItem(dr1["ModuleName"].ToString());
                NavBarGroup1.Items.Add(NavBarItem1);
            }
        }