Search Directory of XML files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All

I have a directory of approximately 300 xml files that contain items and
sales data and I want to search all of the files and read the item and sales
elements from the files to aggregate together.

Can anyone advise the best way to read the data from the xml files and store
it somewhere to use later, maybe SQL Server?

Thanks for any assistance that can be provided.
 
All

I have a directory of approximately 300 xml files that contain items and
sales data and I want to search all of the files and read the item and sales
elements from the files to aggregate together.

Can anyone advise the best way to read the data from the xml files and store
it somewhere to use later, maybe SQL Server?

Thanks for any assistance that can be provided.
Click to expand...

I would use the Dir function to lookup the list of filenames, and
then use the XML DOM to parse the data in the XML files.
 
Joe Cool said:
I have a directory of approximately 300 xml files that contain items and
sales data and I want to search all of the files and read the item and
sales
elements from the files to aggregate together.
Click to expand...
[...]
I would use the Dir function to lookup the list of filenames
Click to expand...

I think that using 'System.IO.Directory.GetFiles' is more comfortable than
using 'Dir'.
 
Back
Top