How do I query a dataset?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: 2 (2_at_2.2)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 19:32:46 +1100

Hello,

I get how to populate a dataset by querying a database server... but once
I've populated my dataset, say with several related tables, how can I then
select records from the dataset copy of data using SQL statements instead of
the database server itself?

In some cases I'd say this is preferable to hitting the database server
everytime a subset of data needs to be retrieved. Only suitable for small
amounts of static data of course.

As an example if I have a populated table of employee data in a dataset and
I want to populate a temp table with only those records where employee age >
60..... am I limited to filters or can I use SQL statements (which would
then mean no extra code if I decided to point back at the database server
instead of the dataset itself)....?

Hope this makes sense to you guys... cheers

Relevant Pages

  • Re: Populating a FormView from different data
    ... database server). ... Do you mean populate for example a DropDownList? ... and then insert those values into datasource1? ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Would replication work here?
    ... I have two databases on the same server. ... I want to populate and keep ... synchronized a table on database 2 from a view on database 1. ... just need an answer to the underlying problem, ...
    (microsoft.public.sqlserver)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)