How to Perform SQL Select on a DataSet

webbertsolutions_at_newsgroups.nospam
Date: 03/15/05 

Date: Tue, 15 Mar 2005 08:27:51 -0500

I am in the process of making a desktop version of an enterprise product.
In doing so, there a many options that are stored in different tables in
a database. These values are different depending on the installation.
I have re-created the database tables necessary into XML files and store
them on disk.

I would like to take advantage of the current code that I have. Currently,
I perform select statements on the database to return a dataset.

I would like to perform the same select statement on the DataSet in order
to return the "same data" to the upper layers.

For instance, if I had 3 database tables (now DataTables in a DataSet)

+------+ +------+ +------+
| Cust | | Addr | | Ordr |
+------+ +------+ +------+
| cid | | aid | | oid |
| name | | cid | | cid |
| | | city | | qty |
+------+ +------+ +------+

I would like to perform the following select

    select cust.name, addr.city, ordr.oid, ordr.qty
    from
       cust, addr, ordr
    where
       cust.cid = addr.cid,
       cust.cid = order.cid
    order by
       cust.name,
       ordr.oid

The amount of data in the dataset will be reasonably small since it is
configuration data.
 
Is there an easy way to query the DataSet Tables to produce a DataSet that
is equivalent to the DataSet when querying a database.

Thanks,
Dave

Relevant Pages

  • Mailbox store dismounted automatically
    ... Both of Exchange mailbox stores dismounted automatically, ... Database error 0xfffffd9a occurred in function JTAB_BASE::EcUpdate while ... Component: Information Store ... A critical input/output error or disk error has occurred. ...
    (microsoft.public.exchange.admin)
  • Re: Database Recoverable to Disk White Space Not Available As Expe
    ... The reasons we wish to reduce the logical and physical space on disk are ... Store is currently around 84 GB. ... We have 1270 mailboxes and only a single Exchange admin. ... As for the actual database, only pointers were removed from a and b. ...
    (microsoft.public.exchange.admin)
  • Re: Which service to use
    ... not allowed to store these values on disk or Database. ... Protocol aint too much of an issue. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: STORE;ONLINE
    ... If the database is not locked totaly but only the database files that he/she uses one by one you may backup partial transactions. ... Now a user is adding a new person while the store runs ... The address is writen to disk at store time ...
    (comp.sys.hp.mpe)
  • Re: Mailbox store dismounted automatically
    ... You say that obviously you think there are no disk issues, ... > Database error 0xfffffd9a occurred in function JTAB_BASE::EcUpdate while ... > Component: Information Store ... contact Microsoft Product Support Services. ...
    (microsoft.public.exchange.admin)