Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Howard
165
How to export master/child grids to Excel
posted

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

  • 420
    Verified Answer
    posted

    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.