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 10:27:01 -0700

The DataSet contains 0-N DataTable objects which contain 0-N Rows. It's
these rows that you can walk through. There is no "query" engine in ADO so
you can't do a "SELECT" on the data, but there are ways to find data in the
DataTables. What research have you done so far? What have you tried? 

-- 
____________________________________
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:44BFF227-69D7-4162-B4A2-0421D32DF405@microsoft.com...
> 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: Best practices
    ... A Dataset is simply a collection of DataTable objects. ... you can load up a custom array with rows from a query but this means writing a lot more code that you have to support. ... "Willian Lopes" wrote in message ... I read a lof ot tutorials but each of show a differente manner and opinion. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: cant get query to run over ADO, but works fine in Access inte
    ... Thanks for the suggestions, Richard. ... the query so that unchanging parts of it are stored as a query with the part ... As I've had trouble with synchronizing ADO ... > Execute method of the ADO Connection object, but the issue is the same - you ...
    (microsoft.public.data.ado)