Create Recordset from a non standard data source

[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

[Patrice]

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

"Mike Spike" <Mi**@melted-Cpu-co.uka écrit dans le message de news:
OJ**************@TK2MSFTNGP04.phx.gbl...

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

[Cor Ligthert [MVP]]

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

"Patrice" <sc****@chez.comschreef in bericht
news:eQ*************@TK2MSFTNGP04.phx.gbl...

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

"Mike Spike" <Mi**@melted-Cpu-co.uka écrit dans le message de news:
OJ**************@TK2MSFTNGP04.phx.gbl...

>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