Re: How to Perform SQL Select on a DataSet
From: Sahil Malik (contactmethrumyblog_at_nospam.com)
Date: 03/15/05
- Next message: nashak_at_hotmail.com: "What am I doing wrong here?"
- Previous message: 11Oppidan: "Re: Combining multiple datatables on a unique ID"
- In reply to: webbertsolutions_at_newsgroups.nospam: "How to Perform SQL Select on a DataSet"
- Next in thread: Val Mazur \(MVP\): "Re: How to Perform SQL Select on a DataSet"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Mar 2005 11:04:53 -0500
The closest similie to a Select on a dataset is to use a combination of
DataTable.Select/ DataRowsCollection.Find/
DataView.Find/DataView.FindRows/DataRelation.GetParentRow/
DataRelation.GetChildRows.
There is no way to do a direct select. You can however do xpath if you
really wanna go nuts.
- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
<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
>
- Next message: nashak_at_hotmail.com: "What am I doing wrong here?"
- Previous message: 11Oppidan: "Re: Combining multiple datatables on a unique ID"
- In reply to: webbertsolutions_at_newsgroups.nospam: "How to Perform SQL Select on a DataSet"
- Next in thread: Val Mazur \(MVP\): "Re: How to Perform SQL Select on a DataSet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
