Intercepting Grid queries to work with FireBird

[Mike]

Hello.

Hopefully I dont come off sounding like a fool :)

I am using Visual Studio 2010, with demo version of telerik asp.net to see if I can make this work with FireBird DB

Basically what I want to do is have the grid work with firebird for huge datasets.

With Paging ASP is creating the limit queries to return only a subsset of data for that particular page in the grid honoring the current sorted colums, etc.

How can I do this in firebird ?

I am hoping I can use an event to generate the select sql based on the current columns chosen to sort by and get back the page the client is requesting etc..

I hope this  makes sense what I am asking :)

[Radoslav]

Hi Mike,

To achieve the desired functionality you could try using the ObjectDataSource and implement your own method which returns sorted and filtered data. Into this method you could perform manually the operations over the FireBird DB. Please check out the following links which elaborate on Firebird .NET provider and ASP.NET:
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider
http://stackoverflow.com/questions/1952231/firebird-net-provider-and-asp-net
http://forums.asp.net/p/911920/1024029.aspx
http://rixxtech.blogspot.com/2008/10/using-firebird-with-aspnet.html

I hope this helps.

Greetings,
Radoslav
the Telerik team