JQXGrid – ASP.NET Server-Side Functions

[bradsymonsMember]

Hi

I am a little confused at how I should be implementing some of the other functions in the grid.

I’ve managed to get the nested grids with dependent data working and have paging working fine.

I am now trying to implement server side filtering but I am having some trouble. (I had a look at the MVC3 exmaples but It doesn’t really help me with standard asp.net web methods).

Based on what I have read in the documentation, I should be able to do the following (it works for the sorting but not with any of the filtering)

1. Set my Grid to have filterable=true.
2. Add variables to my web method that gets the data for the grid for example

 public static string GetOrders(int pagenum, int pagesize, int filterscount)

I based this on the fact that in the documentation it says that the filterscount parameter is sent by default to the server, and adding the pagesize and pagenum parameters worked perfectly.

However when I add that to my web method, it just completely breaks and does not even call my web method when trying to render the grid.

Any help would be appreciated.

[bradsymonsMember]

I also need to send a bunch of custom filters.
I need to be able to send for example, the logged in user’s id to the server so that I can filter the data based on their access.

[Peter StoevKeymaster]

Hi bradsymons,

As a solution, you can see the BuildQuery method’s implementation in this help topic: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/asp.net-integration/asp.net-grid-server-side-filtering.htm. It shows how to get the parameters sent by the jqxGrid to the server. This help topic shows how to add additional parameters: jquery-grid-extra-http-variables.htm.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[bradsymonsMember]

Thanks for the response Peter.

I re-read through the documentation, slower this time 🙂 and figured out what I was doing wrong.
I was trying to use processdata AND formatdata together which obviously doesn’t make sense!

[Author]

Posts