Making the datagridview display to treeview

Question

0.00/5 (No votes)

See more:

I am asked to make a datagridview that shows the hierarchy of tables from parents>sub-parents>child.
I don't know how to put up a picture here so to give you a clear view of what I want to make is, imagine an ms access database with 3 tables named "Parent","Sub-parent" and "child". "Parent" is in the top of the hierarchy, connected to "Sub-Parent" with a foreign key. While the "Sub-Parent" table connected to the "Child" table, the same way "Sub-Parent" is connected to "Parent" table.

In the access, when you looked at the "Parent" table, you will be able to drop-down it to see the "Sub-Parent" data row until the "Child" data row whenever it corresponds with the primary key.

You see, I want to recreate that into visual basic style. I saw some downloadable treeview sample progs here but it is too advanced for me to study and uses some css/wpf thing that I don't have a single clue about.

Posted 14-Jul-15 20:10pm

Jake Robert

Add a Solution

Comments

Ralf Meier 15-Jul-15 2:25am

So ... you have a datatable and you want to display it's structure with as treeview ?
Does your datatable has a fixed structure and you only want to display the items in the treeview ?

Perhaps you should deliver more Information ... (and improve your question)

Jake Robert 15-Jul-15 3:15am

Yes, I do want my datatable to be displayed

The actual treeview hierarchy that I will be doing is like this, Sector>Association>Company>Location>Product>Raw Materials. So 1 Parent will be having multiple sub-parents and child.

Ralf Meier 15-Jul-15 3:43am

OK ... understand ...
So - please tell me where the problem is / where you stuck ...

Jake Robert 15-Jul-15 4:13am

Actually, I am stuck at all. I do not know how to start. I can't even connect the treeview to my database's datatable. So any enlightenment into this matter is highly appreciated.

Ralf Meier 15-Jul-15 8:57am

Isn't my solution what you wanted to see ?
If Not - please give me more information - perhaps about your datatable ...

Jake Robert 15-Jul-15 23:00pm

I have searched some codes and tutorials and this is what I have as of now.

Imports System.Data.OleDb

Public Class Search

Dim con As New OleDbConnection

Private Sub Search_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'DatabaseDataSet.Association' table. You can move, or remove it, as needed.
Me.AssociationTableAdapter.Fill(Me.DatabaseDataSet.Association)
'TODO: This line of code loads data into the 'DatabaseDataSet.Sector' table. You can move, or remove it, as needed.
Me.SectorTableAdapter.Fill(Me.DatabaseDataSet.Sector)

cmboxExportOpt.Text = "Export to PDF"

' Filling the tree view
Dim SectorID As String
Dim SectorName As String
Dim SectorCount As Integer

For SectorCount = 0 To DatabaseDataSet.Sector.Count - 1
SectorID = DatabaseDataSet.Sector.Rows(SectorCount).Item(0)
SectorName = DatabaseDataSet.Sector.Rows(SectorCount).Item(1)
tvDataTable.Nodes(0).Nodes.Add(SectorID, SectorName)

Next

tvDataTable.ExpandAll()

End Sub

Private Sub btnBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBack.Click
Me.Close()
Homepage.Show()
End Sub

Private Sub tvDataTable_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles tvDataTable.AfterSelect
If tvDataTable.SelectedNode Is Nothing Then
dgvAssocView.DataSource = Nothing
Exit Sub
End If
If tvDataTable.SelectedNode.Name = "Sector" Then
Exit Sub
End If

Dim ID As String
ID = tvDataTable.SelectedNode.Name
dgvAssocView.DataSource = DatabaseDataSet.Association.Select("SectorID=" & ID)
End Sub

Private Sub SectorBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.SectorBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.DatabaseDataSet)

End Sub
End Class

I can only show 1 data table(Which is Sector) in the tree view and I cannot add some grandchild to the child(Association) nodes of the parent node.
Also I am getting errors like this:

Syntax error in Lookup expression: Expecting keyword 'Parent' followed by a single column argument with possible relation qualifier: Parent[(<relation_name>)].<column_name>.

Ralf Meier 16-Jul-15 0:40am

You have found a sample code which (my opinion) not matches to your Project. I think, it is incomplete.
What you have to do is iterating through your data-structure and search all the items of the top-layer and add these as Nodes to the TreeView. Now you have to look if some of your top-layer-items have sub-items (childs , sub-data). In this case you have to select the corresponding Node of the TreeView and add the necessary Sub-Nodes to it. And so on.
You could compare it with the Directory-structure (and it's build-up) of a file-System. There you also could not create a complete path - you must do it Folder by Folder ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ralf Meier · Answer 1 · 2015-07-14T23:40:00

As I understand your problem :
The TreeView-Control could not be directly connected to your datatable(s). What you have to do is the following :
- according to the structure of your data create the TreeNodes (and give them the corresponding Name). This could be done manually (with the Control-Designer) if the structure is allways the same. Or it must be done dynamicly if the structure is different. This works like this :
- Add a TreeNode and Name it
- select this TreeNode and add all necessary sub-Nodes and Name them.
- select this TreeNode.SubNode and add all necessary sub-Nodes and Name them.
- and so on.

Do you think that you could try it like this ?