The example below is the easiest way how to read XML File.
Let say this is your XML file / XML data.
XML
1: <?xml version="1.0" encoding="utf-8" ?>
2: <COM_SKU>
3: <SKUID>13</SKUID>
4: <SKUName>SKUNAME</SKUName>
5: <SKUPrice>888</SKUPrice>
6: <SKUEnabled>true</SKUEnabled>
7: <SKUDepartmentID>2</SKUDepartmentID>
8: <SKUGUID>6f6cb5e8-2b24-4749-a6ca-3fba0811d770</SKUGUID>
9: <SKUImagePath>ImagePath</SKUImagePath>
10: <SKUAvailableItems>-35</SKUAvailableItems>
11: <SKUSellOnlyAvailable>false</SKUSellOnlyAvailable>
12: <SKULastModified>2016-03-18T15:53:20.2838432+08:00</SKULastModified>
13: <SKUCreated>2016-03-09T15:27:58.1405717+08:00</SKUCreated>
14: <SKUSiteID>1</SKUSiteID>
15: <SKUNeedsShipping>false</SKUNeedsShipping>
16: <SKUProductType>PRODUCT</SKUProductType>
17: <SKUConversionValue>0</SKUConversionValue>
18: <SKUAllowAllVariants>false</SKUAllowAllVariants>
19: <SKUInheritsTaxClasses>false</SKUInheritsTaxClasses>
20: <SKUInheritsDiscounts>false</SKUInheritsDiscounts>
21: <SKUTrackInventory>ByProduct</SKUTrackInventory>
22: <SKUInStoreFrom>2015-09-03T17:18:41+08:00</SKUInStoreFrom>
23: </COM_SKU>
It does not matter either the xml is a file or is a string data. You can read the xml data using code example below.
Code Example
1: StringReader xmlSR = new StringReader(String.Join(Environment.NewLine, File.ReadAllLines("XMLFile1.xml")));
2: DataSet SKU = new DataSet();
3: SKU.ReadXml(xmlSR);
4: foreach (DataRow rowXML in SKU.Tables[0].Rows)
5: {
6: Console.WriteLine(rowXML["<xml element>"].ToString());
7: //eg: Console.WriteLine(rowXML["SKUID"].ToString());
8: }
The above code example is to read xml from files. To read XML from string, change first line code to code below.
1: StringReader xmlSR = new StringReader("<xml data here>");
0 comments:
Post a Comment