--- "Woodard, John" <[EMAIL PROTECTED]> wrote:
> Philip,
>
> I'm having trouble understanding your example given that I don't how your
> tables and records are layed out, so I can't complete the mental diagram.
Ah the beauty and horror of cut and paste ;-)
> It looks like mapData is the parent, b
hilip Nelson [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 2:12 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Advanced DataSet Queries
Here is an example that relies on the fact that .net will automatically
create a relationship between the tables where there are xml nest
Here is an example that relies on the fact that .net will automatically create
a relationship between the tables where there are xml nested elements. In your
example person will be a parent of color because the color elements are nested
in the person elements.
string autoRelation;
string childFilt
Assuming you are attempting to retrieve a set of matching nodes _after_ you
have an XML document (versus filtering out the non-matching nodes _before_
translating into XML), why not use an XPath query? In particular, see the
System.Xml.XPath namespace and the System.Xml.XPath.XPathNavigator class.
I am looking for a way to do an advanced query quickly and efficiently.
Given the following XML structure read into a DataSet of people and the
colors they are wearing:
One
Red
Green
Blue
Two
Red
Green
Orange
Three
Blue
Green
Orange
Which wou
