2
Answers

xml reader

I am receiving an xml file in that may have 1 or 1000 records with this schema (- or is it format):

<dbo.Shipment Track="39083" ShipQty="20" ShipWeight="78" DueDate="2012-03-30T23:59:00">

  <dbo.ShipmentItem ItemGroupQty="2" ItemGroupWeight="60" Length="40" Width="40" Height="15">

    <dbo.ShipmentItemBarcodeXRef Barcode="130485" BcodeAddedDate="2012-03-16T14:17:00" BarcodeSequenceID="4" BcodeDateCombo="130485Mar 16 2012  5:55PM ">

      <Consol ConsolID="213" ConsolName="Indianapolis">

        <Destination ProcCtrID="212" ProcCtrName="El Paso">

          <ShipFrom SFID="888" SFName="X Industries">

            <ShipTo STAddressId="5543" STName="Los Pinos Plant" />

          </ShipFrom>

        </Destination>

      </Consol>

    </dbo.ShipmentItemBarcodeXRef>

  </dbo.ShipmentItem>

</dbo.Shipment>

I need to open the file, read each record and place it into a data set of some sort.  I do not know how to read it or what to read the data into. (My preference would be a DataTable.)

Thank you.








Answers (2)