DataGridView Parent/Child

alwinSCH

Hi there, could anyone help me start with this: don't know where to look or start I have 3 tables which i want to show in a datagrid --> Parent First row = Customer name + child first row totalsum of orders for this customer + ChildChild First row = Detailed orders for this customer With a + or - button to click open or not I also work wit *.xsd scheme tableAdapters,... already have a relation between those tables But then i'm stuck Please get me back on track... If i read everywhere it's all in ASP.net with dataset and thinks like that... But i don't know how thhat helps me... thanks A.

AliAmjad

Create a Dataset Object Fill the Dataset with Tables then Create the Relationship between these tables make the DatagridView.DataSource property equal to that Dataset. Does this solves your problem? AliAmjad (MCP)

alwinSCH

It is all with dataset but i have tableAdapters so how do i fill my dataset with correct data throug TableAdapters? The relationship is already created between my tableAdapters! i can use My tableAdapter as well to fill a datagrid, why change to a Dataset? A.

Dave Kreskowiak

DataGridView is a Windows Forms control only. It doesn't support showing child tables the way you want without HEAVY modifications to the DGV. You'd be better off using a 3rd party grid control like DevExpress' XtraGrid.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007

alwinSCH

No other Solution? I don't want the third party grid! But thanks anyway A.

Dave Kreskowiak

The other solution would take you about 3 months to write. Like I said, the DGV doesn't natively support showing child tables. I went for a 3rd party solution, and after downloading and installing the controls, had my requirement done in about 3 minutes.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007

darkelv

You can use the "old" DataGrid.

alwinSCH

The 'Old' DataGrid ?