dynamic data to class. Best way to accomplish this...

suppose I have a function that aggregrates data from different sources (Mostly SQL sources), and then suppose I have a class (DLL or in another way) that exports this data.

Now,
I do not know the extend of the aggregrated data...it could contain financial fields, or quotation fields, or other type of data...
therefor I do not know beforehand how large and what type (what fields) I need to pass to my Class...

How can I set this up that the Class will accept the data in some sort of structure of collection so I can process that data. I usually need the fieldname/Value pair for processing in the class. Do I use collections? Or structures? But can these structures be build dynamic so it will accomendate for the differente types of fields/data...

simply put, How Can I build a generic data harvester/exporter?
LVL 1
EnolaKotrotsosAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
inthedarkConnect With a Mentor Commented:
Have you thought of using a disconnect ADO recordset?  All the code is there to convert to string and back.  Would you like a code sample?
0
 
EnolaKotrotsosAuthor Commented:
Yes, that would be terrific...And I think that will work....
0
 
inthedarkCommented:
I built a magic collection class that dynamically creates fields and sub instances of itself it works a bit like a handbag.  I use it as a common data transport between classes.  It saves having to define a UDT or class for every little thing.

I use arrays instead of collections as they are faster.  But I created a version that uses collections and posted some sample code here.

zMagicClass coe is here:
http://www.experts-exchange.com/Databases/MS_Access/Q_20403690.html


0
 
inthedarkCommented:
Disconnected recordset example:

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20638939.html?query=disconnected+recordset+ford+bbc&searchType=all

You can save the data in the set using the RS.Save method.  And you can reopen the data using a simple RS.Open "C:\MyFolder\MyFile.xxx"
0
 
EnolaKotrotsosAuthor Commented:
fantastic, thanks a million...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.