Search Directory of XML files

[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.

 

[Joe Cool]

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.

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.

 

[Herfried K. Wagner [MVP]]

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.

[...]
I would use the Dir function to lookup the list of filenames

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