Treeview filled dynamically from 5 tables in C# windows form

imran tanvir

9y915Learn iOS Programming

coa_level1 has a foreign key and relates to coa_level2. and so on.

i want make a windows form which show me all talbe values in proper treeview nodes.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

rajendra singh9y ago
Accepted answer
You needs to run for loop for each level like this

//Here ds is data in level1
for(int i=0;i
{
treeView2.Nodes.Add(yourNode);
//here you query for checking node
string query="select * from level2 where level1code ="+ds.Tables[0].Rows[i["level1code"].ToString()";
//assign this to ds1
if(ds1.Tables[0].Rows.Count!=0)
{
//Again you have to check for the level3 and so on
}
}

But i would suggest to make single table and make parent , child relationship into that.

tbl_category filed name

int id,
char(2) levelcode,
char(40) levelname,
int parentid

From doing this we can add any numbers of level we just need to check parentid for this.

Please let me know if you need any help.

+1
imran tanvir8y ago
thanks alot. i filled treeview with 5 levels. i also able to add and delete nodes from all levels. its not easy but i have done with your help. Thanks
+1
rajendra singh8y ago
Hi imran,

//query for level2
string query="select * from level2 where level1code =" ds.Tables[0].Rows[i["level1code"].ToString()";
//get result of query in dataset ds1
if(ds1.Tables[0].Rows.Count!=0)
{
for(int i=0;i
{
treeView1.Nodes["parentkey"].Nodes.Add(ds1.Tables[0].Rows[i]["level2name"].ToString());
string query1="select * from level3 where level2code =" ds1.Tables[0].Rows[i["level1code"].ToString()";
//Same Thing you need to do level 4 and 5
}
}
0
imran tanvir9y ago
for level 1...
private void PopulateTreeView1()
{
int i;
for (i = 0; i <= _acountsTb1.Rows.Count - 1; i++)
{
TreeNode t = new TreeNode();
t.Text = _acountsTb1.Rows[i]["level1code"].ToString() + " - " + _acountsTb1.Rows[i]["level1name"].ToString();
t.Name = _acountsTb1.Rows[i]["level1code"].ToString();
t.Tag = _acountsTb1.Rows.IndexOf(_acountsTb1.Rows[i]);
treeView1.Nodes.Add(t);
treeView1.Nodes[i].ForeColor = Color.Blue;
MessageBox.Show(_acountsTb1.Rows[i]["level1code"].ToString());
}
}

help me for level 2 and sone....
Thanks
0