Great! This is *exactly* what I've been looking for: a single line filter that will fit into the DataViewManager's RowFilter property. I'm going to give it a try....
Thanks ! Lidor Wyssocky Software Infrastructure and Tools NDS Technologies Israel E-Mail: [EMAIL PROTECTED] Phone: 972-2-589-4801 Fax: 972-2-589-4900 -----Original Message----- From: Philip Nelson [mailto:[EMAIL PROTECTED]] Sent: Tue, June 25, 2002 00:56 To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] Filtering Data in Complex DataSets --- "Wyssocky, Lidor" <[EMAIL PROTECTED]> wrote: > Thanks for the fast response but I have one comment about this scheme: > > I don't think it is worth all the trouble of writing those classes Did the solution offered earlier fit your needs? The sort of equivalent to a sql join is to filter on a relationship. ex: aView.RowFilter = "Child(yourRelationshipName).YourChildField = theFieldYouWant"; (didn't actually try this one and mine had a SUM in front of it) __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.