DevExpress AspxGridView filter in ObjectDataSource

asp.netaspxgridviewdevexpressfilteringobjectdatasource

Yet another problem with DevExpress AspxGridView 🙂

The context:

One Page
In the Page, a custom control
In the custom Control, a AspxDropDown
The AspxDropDown has a DropDownWindowTemplate
In the DropDownItemTemplate, I add a GridView and a paging/sorting/filtering enabled ObjectDataSource
When handling the selecting event of the ObjectDataSource, I should set filter parameters for the datasource. There filter parameters should come from the FilterRow of the AspxGridView (preferably using the AspxGridView.FilterExpression property).

The problem: the AspxGridView.FilterExpression property is not set to the proper values (set by the user).

Did anyone find a good implementation of what I'm trying to do here?

Thanks a bunch.

🙂

Best Answer

I've finally managed to get around the problem.

Not a good solution, but, still, a way to work around it.

So.. The "solution" is to databind the grid on every AfterPerformCallback event.

void grid_AfterPerformCallback(object sender, ASPxGridViewAfterPerformCallbackEventArgs e)
    {
        ((DevExpress.Web.ASPxGridView.ASPxGridView)sender).DataBind();
    }

As I've said, it's not a good solution.

Related Solutions

Objectdatasource and Gridview : Sorting, paging, filtering

It may no longer be of interest for you, but I thought I post an answer nevertheless:

I am using Linq2Sql and a ObjectDataSource and it does Paging and Sorting very well.

I implemented a Class to be used as the ObjectDataSource. It has a Select and a Count method calling my business layer which uses Linq2SQL queries to retrieve data from the DB, should be similar with the EntityFramework. The select methods gets the first item index, page size and the sort expression as parameters automatically.

public List<EntityClass> Select(int startIndex, int pageSize, string sortBy) {}
public int Count() {}

In the ASPX, the DataSource is configured like this:

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"  
     SelectMethod="Select" EnablePaging="true"
     StartRowIndexParameterName="startIndex" 
     MaximumRowsParameterName="pageSize"
     SortParameterName="sortBy" SelectCountMethod="Count" >   
</asp:ObjectDataSource>

The Select and the Count method use Linq queries to retrieve the data from the DB. I use the Skip(), Take() and Orderby() methods. For the OrderBy to accept a string sort expression I use DynamicLinq There is not much to code, Databinding, paging and Sorting are automatically working.

If you are interested I could post more details of my code.

AspxGridView paging problem

Please take a look at the following article. It explains why this problem appears and how to fix it:

Why might paging (sorting, grouping, filtering) not work in the ASPxGridView?

Best Answer

Related Solutions

Objectdatasource and Gridview : Sorting, paging, filtering

AspxGridView paging problem

Related Topic