DATAGRID (merged) to EXCEL

[pgollnic]

I am having to use a DATAGRID instead of DataGridView because I want to merge 2 datasets into 1 using a keyed field to tie the two together(the merge of datasets).

ds1.Tables[0].TableName="Header"

ds1.Tables[1].TableName="Detail"

y = ds1.Tables("Header").Columns.Indexof(KeyPart2parmfield)

z = ds1.Tables("Detail").Columns.Indexof(ConCatParm)

table1Column = ds1.Tables("Header").Columns(y)

table2Column = ds1.Tables("Detail").Columns(z)

relation = *New DataRelation("Click for Detail", table1Column, table2Column , *False)

ds1.Relations.Add(relation)

I can send the first dataset (header) over to excel just fine. I however want to also put the second dataset (detail) into the excel also giving it the little + sign showing there is additional data (open/close the tree view + )

How? Anyone have any idea??