TreeNode tn=new TreeNode();
tn.Text="领导初始化";
tn.NavigateUrl="../archives/InitLeader.aspx";
tn.ImageUrl="images/tool-addressbook.gif";
tn.Target="main";
TreeView1.Nodes[0].Nodes.Add(tn);
tn.Text="领导初始化";
tn.NavigateUrl="../archives/InitLeader.aspx";
tn.ImageUrl="images/tool-addressbook.gif";
tn.Target="main";
TreeView1.Nodes[0].Nodes.Add(tn);
cNode.Text=RsTemp.GetString(1);
cNode.ID =RsTemp.GetInt32(0).ToString();
this.tvMain.Nodes[i].Nodes.Add(cNode);
数据库为:cid/classname/pidprivate void ClassTree_Init(TreeNodeCollection RN,int root)
{
string[] FileSplit;
SqlDataReader rs;
SqlConnection conn=new SqlConnection("Password=****;User ID=****;Initial Catalog=****;Data Source=****") ;
SqlCommand sqlcmd=new SqlCommand();
TreeNode myNode=new TreeNode();
TreeNodeCollection Nx=new TreeNodeCollection();
sqlcmd.Connection=conn;
sqlcmd.CommandType=System.Data.CommandType.StoredProcedure ;
sqlcmd.CommandText="dbo.file_class_getchild";
sqlcmd.Parameters.Add("@pid",System.Data.SqlDbType.Int,4);
sqlcmd.Parameters["@pid"].Value=root;
try
{ conn.Open(); }
catch
{};
rs=sqlcmd.ExecuteReader();
while (rs.Read())
{
myNode=new TreeNode();
myNode.Text=Convert.ToString(rs.GetSqlString(1));
myNode.NavigateUrl="xxxx.aspx?classid="+Convert.ToString(rs.GetValue(0));
RN.Add(myNode);
ClassTree_Init(myNode.Nodes,Convert.ToInt16(rs.GetValue(0)));
};
rs.Close();
conn.Close();
}-----------------------------------------------
主程序部分调用方法:
TreeNode rootNode=new TreeNode();
rootNode.Text="软件工具";
Tree1.Nodes.Add(rootNode);
ClassTree_Init(rootNode.Nodes,0);-------------------------------------
using部分应加上如下内容:
using System.Data.SqlClient;
using Microsoft.Web.UI.WebControls;