custom filtering with objectdatasource in .NET 4.0

3 posts, 0 answers
  1. Datamex
    Datamex avatar
    161 posts
    Member since:
    Jun 2012

    Posted 17 May 2011 Link to this post

    Hi,

    I want to implement custom filtering in my radGrid, but I don't get it to work right now. What I'm trying to do is the following:

    I have radGrid and the datasource of the grid is an objectdatasource. In the selecting event of the objectdatasource i add my filterexpression and sortexpression. In the function in my businesslogics, i have the filterexpression, sortexpression, startindex and maximumrows. The filterexpression is coming to the function properly, but i can't get it to work with my entitymodel. I've tried enableLinqExpression="True" and enableLinqExpression="False" but with both options it doesn't work.This is the code of the function:

     

     

    public static IQueryable<vw_TrainingCompanyLocations> GetTrainingCompanyLocations(string filterExpression, string sortExpression, int maximumRows, int startRowIndex)
        {
          KolipeEntities db = new KolipeEntities();
      
          IQueryable<vw_TrainingCompanyLocations> data;
      
          if (!string.IsNullOrEmpty(filterExpression))
            data = db.vw_TrainingCompanyLocations.Where(filterExpression);
          else
            data = db.vw_TrainingCompanyLocations;
      
          return data;
        }
     

     Do you have any idea how to get this to work?

  2. Ben
    Ben avatar
    3 posts
    Member since:
    Feb 2011

    Posted 17 May 2011 Link to this post

    I have the same issue.

    It seems that 'EnableLinqExpressions' doesn't work right with ObjectDataSource objects.  When I get a filter expression, it's always in SQL format regardless of that property being set to 'true' or 'false'.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Tsvetina
    Admin
    Tsvetina avatar
    1876 posts

    Posted 20 May 2011 Link to this post

    Hello Datamex,

    You can take a look at the project attached to the following forum post, which demonstrates how to achieve the desired functionality. I hope it helps.
    Filtering with linq through an ObjectDataSource

    Greetings,
    Tsvetina
    the Telerik team

    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Back to Top