[RESOLVED] [2005] Nested Datatables in a single DataGridView

[MechEng]

Greetings. Is there a way to nest two Datatables in a single Datagridview so that the data is displayed like so:

+ Parent Row #1
- Parent Row #2
. - Child Row related to Parent Row #2 (1)
. - Child Row related to Parent Row #2 (2)
. - Child Row related to Parent Row #2 (3)
+ Parent Row #3
+ Parent Row #4

I have an example of something similar using a DataGrid, but can not find a reference to this with the DataGridView. Here is the code used with the DataGrid:

     Dim student_is_relation As DataRelation = _
       scores_dataset.Relations.Add( _
       "Student Test Scores", _
       students_table.Columns("StudentId"), _
       test_scores_table.Columns("StudentId"))
       
     student_is_relation.Nested = True

     grdScores.DataSource = scores_dataset

[jmcilhinney]

The DataGridView does not support that functionality.

[MechEng]

With the DataGridView set up as the replacement for the DataGrid, is there any reason why I should not use the DataGrid (problems that I may not be aware of)?

[jmcilhinney]

This is the major deficiency of the DataGridView class in my opinion. Given that it's an improvement on the DataGrid in basically every other way I would have expected improved relationship navigation, not worse. I was very disappointed when I discovered this. It's not a feature that gets used all the time, which is why I guess they felt justified leaving it out, but it would have been nice.

Anyway, if you want such navigation then it's the DataGrid or a third-party offering, which is likely to be not cheap. The DataGrid is a b*gger to custimise compared to the DataGridView and doesn't have as attractive UI, but what can you do?

[MechEng]

This feature would have been very nice for my app, but I can live with two related DGVs. Thanks you’re your thoughts on this subject.

Cheers