Filter should get new records from database everytime

[Rajasekhar]

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.

[Iana Tsolova]

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

[Rajasekhar]

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

[Iana Tsolova]

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

[Rajasekhar]

Hello Iana Tsolova,

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

Regards,
Rajasekhar.