locked
filter related tables RRS feed

  • Question

  • Hi all,

     I have a domaindatasource pulling in information from a database using Linq2SQL at the back end.  The query I am using is pulling in data from related tables, and this works fine.  I am able to filter on the main table without much difficulty, but I want to put a filter to allow filtering of the sub tables.  How would I do this?

     Thanks

     

    Thursday, December 17, 2009 6:39 AM

Answers

  • Hi Min-Hong,

     I tried what you said, but that was filtering the entire dataset based on the querying of the related table. 

     I got it to work in the end, but using the collectionviewsource and filtering.  worked just as well, but meant I ahd to do the datafiltering on the XAML code behind.

     

    Thanks again.

    Monday, January 4, 2010 10:46 AM

All replies

  • Hi,

      You can check there to see how to filter related data in LinqToSql

       http://msdn.microsoft.com/en-us/library/bb882678.aspx

    Best Regards

    Monday, December 21, 2009 2:22 AM
  • Hi Min-Hong,

     I tried what you said, but that was filtering the entire dataset based on the querying of the related table. 

     I got it to work in the end, but using the collectionviewsource and filtering.  worked just as well, but meant I ahd to do the datafiltering on the XAML code behind.

     

    Thanks again.

    Monday, January 4, 2010 10:46 AM