Hello everybody, Thanks for taking the time to read this. How is it possible to set the Where property of a LinqDataSource to include a subquery? If i use this line of code: Code Snippet ldsTasks.Where = "DeptID IN (SELECT DeptID FROM PersonDepts)" ASP.NET returns: Expression of type 'Boolean' expected If I test this line of code: Code Snippet l dsTasks.Where = "addedby=" & id & " or deptid in (select deptid from persondepts where personid=" & id & ")" ASP.NET returns: Operator 'or' incompatible
Read More...