XML - get data

[Mark]

I've pasted a shortened XML file I have below. The path to the file is
strored in a string titled "myFile".

What would be the syntax for getting the crse_no and prog_type columns where
the sect_key = 176902?

Thanks in advance.
Mark

************ XML FILE BELOW **********

<?xml version="1.0" standalone="yes"?>
<CourseData>
<blah>
<cluster_cd>WB01</cluster_cd>
<sect_key>176901</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0017 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>A</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176902</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0018 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>B</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176903</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0019 </crse_no>
<crse_sec_no>002</crse_sec_no>
<prog_type>C</prog_type>
</blah>
</CourseData>

[Mark]

[STAThread]
static void Main(string[] args)
{
XmlDocument xd = new XmlDocument();
string file = @"C:\myfile.xml";
xd.Load(file);
XmlTextReader r = new XmlTextReader(file);

string strSectKey="176902";

while (r.Read())
{
if (r.NodeType == XmlNodeType.Element)
{
if ( r["sect_key"] == strSectKey)
{
Console.WriteLine(r["prog_type"] + ", " + r["crse_no"] + ", " +
r["sect_key"]);
}
}
}

Console.Read();
}

"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

I've pasted a shortened XML file I have below. The path to the file is
strored in a string titled "myFile".

What would be the syntax for getting the crse_no and prog_type columns where the sect_key = 176902?

Thanks in advance.
Mark

************ XML FILE BELOW **********

<?xml version="1.0" standalone="yes"?>
<CourseData>
<blah>
<cluster_cd>WB01</cluster_cd>
<sect_key>176901</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0017 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>A</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176902</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0018 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>B</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176903</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0019 </crse_no>
<crse_sec_no>002</crse_sec_no>
<prog_type>C</prog_type>
</blah>
</CourseData>

[Nick Malik]

you could also have used an XPath query

--- Nick

"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:eh**************@TK2MSFTNGP11.phx.gbl...

[STAThread]
static void Main(string[] args)
{
XmlDocument xd = new XmlDocument();
string file = @"C:\myfile.xml";
xd.Load(file);
XmlTextReader r = new XmlTextReader(file);

string strSectKey="176902";

while (r.Read())
{
if (r.NodeType == XmlNodeType.Element)
{
if ( r["sect_key"] == strSectKey)
{
Console.WriteLine(r["prog_type"] + ", " + r["crse_no"] + ", " +
r["sect_key"]);
}
}
}

Console.Read();
}

"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

I've pasted a shortened XML file I have below. The path to the file is
strored in a string titled "myFile".

What would be the syntax for getting the crse_no and prog_type columns

where

the sect_key = 176902?

Thanks in advance.
Mark

************ XML FILE BELOW **********

<?xml version="1.0" standalone="yes"?>
<CourseData>
<blah>
<cluster_cd>WB01</cluster_cd>
<sect_key>176901</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0017 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>A</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176902</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0018 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>B</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176903</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0019 </crse_no>
<crse_sec_no>002</crse_sec_no>
<prog_type>C</prog_type>
</blah>
</CourseData>

[Chris Ongsuco]

Mark,

You can do it like this:

string myKey = "176902";
XmlNode node1 = doc.SelectSingleNode(String.Format
("descendant::blah[@sect_key='{0}']", myKey));

Try to learn XPath as Nick suggested.

-----Original Message-----
I've pasted a shortened XML file I have below. The path to the file isstrored in a string titled "myFile".

What would be the syntax for getting the crse_no and prog_type columns wherethe sect_key = 176902?

Thanks in advance.
Mark

************ XML FILE BELOW **********

<?xml version="1.0" standalone="yes"?>
<CourseData>
<blah>
<cluster_cd>WB01</cluster_cd>
<sect_key>176901</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0017 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>A</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176902</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0018 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>B</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176903</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0019 </crse_no>
<crse_sec_no>002</crse_sec_no>
<prog_type>C</prog_type>
</blah>
</CourseData>
.

[Nick Malik]

Thanks for kicking in with an actual bit of code, Chris. That makes the
answer much more complete.

--- Nick

"Chris Ongsuco" <an*******@discussions.microsoft.com> wrote in message
news:27****************************@phx.gbl...

Mark,

You can do it like this:

string myKey = "176902";
XmlNode node1 = doc.SelectSingleNode(String.Format
("descendant::blah[@sect_key='{0}']", myKey));

Try to learn XPath as Nick suggested.

-----Original Message-----
I've pasted a shortened XML file I have below. The path

to the file is

strored in a string titled "myFile".

What would be the syntax for getting the crse_no and

prog_type columns where

the sect_key = 176902?

Thanks in advance.
Mark

************ XML FILE BELOW **********

<?xml version="1.0" standalone="yes"?>
<CourseData>
<blah>
<cluster_cd>WB01</cluster_cd>
<sect_key>176901</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0017 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>A</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176902</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0018 </crse_no>
<crse_sec_no>001</crse_sec_no>
<prog_type>B</prog_type>
</blah>
<blah>
<cluster_cd>WB02</cluster_cd>
<sect_key>176903</sect_key>
<crse_desn>CLC </crse_desn>
<crse_no>0019 </crse_no>
<crse_sec_no>002</crse_sec_no>
<prog_type>C</prog_type>
</blah>
</CourseData>
.