473,395 Members | 1,996 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,395 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 2095
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.