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 ">

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.

Here's some sample code for reading that XML file into a DataSet containing 7 DataTables:

using System;

using System.Data;

class Test

{

static void Main()

{

string fileName = "rodney.xml";

DataSet ds = new DataSet();

ds.ReadXml(fileName, XmlReadMode.InferSchema);

foreach(DataTable table in ds.Tables)

{

Console.WriteLine(table.TableName);

foreach (DataRow row in table.Rows)

{

foreach (DataColumn column in table.Columns)

{

Console.WriteLine(" {0} = {1}", column.ColumnName, row[column.ColumnName]);

}

Console.WriteLine();

}

Console.ReadKey();

}

}

The output should be:

dbo.Shipment

dbo.Shipment_Id = 0

Track = 39083

ShipQty = 20

ShipWeight = 78

DueDate = 2012-03-30T23:59:00

dbo.ShipmentItem

dbo.ShipmentItem_Id = 0

ItemGroupQty = 2

ItemGroupWeight = 60

Length = 40

Width = 40

Height = 15

dbo.Shipment_Id = 0

dbo.ShipmentItemBarcodeXRef

dbo.ShipmentItemBarcodeXRef_Id = 0

Barcode = 130485

BcodeAddedDate = 2012-03-16T14:17:00

BarcodeSequenceID = 4

BcodeDateCombo = 130485Mar 16 2012 5:55PM

dbo.ShipmentItem_Id = 0

Consol

Consol_Id = 0

ConsolID = 213

ConsolName = Indianapolis

dbo.ShipmentItemBarcodeXRef_Id = 0

Destination

Destination_Id = 0

ProcCtrID = 212

ProcCtrName = El Paso

Consol_Id = 0

ShipFrom

ShipFrom_Id = 0

SFID = 888

SFName = X Industries

Destination_Id = 0

ShipTo

STAddressId = 5543

STName = Los Pinos Plant

ShipFrom_Id = 0

Notice how extra columns are generated to act as foreign keys to link the tables together.