SQL Server 2005 and Ajax.NET Professional, RowNumber Example
On the Ajax.NET Blog, Michael explore the new RowNumber feature in SQL Server 2005 to get only a page of rows that are displayed on the page. The Datagrid component will then have next and prev buttons to scroll through the complete data. Michael also used Fiddler, a HTTP Debugging Proxy, to show the result of using the datagrid on the bandwidth which makes the data transferred 1.600 Bytes per page.
I often want to display something like a DataGrid on my web sites with next and prev buttons to scroll through the complete table. Using SQL Server 2005 it is very easy to build such controls that are using the new RowNumber feature to get only a page of rows that are displayed on the page. If you click on next you will get the next n rows.
Subscribe to AJAX Magazine's feed