Create Recordset from a non standard data source

19 Jul 2006 1:52 PM

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

19 Jul 2006 2:03 PM

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" <M***@melted-Cpu-co.uk> a écrit dans le message de news:

OJqb2mzqGHA.4***@TK2MSFTNGP04.phx.gbl...
Show quoteHide quote

> 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
>

19 Jul 2006 5:18 PM

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

Show quoteHide quote

"Patrice" <scr***@chez.com> schreef in bericht
news:eQGmbwzqGHA.148@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" <M***@melted-Cpu-co.uk> a écrit dans le message de news:
> OJqb2mzqGHA.4***@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
>>
>
>