private void bindASPxNavBar()

    {

        DataTable dt = DB.FillDataTable_Pro("select item_clsname,item_clsno from bi_t_item_cls where item_flag=0 and len(item_clsno)=2");

        this.ASPxNavBar1.Groups.Clear();

        DevExpress.Web.ASPxNavBar.NavBarGroup group = new DevExpress.Web.ASPxNavBar.NavBarGroup();

        for (int i = 0; i < dt.Rows.Count; i++)

        {

           this.ASPxNavBar1.Groups.Add(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString());

       }

   

        for (int j = 0; j < this.ASPxNavBar1.Groups.Count; j++)

        {

            DataTable data = getwhere(this.ASPxNavBar1.Groups[j].Name);

            if(data!=null)

            {

            for (int h = 0; h < data.Rows.Count; h++)

            {

             

                    this.ASPxNavBar1.Groups[j].Items.Add(data.Rows[h][0].ToString(), data.Rows[h][1].ToString());

            

            }}

        }

    }

 

 

 

 private DataTable getwhere(string str)

    {

        DataTable data = DB.FillDataTable_Pro(string.Format("select item_clsname,item_clsno from bi_t_item_cls where item_flag=0 and item_clsno like '{0}%' and len(item_clsno)=4", str));

        if (data.Rows.Count != 0)

        {

            return data;

        }

        else

        {

            return null;

        }

    }