referring to an Adapter like a table or query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Microsoft Access, it is possible to create a query and then refer to it
inside another query... how would I do this in ADO.NET?

I'd like to create a simple select query and call it something like:

qMemberSelect

then refer to qMemberSelect as though it were a table
inside another query called qMemberCleanResults
and have that be my DataSet... dsMemberResults

is that possible, if so how would I go about it?
 
Do you mean like a view?

The OleDBAdapter type classes, are just there to talk to the database - they
are not data, nor do they hold any data.

In any case, ADO.NET is not anything at all like a database engine. It's
about providing access to a database, and holding result sets in memory. But
that is all, it doesn't do joins, queries, etc. It does have some very basic
data manipulation capabilities, but it doesn't resemble a database.
 
Back
Top