How to filter a dataset using relationships?   

Hi,

I have a dataset that contains 3 related table such as the famous customers 
| orders | order details scenario.  I need some logic or way so when I filter 
the customers table on a specific customer id, the filter is cascaded down to 
the children tables through the relationships and a new dataset with the 
filtered data returned to me.  

I looked into DataViewManager and that required me to specify a filter per 
table where I only want to filter the customers table and have the rest of 
the tables filtered automatically.

The other way I thought about is to clone the dataset, filter the customer 
table, import he rows into the new dataset’s customers table then use the 
GetChildRows, import the rows into the appropriate table and so forth. 

There must be an easier was to achieve this.  Please let me know if you have 
any ideas.

Thanks,
Danny

date: Fri, 24 Feb 2006 15:03:26 -0800   author:   Danny Mansour

Re: How to filter a dataset using relationships?   

You may want to try GridView and DetailsView Controls

Roshan

date: 25 Feb 2006 20:41:53 -0800   author:   unknown

Re: How to filter a dataset using relationships?   

Hi Roshan,

Thanks for taking the time to reply.

Yes, it would be simple to have a child and master GridViews where the 
DataMember set to the relationship, but I working with a console application 
and I was hoping to be able to get a filtered the dataset rather than looping 
through each row and find its children.  

Please let me know if you think of other solutions.

Thanks,
Danny  


"roshu74@yahoo.com" wrote:

> You may want to try GridView and DetailsView Controls
> 
> Roshan
> 
>

date: Mon, 27 Feb 2006 07:31:28 -0800   author:   Danny Mansour