Re: Simple ADO tasks by William
William
Thu Jan 25 12:03:07 CST 2007
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" <user@domain.invalid> wrote in message
news:1169720852.146088@ucsnew2.ncl.ac.uk...
> 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