Reading a value from XMLDatasource

[Joe]

I have a ComboBox which is bound to a XmlDatasource. The XML has 3
attributes: name, location, value. I have name and location bound to the
ComboBox.

Now what I want to do is get the name/location for the node with value = 9.

It doesn't seem like the XmlDatasource has any methods for iterating over
the nodes.

Is there any easy way to do this?

The XMl is simple:
<Parent>
<child name="" location="" value=""/>
<child name="" location="" value=""/>
<child name="" location="" value=""/>
</Parent>

Thanks,
Joe

 

[Steven Cheng[MSFT]]

Hi Joe,

For the the following requirement you mentioned:
Now what I want to do is get the name/location for the node with value = 9.
<<<<<

do you mean you want to programmatically in code to extract the certain XML
Node from the XmlDataSource's data (xml document)? If so, you can use the
"GetXmlDocument" method to get the in-memory xml content and perform Xpath
query to extract the values. e.g.

===================
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument doc = XmlDataSource1.GetXmlDocument();

XmlNodeList nodes = doc.SelectNodes("//child[@value='9']");

foreach (XmlNode node in nodes)
{
Response.Write("<br/>name: " + node.Attributes["name"].Value +
", location: " + node.Attributes["location"].Value);
}
}
======================

If you have any more specific concern, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Joe]

That worked perfect. Thanks!

Hi Joe,

For the the following requirement you mentioned:
Now what I want to do is get the name/location for the node with value =
9.
<<<<<

do you mean you want to programmatically in code to extract the certain
XML
Node from the XmlDataSource's data (xml document)? If so, you can use the
"GetXmlDocument" method to get the in-memory xml content and perform Xpath
query to extract the values. e.g.

===================
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument doc = XmlDataSource1.GetXmlDocument();

XmlNodeList nodes = doc.SelectNodes("//child[@value='9']");

foreach (XmlNode node in nodes)
{
Response.Write("<br/>name: " + node.Attributes["name"].Value +
", location: " + node.Attributes["location"].Value);
}
}
======================

If you have any more specific concern, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no
rights.