asp.net Menu控件+SQLServer实现动态多级菜单

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.sqlClient;
using System.Data.ProviderBase;
public partial class _Default : System.Web.UI.Page
{
public int treEID;
protected void Page_Load(object sender,EventArgs E)
{
sqlConnection CN = new sqlConnection("server=.;Trusted_Connection=sspI;database=MENUDB"); //MENUDB是数据库名
//设定数据库操作命令
CN.open();
sqlCommand Scmd = new sqlCommand("SELEct * FROM tB_MENU where treEID=0 order by position",CN); //选出根菜单
sqlDataReader odr = Scmd.ExecuteReader();
while (odr.Read()) //循环读取
{ @H_168_6@menuItem menuNode = new MenuItem(); @H_168_6@menuNode.Text = odr["names"].ToString(); @H_168_6@menuNode.Value = odr["id"].ToString(); @H_168_6@menuNode.Enabled = true; @H_168_6@menuNode.NavigateUrl = odr["page"].ToString(); @H_168_6@menu1.Items.Add(menuNodE); //添加到根菜单
treEID = Convert.ToInt16(odr["id"].ToString());
addchildmenu(menuNodE);
}
//关闭数据库连接
Scmd.Connection.Close();
}
protected void addchildmenu(MenuItem pnodE) //添加子菜单
{
sqlConnection CN = new sqlConnection("server=.;Trusted_Connection=sspI;database=MENUDB");
?
//设定数据库操作命令
CN.open();
sqlCommand Scmd1 = new sqlCommand("SELEct * FROM tB_MENU where treEID=" + treEID + "",CN);
?
sqlDataReader odr = Scmd1.ExecuteReader();
while (odr.Read())
{ @H_168_6@menuItem menuNode = new MenuItem(); @H_168_6@menuNode.Text = odr["names"].ToString(); @H_168_6@menuNode.Value = odr["id"].ToString(); @H_168_6@menuNode.Enabled = true; @H_168_6@menuNode.NavigateUrl = odr["page"].ToString();
pnode.ChildItems.Add(menuNodE); //为当前菜单项添加子菜单
treEID = Convert.ToInt16(odr["id"].ToString());
addchildmenu(menuNodE); //循环添加子菜单
}
//关闭数据库连接
Scmd1.Connection.Close();
}
}