By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,417 Members | 1,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,417 IT Pros & Developers. It's quick & easy.

Search Directory of XML files

P: n/a
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.

Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 7 Jun 2005 04:48:05 -0700, "David"
<Da***@discussions.microsoft.com> wrote:
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.

Nov 21 '05 #2

P: n/a
"Joe Cool" <jo*****@home.net> schrieb:
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'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.