how to display parent and child data in one datagridview in win form (vb.net)

Question

1.00/5 (1 vote)

See more:

Hi all,

I am struggling as to display parent and child details in one datagridview using vb.net (VS2012) in win form with sample as following:

in datagridview shows first column with "+" or first column name is "+"
+ ID, NAME,..
+ ID, NAME,..

When Click + at parent row and result should be as

- ID, NAME
ID, ORDER, AMOUNT..
ID, ORDER, AMOUNT..
+ ID, NAME,..
+ ID, NAME,..

Thanks in advance for any idea and help.

Ooops, I should tell more details as : I create datarelation
Dim relation As DataRelation
Dim table1Column As DataColumn
Dim table2Column As DataColumn

table1Column = ds.Tables("Table1").Columns(0)
table2Column = ds.Tables("table2").Columns(0)
relation = New DataRelation("relation", table1Column, table2Column)

ds.Relations.Add(relation)
datagridview1.Datasourse = ds.Tables(0)
In datagridview displays only "parent table" not included "child table"

I appreciate so much for your reply from the world (Thanks from Australia)

Posted 16-Jan-13 12:20pm

minh tran

Updated 16-Jan-13 14:12pm

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Jan-13 18:31pm

Is it System.Windows.Forms? Tag it!
—SA

4 solutions

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)

PIEBALDconsult · Answer 1 · 2013-01-16T12:34:00

Solution 1

If you use a DataSet that defines the relationship between the tables, the framework will handle the rest. But I have found that a TreeView works better.

Posted 16-Jan-13 12:34pm

PIEBALDconsult

Comments

Sergey Alexandrovich Kryukov 16-Jan-13 18:49pm

Agree. We were answering at the same time. My 5.
I found one interesting option, put in my answer — please see.
—SA

Sergey Alexandrovich Kryukov · Answer 2 · 2013-01-16T12:40:00

If child-parent relation is really involved, the better control could be TreeView. With it, you will loose all your column data, but you can use both controls. When selection in TreeView changes, you can handle respective events and show detail data in some other control accordingly. This is easy enough.

There is another approach. Peter Brightman demonstrated how the ListView control can be used in virtual mode to represent both tree structure and node detail with columns. Please give it a try. Even though he did not create a fully-fledged control out of it, it looks and works really well and can be very useful:
Virtual Mode TreeListView[^].

Good luck,

—SA

Espen Harlinn · Answer 3 · 2013-01-16T13:00:00

Solution 3

Have a look at: Walkthrough: Creating a Master-Detail Windows Form[^]

Best regards
Espen Harlinn

Posted 16-Jan-13 13:00pm

Espen Harlinn

minh tran · Answer 4 · 2013-01-16T13:54:00

Solution 4

Thanks Sergey, ListView demonstrated by Peter Brightman is a good one to see, but my project needs DatagridView or Datagrid (I work with a fuzzy boss)

Posted 16-Jan-13 13:54pm