Re: How to Perform SQL Select on a DataSet

From: Val Mazur \(MVP\) (group51a_at_hotmail.com)
Date: 03/16/05 

Date: Tue, 15 Mar 2005 20:59:42 -0500

Hi,

Check my next KB. It could help. You could use XSL to transform XML into
what you need

http://support.microsoft.com/default.aspx?scid=kb;en-us;555267 

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
<webbertsolutions@newsgroups.nospam> wrote in message 
news:i8od311nlu6u5rpqonle802ico72o8ke0m@4ax.com...
>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

  • Re: How to Perform SQL Select on a DataSet
    ... "Val Mazur " wrote in message ... You could use XSL to transform XML into ... > Microsoft MVP ... >> I have re-created the database tables necessary into XML files and store ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Error ( think)
    ... > Server database, once I have created the connection to the database I say ... > "Val Mazur" wrote in message ... >>> Response.Write filepath ...
    (microsoft.public.data.ado)
  • Re: How to query SQL Db and write results into Access
    ... > "Val Mazur" wrote in message ... >> datasource (database) to another one. ... >>>I am trying to query an SQL db and store the results of the query into ... >>> access database or what other approach should I be taking to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Php5 - xsl extension not working
    ... I have enabled the xsl extension - php_xsl.dll - in php.ini and indeed, when I look at phpinfo I see all the needed libraries are enabled. ... In most projects, I'd say the conversion database -> XML -> HTML would be an unnecessary step, and database -> HTML is just a lot less overhead. ...
    (comp.lang.php)
  • Re: [PHP] Re: About PHP/XML/XSLT/MYSQL Web Sites
    ... processed in an XSL transformation, it is a waste of time converting user ... input into XML before it is added to the database as none of the ... SELECT/INSERT/UPDATE/DELETE commands can work with XML files. ...
    (php.general)