Example of reading data from XML into memory
Example of reading data from XML to memory
public clsSimuResultByOneGoods GetOneGoodsSimulationxml(string PathAndFileName)
{
clsSimuResultByOneGoods OneGoods = new clsSimuResultByOneGoods();//自己定义的一个类
Hashtable AllLocationResult = new Hashtable();
System.Xml.XmlTextReader r = new XmlTextReader(PathAndFileName);
string LocationID = "";
DataTable LocationTable = null;
while(r.Read())
{
if(r.NodeType == XmlNodeType.Element)
{
switch(r.LocalName)
{
case "Result":
OneGoods.GoodsCode = r.GetAttribute("GoodsCode");
OneGoods.From = Convert.ToDateTime(r.GetAttribute("FromDate"));
OneGoods.To = Convert.ToDateTime(r.GetAttribute("ToDate"));
break;
case "Location":
LocationID = r.GetAttribute("ID");
LocationTable = new DataTable();
LocationTable.Columns.Add("Date",typeof(DateTime));
LocationTable.Columns.Add("SafetyStock",typeof(decimal));
LocationTable.Columns.Add("ForecastDemand",typeof(decimal));
LocationTable.Columns.Add("FinalOutput",typeof(decimal));
LocationTable.Columns.Add("FinalInput",typeof(decimal));
LocationTable.Columns.Add("SimuStock",typeof(decimal));
LocationTable.Columns.Add("SimuStockTime",typeof(decimal));
LocationTable.Columns.Add("ImportWorkDay",typeof(bool));
LocationTable.Columns.Add("ImportWorkDay",typeof(bool));
break;
case "Record":
if(LocationTable != null)
{
DataRow dr = LocationTable.NewRow();
dr["Date"] = Convert.ToDateTime(r.GetAttribute("Date"));
if(r.GetAttribute("SafetyStock") != null && r.GetAttribute("SafetyStock") != "")
dr["SafetyStock"] = Convert.ToDecimal(r.GetAttribute("SafetyStock"));
if(r.GetAttribute("ForecastDemand") != null && r.GetAttribute("ForecastDemand") != "")
dr["ForecastDemand"] = Convert.ToDecimal(r.GetAttribute("ForecastDemand"));
if(r.GetAttribute("FinalInput") != null && r.GetAttribute("FinalInput") != "")
dr["FinalInput"] = Convert.ToDecimal(r.GetAttribute("FinalInput"));
if(r.GetAttribute("FinalOutput") != null && r.GetAttribute("FinalOutput") != "")
dr["FinalOutput"] = Convert.ToDecimal(r.GetAttribute("FinalOutput"));
if(r.GetAttribute("SimuStock") != null && r.GetAttribute("SimuStock") != "")
dr["SimuStock"] = Convert.ToDecimal(r.GetAttribute("SimuStock"));
if(r.GetAttribute("SimuStockTime") != null && r.GetAttribute("SimuStockTime") != "")
dr["SimuStockTime"] = Convert.ToDecimal(r.GetAttribute("SimuStockTime"));
if(r.GetAttribute("ImportWorkDay") != null && r.GetAttribute("ImportWorkDay") != "")
dr["ImportWorkDay"] = Convert.ToBoolean(r.GetAttribute("ImportWorkDay"));
if(r.GetAttribute("ExportWorkDay") != null && r.GetAttribute("ExportWorkDay") != "")
dr["ExportWorkDay"] = Convert.ToBoolean(r.GetAttribute("ExportWorkDay"));
LocationTable.Rows.Add(dr);
}
break;
default:
break;
}
}
else if(r.NodeType == XmlNodeType.EndElement)
{
switch(r.LocalName)
{
case "Location":
if(LocationTable != null)
{
LocationTable.AcceptChanges();
AllLocationResult.Add(LocationID,LocationTable);
LocationID = "";
LocationTable = null;
}
break;
default:
break;
}
}
}
OneGoods.AllLocationResult = AllLocationResult;
return OneGoods;
} The above is the content of the example of reading data from XML to memory. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!
Hot AI Tools
Undress AI Tool
Undress images for free
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undresser.AI Undress
AI-powered app for creating realistic nude photos
ArtGPT
AI image generator for creative art from text prompts.
Stock Market GPT
AI powered investment research for smarter decisions
Hot Article
Popular tool
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
20521
7
13634
4
XML Data Binding with Castor in Java
Aug 15, 2025 am 03:43 AM
CastorenablesXML-to-Javaobjectmappingviadefaultconventionsorexplicitmappingfiles;1)DefineJavaclasseswithgetters/setters;2)UseUnmarshallertoconvertXMLtoobjects;3)UseMarshallertoserializeobjectsbacktoXML;4)Forcomplexcases,configurefieldmappingsinmappin
Parsing XML data in Python
Jul 09, 2025 am 02:28 AM
Processing XML data is common and flexible in Python. The main methods are as follows: 1. Use xml.etree.ElementTree to quickly parse simple XML, suitable for data with clear structure and low hierarchy; 2. When encountering a namespace, you need to manually add prefixes, such as using a namespace dictionary for matching; 3. For complex XML, it is recommended to use a third-party library lxml with stronger functions, which supports advanced features such as XPath2.0, and can be installed and imported through pip. Selecting the right tool is the key. Built-in modules are available for small projects, and lxml is used for complex scenarios to improve efficiency.
Working with XML attributes vs. elements: design choices
Sep 14, 2025 am 01:21 AM
UseattributesformetadatasuchasID,status,orunit,whichdescribetheelementbutarenotcorecontent,ensuringsimplicityandcompactnesswhendataisatomic.2.Useelementsforactualdatacontent,especiallywhenitmayrequirestructure,repetition,extensibility,orfuturenesting
Working with JSON and XML Serialization in C#
Jul 31, 2025 am 04:12 AM
The choice of JSON or XML depends on the application scenario: 1. The situation of using JSON includes WebAPI return data, front-end interaction, modern service communication, and lightweight configuration; 2. The situation of using XML includes legacy system compatibility, namespace support, document-based data structures, and enterprise-level application interface specifications. In C#, .NETCore uses System.Text.Json for JSON serialization by default, with better performance and supports formatted output and null value retention; XML is implemented through XmlSerializer, suitable for old projects, and can customize tag names and namespaces, but does not support circular references, and needs to be processed manually or replaced with other libraries. Rationally select and configure serialization methods to help deal with different developments
A look at the SimpleXML library in PHP for easy XML manipulation
Jul 27, 2025 am 01:06 AM
SimpleXMListherighttoolforstraightforwardXMLmanipulationinPHP,asitconvertsXMLintoeasy-to-navigatePHPobjects.1.ItallowsloadingXMLfromastringorfileusingsimplexml_load_string()orsimplexml_load_file().2.Elementsareaccessedlikeobjectproperties,andattribut
A Comparison of XML Libraries in the Python Ecosystem
Sep 09, 2025 am 02:19 AM
ForbasicXMLtaskswithnodependencies,usexml.etree.ElementTree;2.ForadvancedfeatureslikeXPathandXSLT,chooselxml;3.Forverylargefiles,usexml.saxorlxml’siterparseformemoryefficiency;4.Forlearningorlegacycode,xml.dom.minidomisacceptable;5.Formalformedorinco
A Guide to XML Canonicalization (C14N)
Aug 27, 2025 am 06:08 AM
XMLCanonicalization(C14N)solvestheproblemofsyntacticvariabilityinXMLbyensuringlogicallyequivalentdocumentsproduceidenticalbytesequences,whichiscriticalfordigitalsignaturesandsecurecomparisons.1.CanonicalXML(C1.0)providesfullnormalizationwithattribute
python xml etree elementtree findall example
Sep 24, 2025 am 02:25 AM
Use findall() to find all matching elements in XML. 1. Get all book elements through root.findall('book') and traverse; 2. Use book.find('title').text to extract child element text; 3. Use book.get('id') to obtain attribute values; 4. Support simple XPaths such as 'book[@id]' or './/title' to find attributes or deep nested elements; 5. Conditional filtering needs to be manually implemented (such as price > 40). This method returns a list of matching elements, combining find() and findtext() can efficiently extract structured data.





