Treeview from DataTable

Question

Hi i've got a dataTable with 4 fields:
-Department (String)
-Group (string)
-Product (string)
-barcode (string)

I would like to build a tree structure from this
+Department
- +Group
--+Product
----Barcode

What would be the best way to build this treestructure?

Peti Horváth · Answer

You have a solution for this? 4 tables...

Peti Horváth · Answer

You have a solution for this? 4 tables...

Lex · Answer

It seems to work fine if I want to use just 2 of the tables, but as soon as I add a third table to it, only the first 2 show up. The relation between the next node (Group & Product) is working, as I've tried to use the group as the parent, and the product as child. But if I combine the 2, Department --> Group and Group --> Product, only the Department --> Group will show up.

Lex · Answer

I've done it a little different then from you 2, mainly i desided it was easier to pull out the 4 tables seperate. DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CCS_HOConnectionString"].ConnectionString); SqlDataAdapter daDepts = new SqlDataAdapter("SELECT * FROM DEPTS", conn); SqlDataAdapter daGroups = new SqlDataAdapter("SELECT * FROM PRODGRP", conn); SqlDataAdapter daProducts = new SqlDataAdapter("SELECT * FROM PRODUCT", conn); SqlDataAdapter daBarcode = new SqlDataAdapter("SELECT * FROM product_barcode", conn); daDepts.Fill(ds, "DEPTS"); daGroups.Fill(ds, "PRODGRP"); daProducts.Fill(ds, "PRODUCT"); daBarcode.Fill(ds, "product_barcode"); ds.Relations.Add("Depts_Group", ds.Tables["DEPTS"].Columns["DEPTCODE"], ds.Tables["PRODGRP"].Columns["PGRPDEPT"]); ds.Relations.Add("Group_Product", ds.Tables["PRODGRP"].Columns["PGRPID"], ds.Tables["PRODUCT"].Columns["PRODGRP"]); ds.Relations.Add("Product_Barcode", ds.Tables["PRODUCT"].Columns["PRODCODE"], ds.Tables["product_barcode"].Columns["prodcode"]); foreach (DataRow dr in ds.Tables["DEPTS"].Rows) { TreeNode tn = new TreeNode(dr["DEPTSHORT"].ToString()); foreach (DataRow drGroup in dr.GetChildRows("Depts_Group")) { TreeNode tnn = new TreeNode(drGroup["PGRPSHORT"].ToString()); foreach (DataRow drProduct in dr.GetChildRows("Group_Product")) { TreeNode tnnn = new TreeNode(drProduct["PRODSHORT"].ToString()); foreach (DataRow drBarcode in dr.GetChildRows("Product_Barcode")) { tnnn.Nodes.Add(drBarcode["barcode"].ToString()); } tnn.Nodes.Add(tnnn); } tn.Nodes.Add(tnn); } trvBarcodes.Nodes.Add(tn); } This loads all 4 tables into the program, but will only display the treeview for the Department and Groups, not Product and Barcodes. I've been going over and over this code, but can't find a solution to the problem. When I step to the code, it seems something is going wrong with the second and third relation, but the names are all right, so I can't see where I went wrong.

Kapil Deo Malhotra · Answer

Hi, I have created the DataSource (DataSet) from one my Database and Table. Then i wrote the below code This i have done specific for the Four Columns, this can be more generalized as you need. private void button1_Click(object sender, EventArgs e) { CustomDataDataSet.ContactInfoDataTable dsTable = new CustomDataDataSet.ContactInfoDataTable(); CustomDataDataSetTableAdapters.ContactInfoTableAdapter adapter = new CustomDataDataSetTableAdapters.ContactInfoTableAdapter(); adapter.Fill(dsTable); DataTable table = dsTable; DataColumnCollection columns = table.Columns; DataRowCollection rows = table.Rows; TreeNode node1 = treeView1.Nodes.Add(columns[0].ColumnName); TreeNode node2 = node1.Nodes.Add(columns[1].ColumnName); TreeNode node3 = node1.Nodes.Add(columns[2].ColumnName); TreeNode node4 = node1.Nodes.Add(columns[3].ColumnName); foreach (DataRow row in rows) { node1.Nodes.Add(row[0].ToString()); node2.Nodes.Add(row[1].ToString()); node3.Nodes.Add(row[2].ToString()); node4.Nodes.Add(row[3].ToString()); } } Hope this will help you.

Kapil Deo Malhotra · Answer

Hi, You can use the treeview control to accomplish that one. I have tried with some static data to build the above structure, below is the code. Place the treeview control in form and one button. Execute the application and see if that help you. You can generalized the logic to get the data from the DataTable private void button1_Click(object sender, EventArgs e) { TreeNode node = treeView1.Nodes.Add("Department"); node.Nodes.Add("Engineering"); node.Nodes.Add("CIC"); TreeNode node1 = node.Nodes.Add("Group"); node1.Nodes.Add("Developer"); node1.Nodes.Add("Tester"); }