[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Search XML / Display Value

Lets say I have an xml like this:

<?xml version='1.0' encoding='UTF-8'?>
<Config>
<ConfigEntries>
<ID>1</ID>
<Key>URL</Key>
<Value1>http://www.microsoft.com</Value1>
</ConfigEntries>
<ConfigEntries>
<ID>2</ID>
<Key>Mail</Key>
<Value1>info@microsoft.com</Value1>
</ConfigEntries>
</Config>

How can I search for "URL" in all "Key" and find the Value1 "http://www.microsoft.com"

or search for "Mail" in all "Key" and find "info@microsoft.com"

or search for 2 in all "ID" and find Value1 "info@microsoft.com" or the "Key" etc.

Eg I want to search for a certain value and display another value in the same ConfigEntries element.

By the way the xml is in a dataset.
0
netslt
Asked:
netslt
1 Solution
 
eekjCommented:
what you need is XPath

Here is a really useful tutorial that goes through how it works:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/xpath_tutorialapplication.asp

This shows how to use XPath in Visual Basic .NET apps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;317018
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now