xml reader

Question

I am receiving an xml file in that may have 1 or 1000 records with this schema (- or is it format): Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;} 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.

Vulpes · Answer

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.

Rodney Johnson · Answer

Thanks