TreeView怎么添加节点? 现在数据在数据库里。只有有关字段fxNo(archar(50)),fxName,其中fxNO表示他的序号如:1, 2, 1.1, 1.1.1,1.2.1通过这些序号把数据添加进treeview中去。谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 直接循环一下你那表里的数据集。然后TreeNode MyNodes = new TreeNode();MyNodes.Text = 表里取出来的字段值;MyNodes.Value = 表里取出来的字段值;Tree1.Nodes.Add(MyNodes); 你想要加子节点也一样的。只要在你的根节点来增加子节点。TreeNode MyNodes = new TreeNode(); MyNodes.Text = 表里取出来的字段值; MyNodes.Value = 表里取出来的字段值; Tree1.Nodes[0].ChildNodes.Add(MyNodes); TreeNode node= new TreeNode(); MyNodes.Text = text; MyNodes.Value = value; Tree1.Nodes.Add(MyNodes);一般情况下数据库会增加一个字段来放目录层次判断一下,然后循环下上面方法就行了 我数据库里只有一个fxNo字段负责所有的路径。大家不要给我该数据库。 用递归方法 DataTable dtble = new DataTable(); //将表 数据库里的数据取到 dtble; private void button2_Click(object sender, EventArgs e) { TreeNode treeNode1 = new TreeNode("FisrtNode"); treeView1.Nodes.Add(treeNode1); CrateTreeView1(treeNode1,1); } private void CrateTreeView1(TreeNode tmnode, int Deep) { DataRow[] tmdr = dtble.Select("fxNO like '" + tmnode.Text.Trim() + ".%'"); foreach (DataRow dr in tmdr) { string strtm = dr["fxNO"].ToString().Trim(); if (strtm.Split('.').Length == Deep) { TreeNode childnode = new TreeNode(strtm); tmnode.Nodes.Add(childnode); CrateTreeView1(childnode,Deep+1); } } } 更正一下!!! DataTable dtble = new DataTable(); //将表 数据库里的数据取到 dtble; private void button2_Click(object sender, EventArgs e) { TreeNode treeNode1 = new TreeNode("1"); treeView1.Nodes.Add(treeNode1); CrateTreeView1(treeNode1,1); TreeNode treeNode2 = new TreeNode("2"); treeView1.Nodes.Add(treeNode2); CrateTreeView1(treeNode2, 1); } private void CrateTreeView1(TreeNode tmnode, int Deep) { DataRow[] tmdr = dtble.Select("fxNO like '" + tmnode.Text.Trim() + ".%'"); foreach (DataRow dr in tmdr ) { string strtm = dr["fxNO"].ToString().Trim(); if (strtm.Split('.').Length == Deep) { TreeNode childnode = new TreeNode(strtm); tmnode.Nodes.Add(childnode); CrateTreeView1(childnode,Deep+1); } } } 再试一下着个 DataSet dsdata = new DataSet(); private void button3_Click(object sender, EventArgs e) { string con = "server=localhost;Integrated Security=SSPI;database=mydb"; string sqlstr = "Select * from testFax "; SqlConnection connect = new SqlConnection(con); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlstr; cmd.Connection = connect; SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = cmd; dap.Fill(dsdata); CreatTreeView2(1); } private void CreatTreeView2(int deep) { foreach (DataRow dr in dsdata.Tables[0].Rows) { string strfxno = dr["fxNo"].ToString().Trim(); if (strfxno.Split('.').Length == deep) { TreeNode tmnode = new TreeNode(dr["fxNo"].ToString().Trim()); this.treeView1.Nodes.Add(tmnode); CreatTreeView1(tmnode, deep+1); } } } private void CreatTreeView1(TreeNode tmnode, int Deep) { string strfilter = "fxNO like '" + tmnode.Text.Trim() + ".%'"; DataRow[] tmdr = dsdata.Tables[0].Select(strfilter); foreach (DataRow dr in tmdr) { string strtm = dr["fxNO"].ToString().Trim(); string[] strarr = strtm.Split('.'); if (strarr.Length == Deep) { TreeNode childnode = new TreeNode(strtm); tmnode.Nodes.Add(childnode); CreatTreeView1(childnode, Deep + 1); } } } 前台拖入label控件,后台似乎找不到这个控件 怎么在GridView里增加一个Button,并在该Button里增加一个事件? extjs 谁有comboTree的源代码??? 请看这个行列转换,可以吗? 请问高手一个上传图片的问题 asp.net里面的DropDownlist控件里面如何加入小图标? 表单、XML 对Access数据库读写是否需要权限,怎么配置权限? 如何做webgis ,吐血求助!!! layui tree中怎么进行对子节点名称的修改 发布网站问题 .NET2003安装问题
TreeNode MyNodes = new TreeNode();
MyNodes.Text = 表里取出来的字段值;
MyNodes.Value = 表里取出来的字段值;
Tree1.Nodes.Add(MyNodes);
只要在你的根节点来增加子节点。
TreeNode MyNodes = new TreeNode();
MyNodes.Text = 表里取出来的字段值;
MyNodes.Value = 表里取出来的字段值;
Tree1.Nodes[0].ChildNodes.Add(MyNodes);
MyNodes.Text = text;
MyNodes.Value = value;
Tree1.Nodes.Add(MyNodes);一般情况下数据库会增加一个字段来放目录层次
判断一下,然后循环下上面方法就行了
用递归方法 DataTable dtble = new DataTable();
//将表 数据库里的数据取到 dtble; private void button2_Click(object sender, EventArgs e)
{
TreeNode treeNode1 = new TreeNode("FisrtNode");
treeView1.Nodes.Add(treeNode1);
CrateTreeView1(treeNode1,1);
} private void CrateTreeView1(TreeNode tmnode, int Deep)
{
DataRow[] tmdr = dtble.Select("fxNO like '" + tmnode.Text.Trim() + ".%'"); foreach (DataRow dr in tmdr)
{
string strtm = dr["fxNO"].ToString().Trim();
if (strtm.Split('.').Length == Deep)
{
TreeNode childnode = new TreeNode(strtm);
tmnode.Nodes.Add(childnode); CrateTreeView1(childnode,Deep+1);
}
}
}
//将表 数据库里的数据取到 dtble;
private void button2_Click(object sender, EventArgs e)
{
TreeNode treeNode1 = new TreeNode("1");
treeView1.Nodes.Add(treeNode1);
CrateTreeView1(treeNode1,1); TreeNode treeNode2 = new TreeNode("2");
treeView1.Nodes.Add(treeNode2);
CrateTreeView1(treeNode2, 1);
} private void CrateTreeView1(TreeNode tmnode, int Deep)
{
DataRow[] tmdr = dtble.Select("fxNO like '" + tmnode.Text.Trim() + ".%'");
foreach (DataRow dr in tmdr )
{
string strtm = dr["fxNO"].ToString().Trim();
if (strtm.Split('.').Length == Deep)
{
TreeNode childnode = new TreeNode(strtm);
tmnode.Nodes.Add(childnode); CrateTreeView1(childnode,Deep+1);
}
}
}
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=mydb";
string sqlstr = "Select * from testFax ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata);
CreatTreeView2(1);
} private void CreatTreeView2(int deep)
{
foreach (DataRow dr in dsdata.Tables[0].Rows)
{
string strfxno = dr["fxNo"].ToString().Trim();
if (strfxno.Split('.').Length == deep)
{
TreeNode tmnode = new TreeNode(dr["fxNo"].ToString().Trim());
this.treeView1.Nodes.Add(tmnode);
CreatTreeView1(tmnode, deep+1);
}
}
} private void CreatTreeView1(TreeNode tmnode, int Deep)
{
string strfilter = "fxNO like '" + tmnode.Text.Trim() + ".%'";
DataRow[] tmdr = dsdata.Tables[0].Select(strfilter); foreach (DataRow dr in tmdr)
{
string strtm = dr["fxNO"].ToString().Trim();
string[] strarr = strtm.Split('.');
if (strarr.Length == Deep)
{
TreeNode childnode = new TreeNode(strtm);
tmnode.Nodes.Add(childnode); CreatTreeView1(childnode, Deep + 1);
}
}
}