Filter should get new records from database everytime

5 posts, 0 answers
  1. Rajasekhar
    Rajasekhar avatar
    15 posts
    Member since:
    Sep 2011

    Posted 15 Sep 2011 Link to this post

    Hi,

      Generally filter works on the binded dataset, but i have a situation each time it should get results from the database based on the selected value in the filter. For suppose if they select date in the filter it should pass the date to Stored Procedure and it should get the new dataset.

    Please update this thread if anybody have the answer (or) Is there any other way to achieve this? please suggest.
  2. Iana Tsolova
    Admin
    Iana Tsolova avatar
    3388 posts

    Posted 20 Sep 2011 Link to this post

    Hello Rajasekhar,

    If you are binding your grid through the NeedDataSource event, there you can get the grid filter expression and use it to build your query so only desired data is returned from the server.

    Regards,
    Iana Tsolova
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Rajasekhar
    Rajasekhar avatar
    15 posts
    Member since:
    Sep 2011

    Posted 21 Sep 2011 Link to this post

    Hi Iana Tsolova,

     Thanks for the update. What you suggested seems to be working fine. but here GridColumn.CurrentFilterFunction always returns previous postback value if i try to get this value inside the NeedDataSource event.

    Regards,
    Rajasekhar
  5. Iana Tsolova
    Admin
    Iana Tsolova avatar
    3388 posts

    Posted 21 Sep 2011 Link to this post

    Hello Rajasekhar,

    This is working properly on my side. Can you test the attached sample and let me know how it goes on your end and what differs in your case?

    All the best,
    Iana Tsolova
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
  6. Rajasekhar
    Rajasekhar avatar
    15 posts
    Member since:
    Sep 2011

    Posted 27 Sep 2011 Link to this post

    Hello Iana Tsolova,

        Thank you very much. provided code snippet is working fine.

    Regards,
    Rajasekhar.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017