Hello,
I am hoping for some assistance. I'm trying to build as general a grid as possible. It has a dataSource that uses server side paging, sorting, and filtering. It all works great, at least until the server gets a request from the dataSource and has a hard time figuring out the query that it should execute.
The web server is running .NET, so the dataSource uses web methods to exchange data with the data server via a SqlConnection. The dataSource stringifies all the options very nicely but I can't come up with a general solution for how to write parameters for my web methods that can take a variety of filtering cases.Any help on how to represent a filter on the server in the most general case?. Any kind of pointers or any explainer videos would be great if shared.
Would highly appreciate your help.
Thank you.