Simple ADO tasks

[Not Me]

Hi there,

If someone could just run me through the tasks involved in this simple
example I would be grateful. (using asp.net 2.0 and vb.net, sql server
2000 database)

I start with an xml string, which I load into a dataset as a single
table. This is a single column of unique id's. So far so good

Now, I want to load an a full table into another (or the same?)
dataset.. but limit the results to those keys held within my first
table. Is it possible to do this as a query, or would I have to somehow
use a mapping between the datasets/tables? If so how is this acheived?

Cheers for any pointers or examples,
Chris

 

[William \(Bill\) Vaughn]

Consider that ADO.NET does not have a query engine. It's simply a mechanism
used to store, filter, sort, locate rows and update DataTables. I expect
that you might be better served (so to speak) by using a query engine on the
client. Might I suggest SQL Server 2005 Compact Edition? It includes an
SQL-driven query processor. I've written an EBook on the subject...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Not Me]

Consider that ADO.NET does not have a query engine. It's simply a mechanism
used to store, filter, sort, locate rows and update DataTables. I expect
that you might be better served (so to speak) by using a query engine on the
client. Might I suggest SQL Server 2005 Compact Edition? It includes an
SQL-driven query processor. I've written an EBook on the subject...

Thanks for your insight, much appreciated.

cheers,
Chris