473,386 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

XML

Currently I have an XML file that come from an external program that looks
something like this:

<?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
APPVERSION="19">
<FRUITBOWL Name="bowl1" Size="6" >
<FRUIT Type="Apple" Quanity="1" Size="Big"
Brand="Red Del." >
</FRUIT>
<FRUIT Type="Orange" Quanity="2" Size="small"
Brand="none">
</FRUIT>
</FRUIT BOWL>
<FRUITBOWL Name="bowl2" Size="24" >
<FRUIT Type="Apple" Quanity="16" Size="small"
Brand="Other" >
</FRUIT>
<FRUIT Type="Grape" Quanity="2" Size="medium"
Brand="none">
</FRUIT>
</FRUIT BOWL>
</XML_FRUITBOWL_DATA_FILE>
At any time the external program could change and a new property could be
added. What is the best way for me to interact with this file? Can I read
it in as a generic object and access properties with the dot notation? Or
do I need to interact with the file with SQL statement with ADO .NET?

Nov 21 '05 #1
6 2094
August 9, 2005

There are MANY ways you can read that file.... ADO.Net & SQL would be
complicated for such a simple task. Just look into Dataset.ReadXML &
XPathNavigators & XMLDocuments.... easy ways to retrieve data from XML
Files.... if the file changes, I would use a FileMonitor class (I hope that
is the exact name of it... I forget, maybe FileWatcher?) which will fire an
event that you can use to read the new file when it changes... I hope this
helps and have a great day!

--
Joseph Bittman
Microsoft Certified Solution Developer

Web Site: http://71.39.42.23
Static IP


"David A. Osborn" <do********@hotmail.com> wrote in message
news:tT8Ke.235195$x96.189382@attbi_s72...
Currently I have an XML file that come from an external program that looks
something like this:

<?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
APPVERSION="19">
<FRUITBOWL Name="bowl1" Size="6" >
<FRUIT Type="Apple" Quanity="1" Size="Big"
Brand="Red Del." >
</FRUIT>
<FRUIT Type="Orange" Quanity="2" Size="small"
Brand="none">
</FRUIT>
</FRUIT BOWL>
<FRUITBOWL Name="bowl2" Size="24" >
<FRUIT Type="Apple" Quanity="16" Size="small"
Brand="Other" >
</FRUIT>
<FRUIT Type="Grape" Quanity="2" Size="medium"
Brand="none">
</FRUIT>
</FRUIT BOWL>
</XML_FRUITBOWL_DATA_FILE>
At any time the external program could change and a new property could be
added. What is the best way for me to interact with this file? Can I
read it in as a generic object and access properties with the dot
notation? Or do I need to interact with the file with SQL statement with
ADO .NET?


Nov 21 '05 #2
What I meant by the file changing was that the the file format may change,
ie another property may be added so I don't want to have to rewrite this
code every time the vendor of the software updates their software. What
would be nice is if I could pull the XML in as an object that automatically
had the properties that were listed in the XML, but I don't even know if
that is possible. I think I am sort of looking for the opposite of a
serialized class, if that makes any sense. Turn the XML into an object
without actually knowing what that object is.
"Joseph Bittman MCSD" <Ry*********@msn.com> wrote in message
news:OM**************@TK2MSFTNGP14.phx.gbl...
August 9, 2005

There are MANY ways you can read that file.... ADO.Net & SQL would be
complicated for such a simple task. Just look into Dataset.ReadXML &
XPathNavigators & XMLDocuments.... easy ways to retrieve data from XML
Files.... if the file changes, I would use a FileMonitor class (I hope
that is the exact name of it... I forget, maybe FileWatcher?) which will
fire an event that you can use to read the new file when it changes... I
hope this helps and have a great day!

--
Joseph Bittman
Microsoft Certified Solution Developer

Web Site: http://71.39.42.23
Static IP


"David A. Osborn" <do********@hotmail.com> wrote in message
news:tT8Ke.235195$x96.189382@attbi_s72...
Currently I have an XML file that come from an external program that
looks something like this:

<?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
APPVERSION="19">
<FRUITBOWL Name="bowl1" Size="6" >
<FRUIT Type="Apple" Quanity="1" Size="Big"
Brand="Red Del." >
</FRUIT>
<FRUIT Type="Orange" Quanity="2" Size="small"
Brand="none">
</FRUIT>
</FRUIT BOWL>
<FRUITBOWL Name="bowl2" Size="24" >
<FRUIT Type="Apple" Quanity="16" Size="small"
Brand="Other" >
</FRUIT>
<FRUIT Type="Grape" Quanity="2" Size="medium"
Brand="none">
</FRUIT>
</FRUIT BOWL>
</XML_FRUITBOWL_DATA_FILE>
At any time the external program could change and a new property could be
added. What is the best way for me to interact with this file? Can I
read it in as a generic object and access properties with the dot
notation? Or do I need to interact with the file with SQL statement with
ADO .NET?




Nov 21 '05 #3

what's more important at this point is to determine what your application is
doing with the file...or any new properties. are you just trying to find a
way to better visually display (for readability sake) the xml?
"David A. Osborn" <do********@hotmail.com> wrote in message
news:eUcKe.235790$x96.175955@attbi_s72...
| What I meant by the file changing was that the the file format may change,
| ie another property may be added so I don't want to have to rewrite this
| code every time the vendor of the software updates their software. What
| would be nice is if I could pull the XML in as an object that
automatically
| had the properties that were listed in the XML, but I don't even know if
| that is possible. I think I am sort of looking for the opposite of a
| serialized class, if that makes any sense. Turn the XML into an object
| without actually knowing what that object is.
|
|
| "Joseph Bittman MCSD" <Ry*********@msn.com> wrote in message
| news:OM**************@TK2MSFTNGP14.phx.gbl...
| > August 9, 2005
| >
| > There are MANY ways you can read that file.... ADO.Net & SQL would be
| > complicated for such a simple task. Just look into Dataset.ReadXML &
| > XPathNavigators & XMLDocuments.... easy ways to retrieve data from XML
| > Files.... if the file changes, I would use a FileMonitor class (I hope
| > that is the exact name of it... I forget, maybe FileWatcher?) which will
| > fire an event that you can use to read the new file when it changes... I
| > hope this helps and have a great day!
| >
| > --
| > Joseph Bittman
| > Microsoft Certified Solution Developer
| >
| > Web Site: http://71.39.42.23
| > Static IP
| >
| >
| >
| >
| > "David A. Osborn" <do********@hotmail.com> wrote in message
| > news:tT8Ke.235195$x96.189382@attbi_s72...
| >> Currently I have an XML file that come from an external program that
| >> looks something like this:
| >>
| >> <?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
| >> APPVERSION="19">
| >> <FRUITBOWL Name="bowl1" Size="6" >
| >> <FRUIT Type="Apple" Quanity="1" Size="Big"
| >> Brand="Red Del." >
| >> </FRUIT>
| >> <FRUIT Type="Orange" Quanity="2" Size="small"
| >> Brand="none">
| >> </FRUIT>
| >> </FRUIT BOWL>
| >> <FRUITBOWL Name="bowl2" Size="24" >
| >> <FRUIT Type="Apple" Quanity="16" Size="small"
| >> Brand="Other" >
| >> </FRUIT>
| >> <FRUIT Type="Grape" Quanity="2" Size="medium"
| >> Brand="none">
| >> </FRUIT>
| >> </FRUIT BOWL>
| >> </XML_FRUITBOWL_DATA_FILE>
| >>
| >>
| >> At any time the external program could change and a new property could
be
| >> added. What is the best way for me to interact with this file? Can I
| >> read it in as a generic object and access properties with the dot
| >> notation? Or do I need to interact with the file with SQL statement
with
| >> ADO .NET?
| >>
| >>
| >>
| >>
| >>
| >
| >
| >
|
|
|
Nov 21 '05 #4
Hello David,

You can deserialize into an object, assuming that you have a schema for the
file. I wish that the schema editor in Visual Studio was easier to work
with, but it isn't. That said, you can use the XSD tool in the SDK (free
download) to create the schema for you. (see
http://msdn.microsoft.com/library/de...ToolXsdexe.asp )
[watch for wrapping URLs].

Once you have the schema generated from the XSD, load it into your project.
Make sure that the elements are defined as "open" and not closed (I don't
know which is the default for the XSD tool).

Then save your changes and run the updated schema back through the XSD tool
to generate the classes you can deserialize your data into. Now you will be
able to read your data using normal "dot" notation.

HTH,

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"David A. Osborn" <do********@hotmail.com> wrote in message
news:eUcKe.235790$x96.175955@attbi_s72...
What I meant by the file changing was that the the file format may change,
ie another property may be added so I don't want to have to rewrite this
code every time the vendor of the software updates their software. What
would be nice is if I could pull the XML in as an object that
automatically had the properties that were listed in the XML, but I don't
even know if that is possible. I think I am sort of looking for the
opposite of a serialized class, if that makes any sense. Turn the XML
into an object without actually knowing what that object is.
"Joseph Bittman MCSD" <Ry*********@msn.com> wrote in message
news:OM**************@TK2MSFTNGP14.phx.gbl...
August 9, 2005

There are MANY ways you can read that file.... ADO.Net & SQL would be
complicated for such a simple task. Just look into Dataset.ReadXML &
XPathNavigators & XMLDocuments.... easy ways to retrieve data from XML
Files.... if the file changes, I would use a FileMonitor class (I hope
that is the exact name of it... I forget, maybe FileWatcher?) which will
fire an event that you can use to read the new file when it changes... I
hope this helps and have a great day!

--
Joseph Bittman
Microsoft Certified Solution Developer

Web Site: http://71.39.42.23
Static IP


"David A. Osborn" <do********@hotmail.com> wrote in message
news:tT8Ke.235195$x96.189382@attbi_s72...
Currently I have an XML file that come from an external program that
looks something like this:

<?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
APPVERSION="19">
<FRUITBOWL Name="bowl1" Size="6" >
<FRUIT Type="Apple" Quanity="1" Size="Big"
Brand="Red Del." >
</FRUIT>
<FRUIT Type="Orange" Quanity="2" Size="small"
Brand="none">
</FRUIT>
</FRUIT BOWL>
<FRUITBOWL Name="bowl2" Size="24" >
<FRUIT Type="Apple" Quanity="16" Size="small"
Brand="Other" >
</FRUIT>
<FRUIT Type="Grape" Quanity="2" Size="medium"
Brand="none">
</FRUIT>
</FRUIT BOWL>
</XML_FRUITBOWL_DATA_FILE>
At any time the external program could change and a new property could
be added. What is the best way for me to interact with this file? Can
I read it in as a generic object and access properties with the dot
notation? Or do I need to interact with the file with SQL statement
with ADO .NET?




Nov 21 '05 #5
Basically what I need to do is update specific fields in the file. For
example I may need to update the quanity for each fruit in a fruit bowl. If
the external vendor added another property I just need to be ble to retain
it in the XML, either f my output is the same XML file or if I generate a
new XML file. It sounds to me that interfacing with SQL might be the best
solution since I just need to update specific fields. What would the SQL
statement look like to grab the quanity of APPLE in BOWL1?

"" <a@b.com> wrote in message news:Zu****************@fe05.lga...
what's more important at this point is to determine what your application
is
doing with the file...or any new properties. are you just trying to find a
way to better visually display (for readability sake) the xml?
"David A. Osborn" <do********@hotmail.com> wrote in message
news:eUcKe.235790$x96.175955@attbi_s72...
| What I meant by the file changing was that the the file format may
change,
| ie another property may be added so I don't want to have to rewrite this
| code every time the vendor of the software updates their software. What
| would be nice is if I could pull the XML in as an object that
automatically
| had the properties that were listed in the XML, but I don't even know if
| that is possible. I think I am sort of looking for the opposite of a
| serialized class, if that makes any sense. Turn the XML into an object
| without actually knowing what that object is.
|
|
| "Joseph Bittman MCSD" <Ry*********@msn.com> wrote in message
| news:OM**************@TK2MSFTNGP14.phx.gbl...
| > August 9, 2005
| >
| > There are MANY ways you can read that file.... ADO.Net & SQL would be
| > complicated for such a simple task. Just look into Dataset.ReadXML &
| > XPathNavigators & XMLDocuments.... easy ways to retrieve data from XML
| > Files.... if the file changes, I would use a FileMonitor class (I hope
| > that is the exact name of it... I forget, maybe FileWatcher?) which
will
| > fire an event that you can use to read the new file when it changes...
I
| > hope this helps and have a great day!
| >
| > --
| > Joseph Bittman
| > Microsoft Certified Solution Developer
| >
| > Web Site: http://71.39.42.23
| > Static IP
| >
| >
| >
| >
| > "David A. Osborn" <do********@hotmail.com> wrote in message
| > news:tT8Ke.235195$x96.189382@attbi_s72...
| >> Currently I have an XML file that come from an external program that
| >> looks something like this:
| >>
| >> <?xml version="1.0" ?><XML_FRUITBOWL_DATA_FILE FILEVERSION="1"
| >> APPVERSION="19">
| >> <FRUITBOWL Name="bowl1" Size="6" >
| >> <FRUIT Type="Apple" Quanity="1" Size="Big"
| >> Brand="Red Del." >
| >> </FRUIT>
| >> <FRUIT Type="Orange" Quanity="2" Size="small"
| >> Brand="none">
| >> </FRUIT>
| >> </FRUIT BOWL>
| >> <FRUITBOWL Name="bowl2" Size="24" >
| >> <FRUIT Type="Apple" Quanity="16"
Size="small"
| >> Brand="Other" >
| >> </FRUIT>
| >> <FRUIT Type="Grape" Quanity="2" Size="medium"
| >> Brand="none">
| >> </FRUIT>
| >> </FRUIT BOWL>
| >> </XML_FRUITBOWL_DATA_FILE>
| >>
| >>
| >> At any time the external program could change and a new property
could
be
| >> added. What is the best way for me to interact with this file? Can
I
| >> read it in as a generic object and access properties with the dot
| >> notation? Or do I need to interact with the file with SQL statement
with
| >> ADO .NET?
| >>
| >>
| >>
| >>
| >>
| >
| >
| >
|
|
|


Nov 21 '05 #6

learn something new every day...that could come in pretty handy!

thx nick.
Nov 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: William C. White | last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using cURL? Our website is hosted on a shared drive and the webhost company doesn't installed additional software (such as cURL)...
2
by: Albert Ahtenberg | last post by:
Hello, I don't know if it is only me but I was sure that header("Location:url") redirects the browser instantly to URL, or at least stops the execution of the code. But appearantely it continues...
3
by: James | last post by:
Hi, I have a form with 2 fields. 'A' 'B' The user completes one of the fields and the form is submitted. On the results page I want to run a query, but this will change subject to which...
0
by: Ollivier Robert | last post by:
Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get a SEGV from inside the libcnltsh.so library. ...
1
by: Richard Galli | last post by:
I want viewers to compare state laws on a single subject. Imagine a three-column table with a drop-down box on the top. A viewer selects a state from the list, and that state's text fills the...
4
by: Albert Ahtenberg | last post by:
Hello, I have two questions. 1. When the user presses the back button and returns to a form he filled the form is reseted. How do I leave there the values he inserted? 2. When the...
1
by: inderjit S Gabrie | last post by:
Hi all Here is the scenerio ...is it possibly to do this... i am getting valid course dates output on to a web which i have designed ....all is okay so far , look at the following web url ...
2
by: Jack | last post by:
Hi All, What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g. select x from y where z=:parameter Which in asp/jsp would be followed by some statements to bind a value...
3
by: Sandwick | last post by:
I am trying to change the size of a drawing so they are all 3x3. the script below is what i was trying to use to cut it in half ... I get errors. I can display the normal picture but not the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.