How to create a DataView that is a sunset of a dataset

[Jinsong Liu]

Hi Group:

I have a DataSet with three tables. How can I create a DataView which
will only contain first two tables?

Thanks

 

[Guest]

Under 1.x, DataViews are tied to a particular table. This means you can
combine them in one of two ways:

1. Database, add a table that has the combined "view" you want in the
original fill of the DataSet.

2. Programatically walk through and create a new table.

DataViews are not like database views. They are great for sorting and
filtering, but you cannot consolidate DataTables.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Jinsong Liu]

Thanks for the answer. What I want is a subset of a Dataset. I am
currently creating new Dataset which contains only tables I want (by
copying tables from the existing Dataset) in my code. It works, Just
want to see if there is an easer way. Since copy data table is really
not a good idea to me.

 

[David Jessee]

the closest thing you could to would be to create 2 dataviews from that
dataset.
I guess you could place those 2 dataviews in a hashtable. that way you
could bass them as a single reference.