Treeview filled dynamically from 5 tables in C# windows form

Question

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.

rajendra singh · 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.

imran tanvir · Answer

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

rajendra singh · Answer

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 } }

imran tanvir · Answer

for level 1... private void PopulateTreeView1() { int i; for (i = 0; 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