Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Processing XML Files

I am developing a C# application that monitors a directory on a server for XML files.  These XML files are written to this directory through a separate application.  What my application needs to do is grab the XML file, parse it, insert the data into a database, and remove the file to separate location.  I am using the file system watcher class for listening to the files.  My question is what is the best way to read these XML files?  Should I read them into a dataset or is there another efficient way of doing it?   I am a novice .NET developer so any help will be appreciated.

Thanks
0
fifo123
Asked:
fifo123
1 Solution
 
Bob LearnedCommented:
Is the XML file structure simple?  Are they small, medium or large files?  If so, then using the DataSet.ReadXML is a very straight forward approach.

Bob
0
 
ptmcompCommented:
Well, it depends how they should be stored in the database. If they are stored as text then it would be enough to just load them as text. Validating them whould be good to avoid garbage being written to the database... That can be done using an XmlValidatingReader and listening to the events.
XmlDocument would be easier and straight forward but it has more overhead. If there are few small files this is not relevant but if they are big you the way described before might be better...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now