How to enable filtering on an ObjectDataSource with FilterExpression when bound to a List

Question

Does anyone know how to use FilterExpression with an ObjectDataSource when it is bound using a select method that returns a list of entity objects?

I get the following error when I attempt it:

"The data source 'testODS' only supports filtering when the SelectMethod returns a DataSet or a DataTable"

sorry, the question title says "sorting" but I actually meant filtering. — user479843, Nov 29 '10 at 23:12

score 1 · Answer 1 · answered Nov 29 '10 at 23:25

According to MSDN

The ObjectDataSource control supports filtering data only when the Select method returns a DataSet or DataTable object.

So if you want to filter your result set of entities, perhaps you can use a LinqDataSource instead.

<asp:LinqDataSource ID="LinqDataSource1" runat="server" 
    ContextTypeName="MyNamespace.MyDataContext" 

        Select="new (MyId, MyProperty1, MyCollection1.MyProperty2)" 
        TableName="MyTable" Where="MyProperty1.Contains(@PropertyFilter)" >
        <WhereParameters>
            <asp:ControlParameter ControlID="txtPropertyFilter" Name="PropertyFilter" 
                PropertyName="Text" Type="String" />
        </WhereParameters>
</asp:LinqDataSource>

score 1 · Answer 2 · edited May 23 '17 at 10:33

1

Why not just do what the error says and use a DataTable or DataSet?

Convert generic list to dataset in C#

edited May 23 '17 at 10:33

Community

1
1

answered Nov 29 '10 at 23:32

jdmichal

10,984
4
43
42

Yeah, only problem is that that section of the code has already been written and won't be able to change it.. ok, i'll try another way. thanks everyone! – user479843 Nov 30 '10 at 14:51

score 0 · Answer 3 · answered Jan 29 '13 at 16:03

Use a select parameter for the ODS to hold the filter variable.

    <asp:ObjectDataSource ID="odsResults" runat="server" 
        OldValuesParameterFormatString="original_{0}" SelectMethod="GetSearchResults" 
        TypeName="LiftSearchResults" SortParameterName="sortType">
        <SelectParameters>
            <asp:Parameter Name="liftID" Type="Int32" />
            <asp:Parameter Name="sortType" Type="String" />
            <asp:Parameter Name="range" Type="Int32" />
        </SelectParameters>
    </asp:ObjectDataSource>

Data object method:

[DataObjectMethod(DataObjectMethodType.Select, false)]
    public List<SearchResultsLift>
        GetSearchResults(
        int liftID,
        string sortType,
        int range
        )
    {        
    List<SearchResultsLift> returnList =
        new List<SearchResultsLift>();

        ...Code to populate list...

        if (range != 0)
        returnList = FilterByRange(returnList, range);

        returnList = GetListSort(returnList, sortType);
    return returnList;
}

Unless the range parameter is explicitly set in the page it returns 0 and all records are returned. GetListSort (not shown) is a sort function.

private List<SearchResultsLift>
    FilterByRange(List<SearchResultsLift> filterList, int range)
{
    var fList = (from srl in filterList
                 where 
                 srl.DistanceFromDestination <= range &&
                 srl.DistanceFromStart <= range
                 select srl).ToList<SearchResultsLift>();
        return fList;
}
}

3 Answers3