Searching XML file

[Hallo2oo5]

Hi,

I'm new to xml and have a question about searching an xml file and returning a result.

I have a dataset with related 2 tables (for simplicity) which I convert to an XML file.

e.g tblPerson (parent) and tblOccupation (child)

tblPerson Columns
ClientCode (pk)
FirstName
Surname

tblOccupation Columns
ClientCode (pk,fk)
Occupation

Is it possible to search the xml file for all matching values (e.g "WHERE Occupation = 'Vodafone' ") in the childTable and have it return/create an XML file with the Dataset schema and all the parent nodes (tblPerson Rows) that matched the search criteria.

I would then be able to read the xml file back into my DataSet which would update the ParentTable to only show the rows whose childTable matched the search criteria.

I don't need to know how to do this (although it'd be nice), I just need to know if this is possible so I don't waste time trying to learn how to do it only to find out it can't be done.

I hope this is clear anyway.
Thanks
Ger

 

[giadich]

what's the point for need to know only but you won't do anything with it? does it really matter then whether it is possible or not?

 

[Hallo2oo5]

All I wanted to know was, is it possible to do. If it is possible then I could read up on how to do it myself. I thought I'd get a quicker response this way since I wasn't looking for an explanation on how to do it.

 

[corey19981]

anything is possible my friend