Excel Like Filtering - using Webservice context is NULL

[Srikrishna]

W.r.t to Excel like filtering in radgrid. I am trying to call a webservice using -

ADMIN: Code removed upon OP request.

Requirement : To use Webservice , I have 40 columns so planning to send Column name as a context to WS method and reuse the select query for all..
eg)

 

ADMIN: Code removed upon OP request.

[Maria Ilieva]

Hi,

Note that using WebMethod as you are trying to achieve in your code would not work in this case. You should use WebService as shown in the online demo below:
http://demos.telerik.com/aspnet-ajax/listbox/examples/loadondemand/wcf/defaultcs.aspx

I hope this helps.

Regards,
Maria Ilieva
Telerik

[Srikrishna]

Thank you for your reply. The example you provided will involve much changes in my side as I have 40 columns and I would like to avoid using radcombo or listbox .. instead of my current gridboundcolumn. That's fine we settled with using multiple methods to achive this scenario.

 

I have found one more issue in Excel like filtering grid. When select few checkbox and click 'filter' it works fine. But once user tries to reopen the same column and click 'Clear Filter' button . It is not unchecking the checkbox selected by user before. I see that your online demo is working fine but I am not able to replicate that clearing in my side.

 

Question 1: Is there a way for me to Handle the 'ClearFilter' event in codebehind (or) client side .

Question 2 : I only want to clear the selected column filter not other remaining columns.

Question 3 : When I click 'Filter' button - radgrid filters but I don't get to see the loading image. Which shows up on other operations.

 

Please find the code .. Removed few lines . Please help. Using Vs 2015 enterprise , ,net 4.5.01055

Telerik : v4.0.30319 ,  version : 2015.3.1111.45 , Telerik UI for ASP.NET AJAX

 

 

ADMIN: Code removed upon OP request.

 

[Maria Ilieva]

Hi Srikrishna,

The mentioned issue was a problem in older version of the controls and this behavior is already fixed in the  latest official release. I would suggest you to update your application to the latest version and see how it goes.


Regards,
Maria Ilieva
Telerik

[Srikrishna]

Hi ,

   Sorry not sure about your reply , as I had the following 3 questions in it.

Question 1: Is there a way for me to Handle the 'ClearFilter' event in codebehind (or) client side .
Question 2 : I only want to clear the selected column filter not other remaining columns.
Question 3 : When I click 'Filter' button - radgrid filters but I don't get to see the loading image. Which shows up on other operations.

 

You mean to say that Question 2 -- will be resolved with latest version ?

Can you please suggest something on Question 1 and Question 3?

 

Thanks

 

[Maria Ilieva]

Hi Srikrishna,

1. The ClearFilter method fires OnCommand event and OnUseraction event that can be handeled.
2. If you need to clear the filter for specific column you could simply filter without parameter to achieve this requirement.
3. The LoadingPanel will appear when regular Ajax request is performed and when a service is called you should call it manually as shown below:
http://docs.telerik.com/devtools/aspnet-ajax/controls/ajaxloadingpanel/how-to/show-and-hide-ajaxloadingpanel-explicitly

Regards,
Maria Ilieva
Telerik

[Srikrishna]

HI MARIA,

   Thank you for the options.

   Could you please give an sample code to using - ' The ClearFilter method fires OnCommand event and OnUseraction event that can be handeled.'

   I have 10 columns in my radgrid , when I click clear filter button --- I don't know how to get the current column & how to uncheck the checkboxs that I selected earlier to filter upon ... I mean I want to perform a nofilter operation on click on clearfilter.

 

   appreciate if you could provide a sample for 1 and 2 options you provided.

thanks

krishna

 

[Maria Ilieva]

Hello,

You can simply handle the server OnCommand event with Filter command name as when "Clear Filter" button is clicked a filter command with empty filter function, value and expression fires.

Regards,
Maria Ilieva
Telerik

[Srikrishna]

Please delete the following post from me ... as it contains some information that I should have removed before posting..

 

http://www.telerik.com/forums/excel-like-filtering---using-webservice-context-is-null#ho0lv6aTg0-ZZH_ZJqXfEg

 

[Marin Bratanov]

Hi Krishna,

I removed the code snippets. I left the discussion itself in case someone else finds it useful.

Regards,

Marin Bratanov
Telerik by Progress