问题描述
急求中，谢谢好心人了~~~~
解决方案
解决方案二：
usingSystem;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingDataProvider;usingWavenetWebFrameWork.FrameWorkBase.PageBase;namespaceWaveDBMS{publicpartialclassNewMenu:System.Web.UI.Page{#regionARGSprivateTreeNode[]treF,treC,treGs;privateTreeNodetreG;privatestring[]strF,strC,strCL,strGs,strGsL;privatestringstrCon,strDBType,strUID;protectedDataProviderFactorydpf;privatestringstrSqlF,strSqlC,strSqlGs;privateDataTabledtF,dtC,dtGs;privateintintFRowsLength,intCRowsLength,intGsRowsLength;PageBasepb=newPageBase();publicstringUserID{get{returnstrUID;}set{strUID=value;}}#endregionprotectedvoidPage_Load(objectsender,EventArgse){strCon=System.Configuration.ConfigurationSettings.AppSettings.Get("UserAppData");strDBType=System.Configuration.ConfigurationSettings.AppSettings.Get("UserAppDataType");strCon="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=""+strCon+"";PersistSecurityInfo=True";strCon=pb.userappdata;dpf=newDataProviderFactory(strDBType,strCon,"");strUID="1";if(!IsPostBack){treG=newTreeNode();treG.Text="排水行业数据库";treG.ImageUrl="~/Images/database1.gif";this.TreeV.Nodes.Add(treG);this.BuildTrees();}}protectedvoidBuildTrees(){strSqlF="SELECTID,MENUNAME,LINKURLFROMMENUWHEREPARENTID=-1";StringstrSqlF4="";strSqlF4="SELECTMENU.IDASAA,MENU.MENUNAMEASBB,MENU.LINKURLASCC,MENU.PARENTIDASDD";strSqlF4+="FROMMENU,RULES,ROLE2RULE";strSqlF4+="WHEREMENU.ID=RULES.MENUID";strSqlF4+="ANDRULES.RULEID=ROLE2RULE.RULEID";strSqlF4+="ANDROLE2RULE.ROLEID="+strUID;strSqlF4+="ANDROLE2RULE.RULEACTIONVALUE=1";//strSqlF="SELECTMENU2.AA,MENU2.BB,MENU2.CC,MENU2.DDFROM("+strSqlF4+")MENU2WHEREMENU2.DD=-1";dtF=dpf.GetData(strSqlF);intFRowsLength=dtF.Rows.Count;if(intFRowsLength<1){return;}strF=newstring[intFRowsLength];treF=newTreeNode[intFRowsLength];for(inti=0;i<intFRowsLength;i++){strF[i]=dtF.Rows[i][1].ToString();treF[i]=newTreeNode();treF[i].Text=strF[i];treF[i].CollapseAll();treF[i].ImageUrl="~/Images/database2.gif";this.treG.ChildNodes.Add(treF[i]);//////////////////strSqlC="SELECTID,MENUNAME,LINKURLFROMMENUWHEREPARENTID="+dtF.Rows[i][0].ToString();//strSqlC="SELECTMENU2.AA,MENU2.BB,MENU2.CC,MENU2.DDFROM("+strSqlF4+")MENU2WHEREMENU2.DD="+dtF.Rows[i][0].ToString();dtC=dpf.GetData(strSqlC);intCRowsLength=dtC.Rows.Count;strC=newstring[intCRowsLength];strCL=newstring[intCRowsLength];treC=newTreeNode[intCRowsLength];for(intj=0;j<intCRowsLength;j++){strSqlGs="SELECTID,MENUNAME,LINKURLFROMMENUWHEREPARENTID="+dtC.Rows[j][0].ToString();dtGs=dpf.GetData(strSqlGs);intGsRowsLength=dtGs.Rows.Count;strC[j]=dtC.Rows[j][1].ToString();strCL[j]=dtC.Rows[j][2].ToString();treC[j]=newTreeNode();treC[j].CollapseAll();treC[j].Text=strC[j];treC[j].NavigateUrl=strCL[j];treC[j].Target="MainData";treC[j].ImageUrl="~/Images/database3.gif";if(intGsRowsLength>0){treC[j].ImageUrl="~/Images/database2.gif";}treF[i].ChildNodes.Add(treC[j]);/////if(intGsRowsLength==0){continue;}strGs=newstring[intGsRowsLength];strGsL=newstring[intGsRowsLength];treGs=newTreeNode[intGsRowsLength];for(inth=0;h<intGsRowsLength;h++){strGs[h]=dtGs.Rows[h][1].ToString();strGsL[h]=dtGs.Rows[h][2].ToString();treGs[h]=newTreeNode();treGs[h].Text=strGs[h];treGs[h].NavigateUrl=strGsL[h];treGs[h].Target="MainData";treGs[h].ImageUrl="~/Images/database3.gif";treC[j].ChildNodes.Add(treGs[h]);}}}}}}
解决方案三：
用XML存储数据，用TREEVIEW绑定就行了，如果还要进行权限设置的话，再建个关联表根据表里设定的菜单展现
解决方案四：
if(!this.Page.IsPostBack){stringMySQL="selectfuncname,funccnamefrompdefNetRightorderbyOrderID";SqlDataReaderMyReader=MydbClass.MyReturnReader(MySQL);//调用函数MyReturnReader返回给MyReader(这里调用自已写的类。)try{//对用户权限判断,进行对Tree的控制while(MyReader.Read()){TreeNodeMyNodes=newTreeNode();MyNodes.Text=MyReader["funccname"].ToString();MyNodes.NavigateUrl=MyReader["funcname"].ToString();Tree1.Nodes.Add(MyNodes);}}}catch{MydbClass.MyConClose();//关闭MyReader数据集return;}}
楼主这是最基本的邦定例子
解决方案五：
usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;publicpartialclassTKKMTest_KnowDotMenu:BasePage{publicstringstrNav="../KnowDot/KnowDotEdit.aspx?editmode=unable&kminfo={0}&pkdinfo={1}";privateint_kmID;privateDataTabledt=null;protectedvoidPage_Load(objectsender,EventArgse){if(!Page.IsPostBack){//判断kmID是否为空或者是否为正整数if(Request.QueryString["kmID"]!=null&&InterService.Utility.ValidateHelper.IsInteger(Request.QueryString["kmID"])==true){_kmID=int.Parse(Request.QueryString["kmID"]);}else{InterService.Utility.Utils.throwErrorAndClose("kmID参数类型不对","parent");}ShowKnowDotTree();}}#region生成知识点树///<summary>///生成知识点树///</summary>privatevoidShowKnowDotTree(){try{InterService.TestBll.TestKnowDotBztkdb=newInterService.TestBll.TestKnowDotBz();dt=tkdb.getData(_kmID);}catch(Exceptionex)//如果出现异常，则提示用户{InterService.Utility.Utils.throwErrorAndClose("生成知识点树失败："+ex.Message,"parent");return;}if(dt==null||dt.Rows.Count==0)//如果为空，则说明当前科目下没有相应的知识点{stringkmtm=_kmID.ToString()+"~"+Request["KMName"];strNav=string.Format(strNav,HttpUtility.UrlEncode(kmtm),HttpUtility.UrlEncode("0~无"));InterService.Utility.Utils.throwErrorAndClose("不存在该科目下的知识点，请先新建知识点","parent");//InterService.Utility.Utils.throwErrorGotoURL("不存在该科目下的知识点，请先新建知识点",strNav,"parent");return;}else{TreeNodenode=newTreeNode();DataRow[]dr=dt.Select("I_ParentID=0","I_OrderID");//筛选得到所有的根结点this.KnowDotTreeView.ShowLines=true;BindKnowDotTree(dr,node);}}///<summary>///递归生成知识点树///</summary>///<paramname="dr">DataRow[]数组，经过DataTable.Select筛选</param>///<paramname="node">当前节点</param>privatevoidBindKnowDotTree(DataRow[]dr,TreeNodenode){foreach(DataRowdr1indr){if(dr1["I_ParentID"].ToString()=="0")//如果是根结点，添加到TreeView控件{TreeNodenode1=newTreeNode();node1.Text=dr1["C_KDName"].ToString();node1.Value=dr1["I_ParentID"].ToString();if(dr1["C_ChildIDs"].ToString().Trim()!="")//判断是否含有子结点，如果有，提示：“请选择具体的知识点”{node1.NavigateUrl="javascript:alert('请选择具体的知识点');";}else{node1.NavigateUrl="javascript:parent.main.form1.txtKnowDot.value='"+dr1["C_KDName"].ToString()+"';parent.main.form1.txtKDID.value='"+dr1["I_KDID"].ToString()+"';parent.main.form1.HKDCode.value='"+dr1["C_KDCode"].ToString()+"';";}node1.Target="top";this.KnowDotTreeView.Nodes.Add(node1);BindKnowDotTree(dt.Select("I_ParentID="+dr1["I_KDID"].ToString(),"I_OrderID"),node1);//递归生成子树}else//否则添加到当前结点{TreeNodenode1=newTreeNode();node1.Text=dr1["C_KDName"].ToString();node1.Value=dr1["I_ParentID"].ToString();if(dr1["C_ChildIDs"].ToString().Trim()!=""){node1.NavigateUrl="javascript:alert('请选择具体的知识点');";}else{node1.NavigateUrl="javascript:parent.main.form1.txtKnowDot.value='"+dr1["C_KDName"].ToString()+"';parent.main.form1.txtKDID.value='"+dr1["I_KDID"].ToString()+"';parent.main.form1.HKDCode.value='"+dr1["C_KDCode"].ToString()+"';";}node1.Target="top";node.ChildNodes.Add(node1);BindKnowDotTree(dt.Select("I_ParentID="+dr1["I_KDID"].ToString(),"I_OrderID"),node1);//递归生成子树}}}#endregion}
供你参考！