September 7, 2008 01:33am pdt

1. jaime_oliv... 520,997
2. TheLearn... 353,216
3. jandromeda 240,713
4. Fernando... 213,569
5. JimBrandley 205,943
6. p_davis 194,294
7. angelIII 164,843
8. Dhaest 157,837
9. burakiewicz 147,113
10. anarki_ji... 130,050
11. naspinski 122,111
12. ZachSmith 118,878
13. ShazbotOK 107,960
14. CyrexCor... 98,575
15. jcoehoorn 96,435
16. philipjonat... 91,424
17. REA_AN... 88,770
18. josgood 83,688
19. gauthampj 81,948
20. raterus 79,965
21. margajet24 79,659
22. junges 77,200
23. GreenGho... 75,560
24. monarch... 73,395
25. emoreau 73,061

1. TheLearn... 2,254,948
2. gregoryyo... 1,388,067
3. jaime_oliv... 1,019,783
4. AlexFM 994,109
5. dstanley9 713,657
6. Fernando... 677,476
7. TheAvenger 653,871
8. gauthampj 630,915
9. Idle_Mind 624,477
10. JimBrandley 587,714
11. angelIII 511,986
12. Zephyr__ 442,269
13. REA_AN... 361,019
14. surajguptha 357,057
15. emoreau 354,793
16. Desp 351,128
17. carl_tawn 328,215
18. sumix 327,243
19. _TAD_ 318,360
20. anarki_ji... 304,563
21. dungla 297,764
22. mnasman 292,791
23. testn 290,465
24. Yurich 279,264
25. Dhaest 272,494

04.29.2008 at 07:22PM PDT, ID: 23364242

	[x] Attachment Details

Treeview Binding to SQL problem

Asked by jnsimex in C# Programming Language, Miscellaneous Programming, Visual Studio .NET 2005

I am trying to bind the Treeview to an SQL Database. As you can see in the image, it is not working.

I need to append all the items that have the same assembly or subassembly.

How do I accomplish this with the coding provided?Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:

           
           
             TreeNode rootNode = new TreeNode(this.Project.Name);
 
 
            treeView1.Nodes.Add(rootNode);
 
 
 
            foreach (AccpacBOMDataSet.BOMRow bomRow in bomTable.Rows)
            {
                if (bomRow.AssemblyName != null)
                {
                    TreeNode assemblyNode = new TreeNode();
                    assemblyNode.Text = bomRow.AssemblyName;
                    rootNode.Nodes.Add(assemblyNode);
 
                    if (!bomRow.IsSubAssemblyNameNull())
                    {
                        TreeNode subAssembly = new TreeNode();
                        subAssembly.Text = bomRow.SubAssemblyName;
                        assemblyNode.Nodes.Add(subAssembly);
 
                        if (!bomRow.IsSubAssembly1NameNull())
                        {
                            TreeNode subAssembly1 = new TreeNode();
                            subAssembly1.Text = bomRow.SubAssembly1Name;
                            subAssembly.Nodes.Add(subAssembly1);
 
                            if (bomRow.ItemNo != null)
                            {
                                TreeNode itemNo = new TreeNode();
                                itemNo.Text = bomRow.ItemNo;
                                subAssembly1.Nodes.Add(itemNo);
                            }
 
                        }
                        else
                        {
                                TreeNode itemNo = new TreeNode();
                                itemNo.Text = bomRow.ItemNo;
                                subAssembly.Nodes.Add(itemNo);
                        }
                    }
                    else
                    {
                        TreeNode itemNo = new TreeNode();
                        itemNo.Text = bomRow.ItemNo;
                        assemblyNode.Nodes.Add(itemNo);
                    }
 
                }
            }
        }

           
         

Attachments:

bom.JPG (31 KB) (File Type Details)

Treeview with Database

Keywords: Treeview Binding to SQL problem

	Title
1	Binding dynamic TreeView node selcti…
2	Databinding on the treeview control
3	Databinding Hierarchical Dataset to a Tr…
4	How can I dynamically construct my Wi…
5	Treeview in a grid
6	bind treeview in repeater's itemtempl…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Treeview Binding to SQL problem

Asked by jnsimex in C# Programming Language, Miscellaneous Programming, Visual Studio .NET 2005

About this solution