I have master/child grids on a form. I would like to export the parent grid row, followed by each of its child grid rows. It is very easy to export the entire grid (one or the other), but I was hoping there was a way to export them joined.
I do not want to make it all one grid.
Any ideas/work arounds to make this happen?
Thanks
Howard
I think the best way is to create a grid and bind it to the hierarchical datasource. These datasources can be dataset or bindinglist or any other. Now when you export to excel, it exports the complete hierarchical grid (with parent and associated childs and so on).
Hierarchy cn be created in dataset by adding relations and in BindingList by creating nested lists.