From: Alan M. <al...@me...> - 2003-06-12 09:12:28
|
Carlos, Can you tell me:... The ASP.NET coponents include a datagrid (much like the old datagrid for ASP) but it now sports a page numbering navigation bar (instead on the old first, last, previous, next links) I'm not sure how the old one handled this in terms of the query and paging but I suspect that even with large queries, the component, in conjunction with the recordset object would retrieve all records in the query, then page down/up to the required start point for the page control, then render the records required for the page. Obviously this is quite a heavy solution for larger datasets/queries. I have to suspect this to be so since the old ODBC drivers and the old IB (up to 6.0) never had the FIRST and SKIP commands. Now that FB has the FIRST and SKIP commands, will the ASP.NET provider be able to use them for the purpose of efficiently delivering page-sized recordsets to this new grid control? Is there another way it does this efficiently? Is there something I am missing? Thanks Alan McDonald PS - glad to see you are back on line - thanks to Sean - perhaps contact me offline - maybe there is something else you need which I might be able to provide you. |