Methods for Parsing XML files

By Jon Winer, 2004/10/01 (first published: 2002/06/20)

Methods for Parsing XML files
As we all know, in coding, there are many ways to get the same job done. In my experimentation with XML, I have run across many instances where this scenario is clearly true. Although some methods are grossly better than others, they all have a place in our programming repertoire depending on the circumstance. Take a look at some examples.

This example uses the selectSingleNode method to access the value of each node.
Example 1
This example uses the getElementsByTagName method to create a node list for each node name group. Then parses the xml file by iterating through each node list.
Example 2
This example uses the getElementsByTagName method to create a 'parent' node list, then accesses each child node based on its index.
Example 3
This example uses the getElementsByTagName method to create a 'parent' node list, then iterates through its child nodes and returns the node value and name.
Example 4

Sample File

For additional articles, please feel free to visit my homepage. Have questions, email me at jwiner1@cfl.rr.com

Total article views: 15205 | Views in the last 30 days: 5

ARTICLE

CLR Table-Valued Function Example with Full Streaming (STVF / TVF)

SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and...

FORUM

Optimizer Join Methods

Understanding the different types of joins used by the optimizer will help developers and DBAs under...

FORUM

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light up...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Methods for Parsing XML files

CLR Table-Valued Function Example with Full Streaming (STVF / TVF)

Triggers Examples

Optimizer Join Methods

Example SCD type 2

Exploring Recursive CTEs by Example

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Methods for Parsing XML files

CLR Table-Valued Function Example with Full Streaming (STVF / TVF)

Triggers Examples

Optimizer Join Methods

Example SCD type 2

Exploring Recursive CTEs by Example

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: