tag:blogger.com,1999:blog-7192910.post6392457517745775214..comments2024-03-01T08:27:06.252-06:00Comments on PremierPoint Solutions Team Blog: SharePoint Data Zoom: Handling Complex List Field TypesPremierPoint Solutionshttp://www.blogger.com/profile/03668782854153322571noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7192910.post-48836320990083779382009-04-17T08:32:00.000-05:002009-04-17T08:32:00.000-05:00You can page SQL records by formatting your T-SQL ...You can page SQL records by formatting your T-SQL query. For SQL Server 2005 and above you can format your query like so...<br /><br />SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY CompanyName desc) AS rownum, * FROM Customers) AS tmpCustomers WHERE rownum >= 21 AND rownum <= 30<br /><br />To format the UI to allow users to select the page size and navigate between pages check out the <A HREF="http://www.siafoo.net/snippet/267" REL="nofollow">User Directory script</A>.Jeremy Luerkenshttps://www.blogger.com/profile/00852530120787321966noreply@blogger.comtag:blogger.com,1999:blog-7192910.post-46364948557625452382009-04-16T23:53:00.000-05:002009-04-16T23:53:00.000-05:00I'm testing the Data Zoom web part, and it's very ...I'm testing the Data Zoom web part, and it's very promising. Currently checking out the SQL Server extension as well. Do you have an example on how to do paging when displaying large lists/data sets?<br /><br />- FrodeFrode Sørhøy, Sparebanken Vest, Bergen, Norwayhttps://www.blogger.com/profile/13413837856618354337noreply@blogger.com