How to Read / Search Node or Attribute in XML file

My XML file is As Below:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

</Field>

</TableRelations>

</Field>

</TableRelations>

</TableRelations>

</TableRelations>

</TableRelations>

</TableRelations>

</TableRelations>

</Field>

</TableFilters>

</CalculationFormula>

</Field>

</TableFilters>

</CalculationFormula>

</Field>

</Fields>

Searching Code

/// <summary>

///

/// </summary>

/// <param name="XMLPath">File Path</param>

/// <param name="SearchNode">Search Node</param>

/// <param name="AttributeName">Attribute Node</param>

/// <param name="AttributeValue">Attribute Value</param>

/// <param name="Connectionstring">Database ConnectionString</param>

private void InsertintoTableRelationInfo(string XMLPath, string SearchNode, string AttributeName, string AttributeValue, string Connectionstring)

{

#region Table RelationInfo

XmlDocument doc = new XmlDocument();

doc.Load(XMLPath);

System.Text.StringBuilder str = new StringBuilder();

XmlNodeList nodes = doc.GetElementsByTagName(SearchNode);

foreach (XmlNode node in nodes)

{

if (node.HasChildNodes)

{

foreach (XmlAttribute attribute in node.Attributes)

{

if (attribute.Name == AttributeName)

{

if (attribute.Value == AttributeValue)

{

for (int i = 0; i < node.ChildNodes.Count; i++)

{

string name = node.ChildNodes[i].Name;

* Check ChildNode

if (name == "TableRelations")

{

foreach (XmlAttribute chieldAttribute in node.ChildNodes[i].Attributes)

{

* Check ChildNode Attribute

if (chieldAttribute.Name == "TableID")

{

_TableRelationsTableID = Convert.ToInt32(chieldAttribute.Value);

}

if (chieldAttribute.Name == "TableName")

{

_TableName = chieldAttribute.Value;

}

if (chieldAttribute.Name == "FieldID")

{

_TableFieldID = Convert.ToInt32(chieldAttribute.Value);

}

_CalculationFormulaFlowType = "TableRelation";

using (dbNavXmlDataContext db = new dbNavXmlDataContext(Connectionstring))

{

db.USP_INSERT_TableRelationInfo(_ObjectType, _ObjectID, _ID, Convert.ToInt32(AttributeValue), _TableRelationsTableID, _TableName, _TableFieldID, _CalculationFormulaFlowType, _ReverseSign);

}

if (name == "CalculationFormula")

{

foreach (XmlAttribute chieldAttribute in node.ChildNodes[i].Attributes)

{

if (chieldAttribute.Name == "FlowType")

{

_CalculationFormulaFlowType = chieldAttribute.Value;

}

if (chieldAttribute.Name == "ReverseSign")

{

_ReverseSign = Convert.ToInt32(chieldAttribute.Value);

}

using (dbNavXmlDataContext db = new dbNavXmlDataContext(Connectionstring))

{

db.USP_INSERT_TableRelationInfo(_ObjectType, _ObjectID, _ID, Convert.ToInt32(AttributeValue), _TableRelationsTableID, _TableName, _TableFieldID, _CalculationFormulaFlowType, _ReverseSign);

}

}
}

}

}

#endregion
}

}

1 Comment

Join the conversation! Your thoughts help the community grow.

Slam Dunk15y agoedited
I am a flash developer and I found it to be so easy processing/importing XML data in AS3.0. With C# on the other hand I found it to be more like dancing with an enraged bull. So i decided to create a class file that I can import into my projects where I can just pass the variables. I looked over your article and tried applying it to reading an element attribute value and ran into a snag. Source Code below... //Global variables within class String file_reference; XmlDocument xmlDoc; XmlElement xmlElem; XmlNodeList recordSet; //XML Attribute read function public String xml_element_attribute_value(String elementName, int index, String attributeName) { if (index < recordSet.Count) { if (recordSet[index].Name.ToString() == elementName) if (recordSet[index].Attributes.Name.ToString() == attributeName) // Error:: Does not contain a definition for "Name" return recordSet[index].Attributes.Value; // Error:: Doa not contain a definition for "Value" } } XML Data is loaded via constructor function. All I am trying to do is simplifying the entire process so I can make my XML data sources more relationally formatted instead of using nested values within values. As it stands I can use element attributes as every attempt I made to use them has failed. Can you help me with this?