I need to upload an XML file that contains multiple hierarchies, 4 tables if it was on a database into just 1 large table. How do I go about this through vb.net ... do I use XSLT, DOM, Xpath navigator, etc? If possible, I'd like to parse the file dynamically ie without having to hard code any of the node names into the VB code.
Thanks
Here is a sample of the XML

<?xml version="1.0"?>
<abcjob>
    <rptHdr>
        <rptNam>Daily Order Report</rptNam>
        <rptPrntRunDat>2007-09-26</rptPrntRunDat>
    </rptHdr>
    <abcjobGrp>
        <abcjobKeyGrp>
            <companyIdCod>ABC Company</companyIdCod>
        </abcjobKeyGrp>
        <abcjobGrp1>
            <abcjobKeyGrp1>
                <personIdCod>JohnH</personIdCod>
            </abcjobKeyGrp1>
            <abcjobGrp2>
                <abcjobKeyGrp2>
                    <prodIdCod>PC_07</prodIdCod>
                </abcjobKeyGrp2>
                <abcjobRec>
                    <tranDat>2007-09-26</tranDat>
                    <Id>1</Id>
                    <trdRptSts>P</trdRptSts>
                </abcjobRec>
                <abcjobRec>
                    <tranDat>2007-09-26</tranDat>
                    <Id>2</Id>
                    <trdRptSts>C</trdRptSts>
                </abcjobRec>
            </abcjobGrp2>
            <abcjobGrp2>
                <abcjobKeyGrp2>
                    <prodIdCod>PC_O8</prodIdCod>
                </abcjobKeyGrp2>
                <abcjobRec>
                    <tranDat>2007-09-25</tranDat>
                    <Id>1</Id>
                    <trdRptSts>P</trdRptSts>
                </abcjobRec>
            </abcjobGrp2>
        </abcjobGrp1>
        <abcjobGrp1>
            <abcjobKeyGrp1>
                <personIdCod>CliffC</personIdCod>
            </abcjobKeyGrp1>
            <abcjobGrp2>
                <abcjobKeyGrp2>
                    <prodIdCod>PC_08</prodIdCod>
                </abcjobKeyGrp2>
                <abcjobRec>
                    <tranDat>2007-09-26</tranDat>
                    <Id>1</Id>
                    <trdRptSts>P</trdRptSts>
                </abcjobRec>
                <abcjobRec>
                    <tranDat>2007-09-26</tranDat>
                    <Id>2</Id>
                    <trdRptSts>A</trdRptSts>
                </abcjobRec>
            </abcjobGrp2>
        </abcjobGrp1>
    </abcjobGrp>
</abcjob>

You could spend months trying to do that dynamically.

Without knowing how your table(s) are structured I would know where to start...



/- Sam Judson : Wrox Technical Editor -/

The table I'm uploading to is a flat table equivalent of the XML file so there is a column for each element ie companyIdCod, personIdCod, prodIdCod, tranDat, Id, trdRptSts.

When I open the xml in MS Excel, companyIdCod, personIdCod, prodIdCod are repeated for each record and this is what I want to see on my DB table.

Figured out how to do it using XSLT to convert it into a csv file that I can load into a string array and then to a datatable using an XSD.