Create Recordset from a non standard data source

  • Thread starter Thread starter Mike Spike
  • Start date Start date
M

Mike Spike

Hi,

How do you create a recordset from an array or collection?

What I mean is, if I have some data like an array or a collection can I make
that the source of a record set and then use SQL commands to manipulate it
without using a database XML file or webservice.

Regards,

Mike
 
Not yet (this will be likely in the next release, see LINQ).

For now :
- you can databind an array and others collections to controls
- you could create an in memory DataTable and work on this (though you won't
have SQL capabilities but I suppose you don't have an expensive set of data
?)
- you could use a lightweight db
- you likely have thrid party products able to do that (but IMO doesn't
change much from above)
- from where are loaded your data ? (you could access the files through a
driver allowing to perform perhaps the most basic statements)
etc...
 
Patrice,

There is in my opinion asked a Recordset, which is in my opinion an Ado
part.

Why are you than giving an DataTable (ADONET) solution?

Cor
 
Back
Top