 Forum main page
Most
active member
Login page
Register
Log out
Search page
View our event calendar
Add general event such as an
upcoming software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the most
active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
Searching an XML file - 23 April 2007
|
|
|
Hallo2oo5
Posts: 1
Score: 0
Joined: 23 April 2007
Status: offline
|
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
|
|
|
|
RE: Searching an XML file - 5 June 2007
|
|
|
HZ
Posts: 270
Score: 6
Joined: 10 March 2004
From: Toronto, ON, CANADA
Status: offline
|
You can achieve your goal by either search from Xml or from your dataset directly
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML