在树状视图中显示数据 [英] DISPLAYING DATA IN TREE VIEW
问题描述
我在单个表中的国家/地区和城市关系中有一个父级儿童关系数据库,因此我可以在树状视图中始终显示该关系,而该树状节点始终是一个国家/地区.但是,如果我在文本框中输入了州名",我该怎么办
然后,我的树视图应将此州名"显示为根节点,并且还应将该州的所有城市都显示为该州名的儿童节点
我在C#中编写我的代码
请帮助我,我必须在我的项目紧急中执行此操作!!!!!!!!!!!!!!
I HAVE A PARENT CHILD RELATIONSHIP DATABASE IN A SINGLE TABLE LIKE COUNTRY STATE AND CITIES RELATIONSHIP, I CAN DISPLAY WHOLE THE RELATIONSHIP IN THE TREE VIEW WHOSE ROOT NODE IS ALWAYS COUNTRY. BUT WHAT I WANT THAT IF I ENTERED A "STATE NAME" IN A TEXTBOX
THEN MY TREE VIEW SHOULD DISPLAY THIS "STATE NAME" AS ROOT NODE AND ALSO SHOW ALL THE CITIES OF THIS STATE AS CHILD NODE OF THIS STATE NAME
I M WRITING MY CODE IN C#
PLEASE HELP ME I HAVE TO IMPLEMENT THIS IN MY PROJECT URGENT PLEASE!!!!!!!!!!!!!
推荐答案
每当有人乞求紧急答案时通常表示作业分配.
因此,请在此处开始 [
Whenever anyone begs for an urgent answer it usually indicates a homework assignment.
So, start here[^] or go back to your tutor and explain that you don''t understand. They will help you.
尝试这些方法.将过滤条件更改为数据表列.
私有void CountryTree()
{
DataSet dsLevels =(DataSet)ViewState ["DataSet"];
treeEx.Nodes.Clear();
treeEx.Nodes.Add(new TreeNode("India","01"));
foreach(treeEx.Nodes中的TreeNode tn)
{
DataRow [] drlevels = dsLevels.Tables [0] .Select();
int i = 0;
foreach(drlevel中的DataRow drlevel)
{
tn.ChildNodes.Add(new TreeNode(drlevel ["description"].ToString(),drlevel ["value"].ToString()));
ChildTreeNode(tn.ChildNodes [i],dsLevels.Tables [0]);
i ++;
}
}
}
私有void ChildTreeNode(TreeNode childNode,DataTable dt)
{
试试
{
DataRow [] dr = dt.Select("parentId =" + childNode.Value);
int i = 0;
foreach(dr中的DataRow drlevel)
{
childNode.ChildNodes.Add(new TreeNode(drlevel ["description"].ToString(),drlevel ["value"].ToString()));
如果(dt.Select("parentId =" + drlevel ["value"].ToString()).长度> 0)
{
ChildTreeNode(childNode.ChildNodes [i],dt);
i ++;
}
}
}
catch(ex ex例外)
{
}
}
try this these methods. change filter conditions as your datatable columns.
private void CountryTree()
{
DataSet dsLevels = (DataSet)ViewState["DataSet"];
treeEx.Nodes.Clear();
treeEx.Nodes.Add(new TreeNode("India", "01"));
foreach (TreeNode tn in treeEx.Nodes)
{
DataRow[] drlevels = dsLevels.Tables[0].Select();
int i = 0;
foreach (DataRow drlevel in drlevels)
{
tn.ChildNodes.Add(new TreeNode(drlevel["description"].ToString(), drlevel["value"].ToString()));
ChildTreeNode(tn.ChildNodes[i], dsLevels.Tables[0]);
i++;
}
}
}
private void ChildTreeNode(TreeNode childNode, DataTable dt)
{
try
{
DataRow[] dr = dt.Select("parentId=" + childNode.Value);
int i = 0;
foreach (DataRow drlevel in dr)
{
childNode.ChildNodes.Add(new TreeNode(drlevel["description"].ToString(), drlevel["value"].ToString()));
if (dt.Select("parentId=" + drlevel["value"].ToString()).Length > 0)
{
ChildTreeNode(childNode.ChildNodes[i], dt);
i++;
}
}
}
catch (Exception ex)
{
}
}
抱歉,如果您可以帮助他们,则不是家庭作业,而是办公室工作.........
SORRY SIR BUT ITS NOT A HOMEWORK ITS A OFFICE WORK IF YOU CAN HELP THEN HELP.........
这篇关于在树状视图中显示数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!