Hi Dmitry,
Here is link to a paging sample for SQL Server:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=633&lngWId=5The next version of SQL Server (Yukon) will have paging built in.
>I need to load big table in the grid (windows). Straight binding does this in few(!) minutes - not acceptable. How I can do paging (or load on demand)? I need real paging, not an overloaded fill() method of adapter. Very important is ability to scroll... Does any third party control exist? Or alghorithm other then described in MSDN?
>
>TIA
>Dmitry
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi