By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Create Recordset from a non standard data source

P: n/a
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
Jul 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 19 '06 #2

P: n/a
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


Jul 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.