Hi, I encountered the following problem when trying to present a DataSet in GridView control:
My DataSet contains several tables with relationships between them. For example, Table Students contains a link to Table Countries. Now, I want to filter students by the country value. I tries to use the DataView and the DataViewManager class, but all I could find is the RowFilter property. As far as I understand, this property can't be used to filter a field which is in fact a relationship to another table (or at least I don't know how to do so). I should also note that I'm note working with a physical data base, so I can't create an SQL query that will populate the dataset with the filtered data. I want the dataset to contain the complete data, and use a filter only on the view level. Does anyone knows how can I create such a filter with one of these classes, or in another way? Thanks, Lidor Lidor Wyssocky Software Infrastructure and Tools NDS Technologies Israel E-Mail: [EMAIL PROTECTED] Phone: 972-2-589-4801 Fax: 972-2-589-4900 You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.