Multiple XML files into a DataSet?

Mothra

Mothra

Well-known member
Joined
Nov 26, 2002
Messages
173
Location
Fresno, California
Is it possible to read mutiple xml files into a dataset. This would only be used for generating a report. This would be in lieu of using a database. Im trying to have the program (which is used by several users on a network) save (what would be) records as seperate .xml files stored to a central directory. I do need to generate reports based on the data in the files. Ideally, Id like to give the files a new extension (like .mts instead of .xml) so they would be associated with the program alone. Should I even bother with this or would it actully be worth the while?
 
One solution I can think of would be read each XML file into its
own DataSet, then add each individual DataSets tables to
a "main" DataSet, then report that main DataSet.

This will only work (I think) if the tables all have different names.
 
Idea...

(I have no idea if this will work or not, dont have the gumption to fire up my laptop to try it. Itll have to wait till I get to work tomorrow...)

I was thinking of setting up a loop and just reading them into the dataset, one after the other. I was looking through the MSDN and, without going to deep, I got the impression that this particular method may work. Ill also try the seperate datasets, thanks for the input Bucky.
 
Back
Top