Hello, if you want to implement some sort of paging, you could try "Select first n skip m" syntax where n is the number of records to select in one turn, and m + 1 is the record number to start with.
-- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ KDT> Hello, KDT> I need some help, regarding the Query Result. I am not that much good at KDT> database side so I want some help. KDT> What my problem is I Querying database from some result, the result dataset KDT> is about 5K rows, which I had to display in the Listview control in my C# KDT> application. KDT> It is taking about 10 to 11 seconds to fetch the record from the database KDT> and same to populate the ListView control. Populating the list view control KDT> Is not a problem. That can be managed. KDT> What I want to ask is that, is there any way to get the results in counters KDT> so that I can get results in group of 100 records, so that I can display the KDT> data in Group of 100. KDT> So that the user does not have to wait for all the records to get populated. KDT> Please help me this. KDT> Regards, KDT> Rakesh Singh. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
