Matthias Schuster
Top achievements
Rank 1
Rank 1
Matthias Schuster
asked on 22 Jul 2009, 02:10 PM
Hello,
we are developing a client/server 3-tier application and need to filter and sort huge amount of data. Let me first explain the current situation.
WebSite <-> ApplicationServer <-> Database
WinApp <-> WebService <-> ApplicationServer <-> Database
The Website calls the methods in the applicationserver directly e.g. "Users.GetAllUsers()".
The WinApp calls the same method via webservice.
Our current grids show the data in the sort order returned by the method above. Now we need to implement sorting/filtering and paging on the grids and we'd like to use the standard funktionality of the grids. As we have a 3-Tier application i do not want to directly connect the grid to the database, merely i want to connect the grid to the ApplicationServer.
Does anybody know how we can achieve this in an elegant way? It should work over webservices, too.
I was thinking of getting a serialized expression tree from the radgrid that i can send to the webservice which itself manipulates it and sends it to the database. The data is then returned to the grid.
Any ideas?
we are developing a client/server 3-tier application and need to filter and sort huge amount of data. Let me first explain the current situation.
WebSite <-> ApplicationServer <-> Database
WinApp <-> WebService <-> ApplicationServer <-> Database
The Website calls the methods in the applicationserver directly e.g. "Users.GetAllUsers()".
The WinApp calls the same method via webservice.
Our current grids show the data in the sort order returned by the method above. Now we need to implement sorting/filtering and paging on the grids and we'd like to use the standard funktionality of the grids. As we have a 3-Tier application i do not want to directly connect the grid to the database, merely i want to connect the grid to the ApplicationServer.
Does anybody know how we can achieve this in an elegant way? It should work over webservices, too.
I was thinking of getting a serialized expression tree from the radgrid that i can send to the webservice which itself manipulates it and sends it to the database. The data is then returned to the grid.
Any ideas?
1 Answer, 1 is accepted
0
Bodevain Svensson
Top achievements
Rank 1
Rank 1
answered on 27 Jul 2009, 03:14 PM
From my previous developer experience with the Telerik controls I know that their grid supports client and server binding to web services:
http://demos.telerik.com/aspnet-ajax/grid/examples/overview/defaultcs.aspx (See Populating with data -> WebService binding section)
How you will connect the web service, available on the Application Server, with your DB to fetch data or update it depends on your schema. I suppose this logic may vary in a custom way but hope that you get the idea.
Bodevain
http://demos.telerik.com/aspnet-ajax/grid/examples/overview/defaultcs.aspx (See Populating with data -> WebService binding section)
How you will connect the web service, available on the Application Server, with your DB to fetch data or update it depends on your schema. I suppose this logic may vary in a custom way but hope that you get the idea.
Bodevain