Loading data from XML to Datatable

Let us clear some constraints:

  • XML is a snippet, but we can assume, that is defining XML Namespaces
    More on this and how to handle here:

Some parts within the data are maybe a copy paste error or do have other defects (& instead of & )

After other cross-checking some alternate conversion tricks we would recommend:

  • collect all distinct child element names from the Report_Entry element - myElementNames
  • use myElementNames to construct dynamically an all over Datacolumn structure on an empty datatable
  • iterate over all Report_Entry elements
    • extract all current elements and values and use it for datatable population