[Firebird-net-provider] Restricting number of records returned

[Sandeep C. <sa...@cf...>]

I have a search screen (WinForm app) where I show the result in a 
DataGrid. If the user enters some search criteria then the number of 
records returned is  less. But if the user doesn't specify anything all 
records are returned and this slows down the server. What I want to 
achieve is to have some kind of paging so that the DataGrid fetches only 
records it can show in grid and then  does another fetch when the user 
scrolls.  Is it possible? If yes, could anyone point me in the right 
direction.

Regards

Sandeep