This is getting interesting. Let me explain what I'm trying to accomplish
and maybe you guys can provide your ideas. I'm trying to pull out data from
a 3rd party application which provides an API. The primary communcation
with the API are with XML messages. What I'm trying to do is query the 3rd
party database via the API where I get XML response messages. I pull out
the pertinent data from the XML file(s) and store it in memory. I have 5 or
6 memory tables which I need to perform some cross referencing to get to the
data that I actually need. I then take the aggregated data and build an
Excel spreadsheet to persist the data there.
I would be interested to know how someone else would handle this situation.
So basically I have XML files that contain 100 to 200,000 rows of
information. Walking through each XML file do I store the data in an
ArrayList or DataTable? I don't have to update the DataTable/ArrayList. I
just have to search through it to pull out and run some calculations from
each list.
-StinkyDuck
"StinkyDuck" <st********@gmail.comwrote in message
news:O$****************@TK2MSFTNGP03.phx.gbl...
I'm trying to determine which type of collection to use, DataTable or
ArrayList. I understand that an ArrayList can be linked to databound
objects if it contains the IList interface.
Is there a recommendation to use one over the other. If you are not going
to bind the collection to any objects should an ArrayList be used? Is
there a benefit on size? If I have a 200,000 rows of data, should a
DataTable be used in this case?
Any information or experiences would be greatful.
-StinkyDuck