Re: How to Query Offline in ADO.NET

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 14:26:13 -0700

Being able to "select" rows from an ADO.NET table would mean including a
query engine which ADO.NET does not have. Let me know if you find one. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
"Ben" <Ben@discussions.microsoft.com> wrote in message 
news:90F2FF29-DC29-4AB1-B16B-D92980CCCFF5@microsoft.com...
>I use DataSets all the time with the 0 - N tables.  I am just a lot better
> with SQL and prefer that method.  I also don't want to get sloppy and hit 
> the
> database a million times.  I hate looping through rows to find data.
>
> I have looked at some ADO.NET books and didn't see anything in there to
> allow the SQL queries on ADO objects.  I was hoping for some good referals 
> to
> some classes I could download.
>
> "Ben" wrote:
>
>> This is an easy one.  I cannot find an object that lets you query it off
>> line.  Does one exist in ADO.NET?
>>
>> For example,
>> I fill a DataSet with a sql adapter.  I don't want to look at it line by
>> line.
>>
>> How do you query DataSets in ADO.NET?
>> Is there another object I can query?
>>
>> Thanks,
>> Ben

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)