ARTICLE

How to Read / Search Node or Attribute in XML file

Posted by Gohil Jayendrasinh in Articles | XML on December 21, 2010

Tags: Read in XML file, xml file, XML, Search Noded in xml, Xml attribute

In this article you will learn how to Read / Search Node or Attribute in XML file.

Tweet
11976
1

Reader Level: Beginner

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
            }

        }

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

Merge 2 XML files into single XML using C#

Tags: C#, C# Merge XML files, Merge XML, XML Merge, C# document
How to Read From XML Document

Tags: Read From XML Document, XML, XML Document, Read operation in xml

post comment

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?

Posted by Slam Dunk on Dec 23, 2010

COMMENT USING

PREMIUM SPONSORS

iPhone, Android & Web Development Services

Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.

TRENDING UP

Create Outlook Add-in by MAPI Functionality by Using Visual Studio 2010 Outlook Project Debugging jQuery in ASP.NET How to Enable Sign in as Different User Option in SharePoint 2013 Top 10 HTML5 Interview Questions Find and Delete Duplicate Records From SQL Table Custom Paging With GridView in ASP.NET 4.5 Encrypt and Decrypt in SQL Server: Part 2 How to Select Multiple Rows in Grid Using LightSwitch 2012 Working With Database in HTML5 Panel Default Button is Not Working For Rad Combobox

View All

MOST LIKED ARTICLE

WCF Introduction and Contracts - Day 1 Create SSRS Report Using Report Wizard CREATE READ UPDATE and DELETE - CRUD Operation Using LINQ to SQL WCF - Data Contract - Day 4 WCF - Difference Between Service Application and Service Library: Day 5

Follow @twitterapi

Options	Votes	%
Lenovo	40	10.26
HP	19	4.87
Dell	213	54.62
Toshiba	54	13.85
Acer	48	12.31
Sony	16	4.10
Total	390	100%

In Focus

How to Read / Search Node or Attribute in XML file

Related Articles


Favorite Computer Manufacturer

Who is your favorite Computer manufacturer?

Lenovo HP Dell Toshiba Acer Sony