数据库 id,name parent private void CreatTree()
{
TreeNode node = new TreeNode();
node.Text = hsxmname +"【试验范本】";
node.NodeData = "-1";
node.Type = "root";
node.Expanded = true ;
TreeView1.Nodes.Add(node);
InitTree(node);
}
private void InitTree(TreeNode nod)
{
string sql = "select id,name,jd_kind from zl_fb_test where parent is null";
DataSet ds = cls_public.GetDataSetOfSql(sql,"test");
DataTable dt = ds.Tables["test"];
foreach (DataRow row in dt.Rows)
{
TreeNode nox = new TreeNode();
nox.NodeData = row["id"].ToString();
nox.Text = row["name"].ToString();
nox.Type = row["jd_kind"].ToString();
nox.Expanded = true ;
nod.Nodes.Add(nox);
//FillTree(nox);
}
}
private void FillTree(TreeNode nod)
{
string sql = "select id,name,jd_kind from zl_fb_test where parent='"+ nod.NodeData+"'";
DataSet ds = cls_public.GetDataSetOfSql(sql,"test");
DataTable dt = ds.Tables["test"];
foreach(DataRow row in dt.Rows)
{
TreeNode temp = new TreeNode();
temp.NodeData = row["id"].ToString();
temp.Text = row["name"].ToString();
temp.Type = row["jd_kind"].ToString();
temp.Expanded = true ;
nod.Nodes.Add(temp);
}
}
{
TreeNode node = new TreeNode();
node.Text = hsxmname +"【试验范本】";
node.NodeData = "-1";
node.Type = "root";
node.Expanded = true ;
TreeView1.Nodes.Add(node);
InitTree(node);
}
private void InitTree(TreeNode nod)
{
string sql = "select id,name,jd_kind from zl_fb_test where parent is null";
DataSet ds = cls_public.GetDataSetOfSql(sql,"test");
DataTable dt = ds.Tables["test"];
foreach (DataRow row in dt.Rows)
{
TreeNode nox = new TreeNode();
nox.NodeData = row["id"].ToString();
nox.Text = row["name"].ToString();
nox.Type = row["jd_kind"].ToString();
nox.Expanded = true ;
nod.Nodes.Add(nox);
//FillTree(nox);
}
}
private void FillTree(TreeNode nod)
{
string sql = "select id,name,jd_kind from zl_fb_test where parent='"+ nod.NodeData+"'";
DataSet ds = cls_public.GetDataSetOfSql(sql,"test");
DataTable dt = ds.Tables["test"];
foreach(DataRow row in dt.Rows)
{
TreeNode temp = new TreeNode();
temp.NodeData = row["id"].ToString();
temp.Text = row["name"].ToString();
temp.Type = row["jd_kind"].ToString();
temp.Expanded = true ;
nod.Nodes.Add(temp);
}
}
解决方案 »
- RichTextBox.Text.Length 和 RichTextBox.TextLength
- 连接远程数据库的时候,密码会不会被截获?
- 关于数据库保存图片问题
- 大家觉得《head first design patterns》和《大话设计模式》那一个更适合入门级的新手阅读?
- 请问:这个界面如何实现的?VS2005中的“工具”下的“选项”界面,分2部分,点左边,则右边整体会出现不同的内容。想不出来啊
- 请问server.MapPath("db\db.mdb")与server.MapPath("db/db.mdb")的区别一个用”\“一个用”/“,到是都能连接上,但有什么区别啊
- 【telnet协议,网络数据收发】TCP 发送后 再接受,获得的数据,前钱数据缺失了一些
- 很菜的问题:在C#中,如何把string类型转换成int
- 网页的发布
- C#英文网站征集,请给出网站连接及其简单的介绍.灌水勿进,不是算分.
- 请教一个关于cookie的问题(up有分)
- 如何在vs.net2003里调试运行c#程序
public void CreateTree(TreeNode node,string id)
{
SqlConnection sqlconn=new SqlConnection("server=(local);Trusted_Connection=yes;database=lzy");
SqlDataAdapter sqlda=new SqlDataAdapter("select * from Server" ,sqlconn);
DataSet ds=new DataSet();
sqlda.Fill(ds,"Server");
SqlDataAdapter sqlda1=new SqlDataAdapter("select * from Items ",sqlconn);
DataSet ds1=new DataSet();
sqlda1.Fill(ds1,"Items");
DataTable dt1=ds1.Tables["Items"];
DataTable dt=ds.Tables["Server"];
foreach(DataRow dr in dt.Rows)//遍历所有节点
{ string strNode="0";
TreeNode nd=new TreeNode();
string a=dr["ID"].ToString();//存放节点
nd.Text=dr["Name"].ToString();//节点名称
//TreeNode nd1=new TreeNode();
// TreeNode nd1=new TreeNode();//此节点只作为“nd”展开的依据
//nd1.Text="正在加载...";
//nd1.Text=dr["ID"].ToString()+"\t"+dr["ServerID"].ToString()+"\t"+dr["ItemName"].ToString()+dr["SortIndex"].ToString();
if(node==null)
{
this.treeView1.Nodes.Add(nd);//添加根节点
//查询子节点个数
//nd1.Nodes.Add (strNode);
//判断是否有子节点
SqlDataAdapter sqlda2=new SqlDataAdapter("select * from Items where ServerID="+a ,sqlconn);
sqlda1.Fill(ds1,"Items");
foreach(DataRow dr1 in dt1.Rows)
{
TreeNode nd2=new TreeNode();
nd2.Text=dr1["ID"].ToString()+"\t"+dr1["ServerID"].ToString()+"\t"+dr1["ItemName"].ToString()+dr1["SortIndex"].ToString();
strNode=nd2.Text ;
nd2.Nodes.Add(strNode);
} if(Convert.ToInt32(ds1.Tables["Items"].Rows[0].ItemArray[0])!=0)
{
nd.Nodes.Add(nd1);
//添加节点,只是为了能展开
}
}
else
{
//添加子节点
//查询子节点个数
SqlDataAdapter sqlda2=new SqlDataAdapter("select * from Items where ServerID="+a ,sqlconn);
sqlda1.Fill(ds1,"Items");
//判断是否有子节点
if(Convert.ToInt32(ds1.Tables["Items"].Rows[0].ItemArray[0])!=0)
{
nd.Nodes.Add(nd1);//添加节点,只是为了能展开
}
}
else里面的好像不执行.子节点的foreach循环里面的nd2.Nodes.Add(strNode);也没加上节点.谁能帮我看看啊