RE: How to Query Offline in ADO.NET

From: Ben (Ben_at_discussions.microsoft.com)
Date: 09/28/04

  • Next message: Toco: "ADO Function Needed" 
    Date: Tue, 28 Sep 2004 13:09:02 -0700

    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

  • Next message: Toco: "ADO Function Needed"

    Relevant Pages

    • Re: SQL Query or View Object
      ... > If I want to get a set of records from Database in readonly mode (Ex. ... > 1) Use of SQL Statement in ADO Objects in READONLY Mode from The ... > 2) Create a VIEW in Database Server for that SQL Query and Use that Query ...
      (microsoft.public.sqlserver.programming)
    • Re: SqlAdapter and multiple BizTalk Servers
      ... The SQL Adapter executes all it's sql statements with a SQL transaction ... >> with Multiple Host Instances of the same BizTalk host? ...
      (microsoft.public.biztalk.general)
    • Re: Using OpenXML statement in SQL Adapter
      ... watch the string value in The SQL SP. ... problems getting the string assigned to the XML tag. ... to the SQL Adapter, but when I compile I am getting an error stating that I ...
      (microsoft.public.biztalk.general)
    • Re: SQL Adapter stops polling
      ... On a system with 4 SQL Receive locations I have begun to notice the same ... We are in the process of testing a hot fix from Microsoft to correct the ... My hunch is that either there is a problem with thread deadlocks inside ... SQL Adapter itself, or other adapters are behaving badly by not releasing ...
      (microsoft.public.biztalk.general)
    • Re: sql server 2000 to/from biztalk 2004
      ... The SQL adapter is fully transactional. ... DB and its placement into the BizTalk Message Box is typically covered by ... as the end point manager will commit the transaction and ...
      (microsoft.public.biztalk.general)