Please ... example code due on looping though specific nodes

[gator]

I am quite new to XML and posted a request for example code yesterday.
Unfortunately, I did not do a very good job in explaining what I was
looking for. Here is an example of a small piece of the file:

<Scoreboard>
<Events>
<Event ID="001212" Name="EventName 1" />
<Event ID="001213" Name="EventName 2" />
<Event ID="001214" Name="EventName 3" />
<Event ID="001215" Name="EventName 4" />
</Events>
<EventTypes>
<EventType ID="01" SingleGame="tru e" Name="EventName 1" />
<EventType ID="02" SingleGame="tru e" Name="EventName 2" />
<EventType ID="03" SingleGame="tru e" Name="EventName 3" />
<EventType ID="04" SingleGame="tru e" Name="EventName 4" />
<EventType ID="05" SingleGame="tru e" Name="EventName 5" />
<EventType ID="06" SingleGame="tru e" Name="EventName 6" />
<EventType ID="07" SingleGame="tru e" Name="EventName 7" />
</EventTypes>
<Teams>
<Team ID="11" City="City1" Name="Name1" City="City1"
Nickname="nickn ame1" Conference="Con ference1">
<Player ID="91" />
<Player ID="190" />
<Player ID="77" />
<Player ID="133" />
<Player ID="144" />
<Player ID="195" />
<Player ID="220" />
<Player ID="231" />
<Player ID="214" />
<Team ID="13" City="City2" Name="Name2" City="City2"
Nickname="nickn ame2" Conference="Con ference1">
<Player ID="91" />
<Player ID="190" />
<Player ID="77" />
<Player ID="133" />
<Player ID="144" />
<Player ID="195" />
<Player ID="220" />
<Player ID="231" />
<Player ID="214" />
</Team>
</Teams>
<Match ID="999" StatusType="6" IsChallengeEnab led="false"
VenueID="NBB" SchedDate="2006-07-30" SchedTime="13:0 0"
ElapsedTime="02 :01" Winner="H" Attendance="" Final="Y">
<ChairUmpires >
<ChairUmpire Num="1" Name="" />
<ChairUmpire Num="2" Name="" />
</ChairUmpires>
<Teams>
<Team ID="1" Type="H" ChallengesMade= "5" ChallengesWon=" 3">
<Player ID="162" Coach="N" />
<Player ID="92" Coach="N" />
<Player ID="127" Coach="N" />
<Player ID="183" Coach="N" />
<Player ID="58" Coach="Y" />
<Stats FSPts="77" FSPtsWon="53" SSPts="21" SSPtsWon="11"
FSAces="2" SSAces="2" DF="2" TeamBrkPts="16" TeamBrkPtsWon=" 6"
TotPtsWon="110" TeamDeucePts="6 " TeamDeucePtsWon ="1" GamesPlayed="35 "
GamesWon="21" />
</Team>
</Match>
</Scoreboard>

How could I loop through a specific node, such as "Scoreboard/Teams"
and pull out all the information for ONLY that specific node? Once
that is done I would like to be able to move to another node such as
"Match/Teams" and loop through only that node and get all the info. I
would not need to loop through every node in the file, just specific
ones.

As I mentioned, this is just a small sample of the file, it is more
complex than this, but if I could get to this stage I could figure the
rest out. All this info must be put into a database.

Please if anyone has an example on how to do this, I would really
appreciate it. I am in urgent need of getting this done immediately.

Thanks,
Steve

[Moty Michaely]

On Jun 3, 5:58 pm, gator <glb...@gmail.c omwrote:

I am quite new to XML and posted a request for example code yesterday.
Unfortunately, I did not do a very good job in explaining what I was
looking for. Here is an example of a small piece of the file:

<Scoreboard>
<Events>
<Event ID="001212" Name="EventName 1" />
<Event ID="001213" Name="EventName 2" />
<Event ID="001214" Name="EventName 3" />
<Event ID="001215" Name="EventName 4" />
</Events>
<EventTypes>
<EventType ID="01" SingleGame="tru e" Name="EventName 1" />
<EventType ID="02" SingleGame="tru e" Name="EventName 2" />
<EventType ID="03" SingleGame="tru e" Name="EventName 3" />
<EventType ID="04" SingleGame="tru e" Name="EventName 4" />
<EventType ID="05" SingleGame="tru e" Name="EventName 5" />
<EventType ID="06" SingleGame="tru e" Name="EventName 6" />
<EventType ID="07" SingleGame="tru e" Name="EventName 7" />
</EventTypes>
<Teams>
<Team ID="11" City="City1" Name="Name1" City="City1"
Nickname="nickn ame1" Conference="Con ference1">
<Player ID="91" />
<Player ID="190" />
<Player ID="77" />
<Player ID="133" />
<Player ID="144" />
<Player ID="195" />
<Player ID="220" />
<Player ID="231" />
<Player ID="214" />
<Team ID="13" City="City2" Name="Name2" City="City2"
Nickname="nickn ame2" Conference="Con ference1">
<Player ID="91" />
<Player ID="190" />
<Player ID="77" />
<Player ID="133" />
<Player ID="144" />
<Player ID="195" />
<Player ID="220" />
<Player ID="231" />
<Player ID="214" />
</Team>
</Teams>
<Match ID="999" StatusType="6" IsChallengeEnab led="false"
VenueID="NBB" SchedDate="2006-07-30" SchedTime="13:0 0"
ElapsedTime="02 :01" Winner="H" Attendance="" Final="Y">
<ChairUmpires >
<ChairUmpire Num="1" Name="" />
<ChairUmpire Num="2" Name="" />
</ChairUmpires>
<Teams>
<Team ID="1" Type="H" ChallengesMade= "5" ChallengesWon=" 3">
<Player ID="162" Coach="N" />
<Player ID="92" Coach="N" />
<Player ID="127" Coach="N" />
<Player ID="183" Coach="N" />
<Player ID="58" Coach="Y" />
<Stats FSPts="77" FSPtsWon="53" SSPts="21" SSPtsWon="11"
FSAces="2" SSAces="2" DF="2" TeamBrkPts="16" TeamBrkPtsWon=" 6"
TotPtsWon="110" TeamDeucePts="6 " TeamDeucePtsWon ="1" GamesPlayed="35 "
GamesWon="21" />
</Team>
</Match>
</Scoreboard>

How could I loop through a specific node, such as "Scoreboard/Teams"
and pull out all the information for ONLY that specific node? Once
that is done I would like to be able to move to another node such as
"Match/Teams" and loop through only that node and get all the info. I
would not need to loop through every node in the file, just specific
ones.

As I mentioned, this is just a small sample of the file, it is more
complex than this, but if I could get to this stage I could figure the
rest out. All this info must be put into a database.

Please if anyone has an example on how to do this, I would really
appreciate it. I am in urgent need of getting this done immediately.

Thanks,
Steve

Hi Steve,

Try using XPathNavigator class.
http://msdn2.microsoft.com/en-us/lib...navigator.aspx

Hope this helps.
Moty

[Peter Duniho]

On Sun, 03 Jun 2007 07:58:06 -0700, gator <gl****@gmail.c omwrote:

I am quite new to XML and posted a request for example code yesterday.
Unfortunately, I did not do a very good job in explaining what I was
looking for. Here is an example of a small piece of the file:

.. [...]

>
How could I loop through a specific node, such as "Scoreboard/Teams"
and pull out all the information for ONLY that specific node? Once
that is done I would like to be able to move to another node such as
"Match/Teams" and loop through only that node and get all the info. I
would not need to loop through every node in the file, just specific
ones.

There is no need to start a new thread, or even to repost the sample
data. If you feel that you should elaborate or clarify the original post,
you can and should simply reply in that original thread, so that all of
the related posts stay together.

Hopefully Moty's reply addresses your question. If not, then you should
probably be more specific about what exactly is in the way here. Are you
having trouble actually reading the data, as your most recent posts
suggests? Or is there something else about the desired goal you're having
trouble implementing? If so, what exactly is it that you're trying and
not having success with?

Pete

[Aneesh P]

On Jun 3, 9:35 pm, "Peter Duniho" <NpOeStPe...@nn owslpianmk.com>
wrote:

On Sun, 03 Jun 2007 07:58:06 -0700, gator <glb...@gmail.c omwrote:

I am quite new to XML and posted a request for example code yesterday.
Unfortunately, I did not do a very good job in explaining what I was
looking for. Here is an example of a small piece of the file:

. [...]

How could I loop through a specific node, such as "Scoreboard/Teams"
and pull out all the information for ONLY that specific node? Once
that is done I would like to be able to move to another node such as
"Match/Teams" and loop through only that node and get all the info. I
would not need to loop through every node in the file, just specific
ones.

There is no need to start a new thread, or even to repost the sample
data. If you feel that you should elaborate or clarify the original post,
you can and should simply reply in that original thread, so that all of
the related posts stay together.

Hopefully Moty's reply addresses your question. If not, then you should
probably be more specific about what exactly is in the way here. Are you
having trouble actually reading the data, as your most recent posts
suggests? Or is there something else about the desired goal you're having
trouble implementing? If so, what exactly is it that you're trying and
not having success with?

Pete

Use
XmlDataDocument xmlDoc = new XmlDataDocument ();
xmlDoc.Load("Sa mple.xml"); //or use xmlDoc.LoadXml( xmlData);//xmlData
is string
XmlNode myNode =xmlDoc.SelectS ingleNode(""/mytable/myrow");//modify
path according to ur xml schema
Now you can use:
foreach (XmlNode fieldNode in myNode.ChildNod es)
{
}

I guess Moly has given the right thing for you. This'd be pretty easy
for you. Good luck!

[Mr. Arnold]

<snipped>

>
Please if anyone has an example on how to do this, I would really
appreciate it. I am in urgent need of getting this done immediately.

You mean to sit there and say that you cannot go out to Google and find
examples on how to do this and put two and two together?

You mean to say that you have to post to a NG and be crutched along, because
you're too lazy to go find an example of this yourself? :)

[Peter Duniho]

On Sun, 03 Jun 2007 13:34:52 -0700, Mr. Arnold <MR. <Ar****@Arnold. com>>
wrote:

[abusive reply snipped] :)

Honestly. How does putting a smiley at the end of that post make it okay?

Most of the questions that are answered here could be addressed through
just reading the MSDN documentation, or experimenting with the API. I
don't think that justifies writing hostile replies such as yours when
someone posts such a question.

I have to admit, I have a hard time understanding the question, because it
looks like a pretty straightforward task to me. But I accept that not
everyone can "see" the solution right away, nor do I always "see" the
solution right away. It's a matter of perspective and sometimes what
seems like a dumb question really just needs someone to figure out what's
wrong with the poster's perspective and help them work their way to a
different point of view.

Regardless, I don't think that harassing someone just because they asked a
question is reasonable.

Pete

[Mr. Arnold]

There you go again trying put your spin on what I was saying. You simply
need to mind your own business and stay out of mine.

[gator]

On Jun 3, 5:17 pm, "Mr. Arnold" <MR. Arn...@Arnold.c omwrote:

There you go again trying put your spin on what I was saying. You simply
need to mind your own business and stay out of mine.

What is wrong with you? If you don't like my question ... don't
answer it. You told that guy to mind his own business, why don't you
take your advice and stay out of mine.

[gator]

On Jun 3, 1:08 pm, Aneesh P <anees...@gmail .comwrote:

On Jun 3, 9:35 pm, "Peter Duniho" <NpOeStPe...@nn owslpianmk.com>
wrote:

On Sun, 03 Jun 2007 07:58:06 -0700, gator <glb...@gmail.c omwrote:

I am quite new to XML and posted a request for example code yesterday.
Unfortunately, I did not do a very good job in explaining what I was
looking for. Here is an example of a small piece of the file:

. [...]

How could I loop through a specific node, such as "Scoreboard/Teams"
and pull out all the information for ONLY that specific node? Once
that is done I would like to be able to move to another node such as
"Match/Teams" and loop through only that node and get all the info. I
would not need to loop through every node in the file, just specific
ones.

There is no need to start a new thread, or even to repost the sample
data. If you feel that you should elaborate or clarify the original post,
you can and should simply reply in that original thread, so that all of
the related posts stay together.

Hopefully Moty's reply addresses your question. If not, then you should
probably be more specific about what exactly is in the way here. Are you
having trouble actually reading the data, as your most recent posts
suggests? Or is there something else about the desired goal you're having
trouble implementing? If so, what exactly is it that you're trying and
not having success with?

Pete

Use
XmlDataDocument xmlDoc = new XmlDataDocument ();
xmlDoc.Load("Sa mple.xml"); //or use xmlDoc.LoadXml( xmlData);//xmlData
is string

XmlNode myNode =xmlDoc.SelectS ingleNode(""/mytable/myrow");//modify
path according to ur xml schema

Now you can use:
foreach (XmlNode fieldNode in myNode.ChildNod es)
{

}

I guess Moly has given the right thing for you. This'd be pretty easy
for you. Good luck!- Hide quoted text -

- Show quoted text -

Thanks to all for the help ... it's really appreciated.

- Steve

[Mr. Arnold]

"Mark Rae" <ma**@markNOSPA Mrae.netwrote in message
news:eN******** ******@TK2MSFTN GP06.phx.gbl...

"Mr. Arnold" <MR. Ar****@Arnold.c omwrote in message
news:Op******** ******@TK2MSFTN GP05.phx.gbl...

>There you go again trying put your spin on what I was saying. You simply
need to mind your own business and stay out of mine.

Seems like good advice for everyone - <plonk>

I agree <Plank>. <g>