XPath Problems.. need help!

[Chua Wen Ching]

Hi,

I read from this tutorial at codeproject

Question A:

http://www.codeproject.com/csharp/GsXPathTutorial.asp

regarding xpath.. but i try to apply in my situation, and can't get it work...

just say this is my xml file:

Device.xml
=========
<?xml version="1.0" encoding="utf-8"?>
<DeviceList xmlns="http://tempuri.org/Device.xsd">
<!-- Device 1 -->
<Device id="1">
<Connection>
<Type>Titan12 3</Type>
<Open />
<ConfigCard>
<Name>Titan Suprema</Name>
<Length>13</Length>
</ConfigCard>
</Connection>
</Device>
<Device id="2">
<Connection>
<Type>BBB Hardware</Type>
<Open />
<ConfigCard>
<Name>BBB DH</Name>
<Length>6</Length>
</ConfigCard>
</Connection>
</Device>
</DeviceList>

In my C# code,

string devicePath = Application.Sta rtupPath + @"\device.xm l";
// open XmlTextReader
....
int nMaxId = 0;

// get maximum devices within XML script
while(xmlDevice .Read())
{
if (xmlDevice.IsSt artElement() && xmlDevice.Name == "Device")
{
int nId = Int32.Parse(xml Device.GetAttri bute("id"));

if (nMaxId < nId)
nMaxId = nId;
}
}
}

// Execute XPath here
XPathDocument xdoc = new XPathDocument(d evicePath);
XPathNavigator nav = xdoc.CreateNavi gator();

// loop into 2 possible devices and extract particular information
for (int i = 1; i < nMaxId + 1; i++)
{
XPathNodeIterat or nodeItor = nav.Select(
"DeviceList/Device[@id='" + i + "']/Connection");
nodeItor.MoveNe xt();

TraverseChildre n(nodeItor);
}
....

// from the article
private void TraverseChildre n(XPathNodeIter ator nodeItor)
{
XPathNodeIterat or igor = nodeItor.Clone( );
igor.Current.Mo veToFirstChild( );
bool more = false;
do
{
PrintNode(igor. Current);
more = igor.Current.Mo veToNext();
}while(more);
}

private void PrintNode(XPath Navigator nav)
{
MessageBox.Show ("Value: " + nav.Value +
" Type : " + nav.NodeType.To String());
}

From this solution:

i get this instead:

MessageBox1 - Value: Titan123 Titan Suprema 13BBB Hardware BBB DH 6
MessageBox2 - Value: Titan123 Titan Suprema 13BBB Hardware BBB DH 6
(repeat the same message - why?)

Any help please?

I want to get the Output of this:

MessageBox1 - Value: Titan123 Titan Suprema 13
MessageBox2 - Value: BBB Hardware BBB H 6

Question B:

By the way how can i get the value of individual Type example,

showing the output here:

Type - Titan123
Name - Titan Suprema
Length - 13

i always only manage to get the type which is "Name" and the whole message
"Titan123 Titan Suprema 13" instead separate data.

Any help please? Thanks.
--
Regards,
Chua Wen Ching
Visit us at http://www.necoders.com

[Dan Bass]

Chua Wen Ching,

This seems a little overkill for what you are trying to do...

I wrote a short, but complete application that does more what I think you
want:

using System;
using System.Xml;
using System.Xml.XPat h;

namespace XmlXpathParser
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{

// load the xml into the dom
XmlDocument myDoc = new XmlDocument();
myDoc.Load ( @"XmlFile1.x ml" );

// select all deviceID nodes
XmlNodeList nodes = myDoc.SelectNod es ( "DeviceList/Device" );

// display details on each
foreach ( XmlNode deviceNode in nodes )
{
DisplayDeviceNo de ( deviceNode );
}

// wait for user response before closing
Console.WriteLi ne ( "----- press any key" );
Console.Read();
}

static void DisplayDeviceNo de ( XmlNode deviceNode )
{
string type = deviceNode.Sele ctSingleNode (
"Connection/Type" ).InnerText;
string name = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Name" ).InnerText;
string length = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Length").InnerT ext;

Console.WriteLi ne ( "type = {0}, name = {1}, length = {2}",
type, name, length );
}
}
}

All you need to add is some error checking for if nodes don't exist, and
exception handling for catching problems if data is corrupted.
Beware the hard coded string for the xml file... All I did was cut and paste
your xml into "XmlFile1.x ml".

HTH.

Dan.

[Chua Wen Ching]

Hi Dan Bass,

Thanks alot. It reallys helps me. But i do notice that it seems to process
a lot unlike xpath, well it is fast.. but i can't get what i want earlier (in
my previous email).

Can i do with xpath? Any tips? i heard xpath is much faster.

Cheers. Hooray :)

"Dan Bass" wrote:

Chua Wen Ching,

This seems a little overkill for what you are trying to do...

I wrote a short, but complete application that does more what I think you
want:

using System;
using System.Xml;
using System.Xml.XPat h;

namespace XmlXpathParser
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{

// load the xml into the dom
XmlDocument myDoc = new XmlDocument();
myDoc.Load ( @"XmlFile1.x ml" );

// select all deviceID nodes
XmlNodeList nodes = myDoc.SelectNod es ( "DeviceList/Device" );

// display details on each
foreach ( XmlNode deviceNode in nodes )
{
DisplayDeviceNo de ( deviceNode );
}

// wait for user response before closing
Console.WriteLi ne ( "----- press any key" );
Console.Read();
}

static void DisplayDeviceNo de ( XmlNode deviceNode )
{
string type = deviceNode.Sele ctSingleNode (
"Connection/Type" ).InnerText;
string name = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Name" ).InnerText;
string length = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Length").InnerT ext;

Console.WriteLi ne ( "type = {0}, name = {1}, length = {2}",
type, name, length );
}
}
}

All you need to add is some error checking for if nodes don't exist, and
exception handling for catching problems if data is corrupted.
Beware the hard coded string for the xml file... All I did was cut and paste
your xml into "XmlFile1.x ml".

HTH.

Dan.

[Chua Wen Ching]

Hi Dan,

2 more things to add on.

exception handling for catching problems if data is corrupted
--> Why do i need to catch problems if data is corrupted? Any examples? Coz
i will be writing the script in xml manually, and process it in C#.

Beware the hard coded string for the xml file
--> I don't get your meaning here. Hard coded string ???

Cheers.

"Dan Bass" wrote:

Chua Wen Ching,

This seems a little overkill for what you are trying to do...

I wrote a short, but complete application that does more what I think you
want:

using System;
using System.Xml;
using System.Xml.XPat h;

namespace XmlXpathParser
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{

// load the xml into the dom
XmlDocument myDoc = new XmlDocument();
myDoc.Load ( @"XmlFile1.x ml" );

// select all deviceID nodes
XmlNodeList nodes = myDoc.SelectNod es ( "DeviceList/Device" );

// display details on each
foreach ( XmlNode deviceNode in nodes )
{
DisplayDeviceNo de ( deviceNode );
}

// wait for user response before closing
Console.WriteLi ne ( "----- press any key" );
Console.Read();
}

static void DisplayDeviceNo de ( XmlNode deviceNode )
{
string type = deviceNode.Sele ctSingleNode (
"Connection/Type" ).InnerText;
string name = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Name" ).InnerText;
string length = deviceNode.Sele ctSingleNode (
"Connection/ConfigCard/Length").InnerT ext;

Console.WriteLi ne ( "type = {0}, name = {1}, length = {2}",
type, name, length );
}
}
}

All you need to add is some error checking for if nodes don't exist, and
exception handling for catching problems if data is corrupted.
Beware the hard coded string for the xml file... All I did was cut and paste
your xml into "XmlFile1.x ml".

HTH.

Dan.

[Dan Bass]

In the example I'm using it is done using XPath references... The functions
SelectNodes and SelectSingleNod e take in an XPath string.

2 more things to add on.

exception handling for catching problems if data is corrupted
--> Why do i need to catch problems if data is corrupted? Any examples?
Coz
i will be writing the script in xml manually, and process it in C#.
around all this you need to place "try {} catch {} finally" statements to
catch errors that may occur.
www.c-sharpcorner.com/ExceptionHandling.asp

Beware the hard coded string for the xml file
--> I don't get your meaning here. Hard coded string ???

I was simply refering the line
: myDoc.Load ( @"XmlFile1.x ml" );
make sure the filename is correct for what you need.

Let me know if you need more help.

Thanks.

Dan.

[Chua Wen Ching]

Oh i see...

Thanks Dan Bass. It really helped me a lot. Now i am on the right track :)
Cheers.

"Dan Bass" wrote:

In the example I'm using it is done using XPath references... The functions
SelectNodes and SelectSingleNod e take in an XPath string.

2 more things to add on.

exception handling for catching problems if data is corrupted
--> Why do i need to catch problems if data is corrupted? Any examples?
Coz
i will be writing the script in xml manually, and process it in C#.

around all this you need to place "try {} catch {} finally" statements to
catch errors that may occur.
www.c-sharpcorner.com/ExceptionHandling.asp

Beware the hard coded string for the xml file
--> I don't get your meaning here. Hard coded string ???

I was simply refering the line
: myDoc.Load ( @"XmlFile1.x ml" );
make sure the filename is correct for what you need.

Let me know if you need more help.

Thanks.

Dan.