Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Articles
Visual Studio Team System Security Enhancements at a Glance   21 Mar 2006 20:34 GMT
Video overview of Visual Studio Team System security features.
Source: MSDN
Microsoft® Code Master Challenge: 3/20 – 7/31   21 Mar 2006 18:48 GMT
Developers and ISVs: Build the best new app with Windows Vista to win $50,000!
Source: MSDN
Top 10 Annotations and Remarks about the Wonderful and Powerful New Features in ASP.NET 2.0   17 Mar 2006 23:36 GMT
This article discusses 10 features of ASP.NET 2.0 from a real-world perspective. It is not a core reference of classes and methods, but a user's guide with suggestions and trade-offs.
Source: DevX
Introducing Microsoft Visual Basic 2005 for Developers   17 Mar 2006 19:29 GMT
Get a focused, first look at the features and capabilities in Microsoft Visual Basic 2005, Visual Studio 2005, and the .NET Framework 2.0.
Source: MSDN
Pac-Man for the Smartphone   17 Mar 2006 17:23 GMT
Learn how Bryan Dougherty updated the classic arcade game Pac-Man for his new Smartphone, with a bit of help from the Windows Mobile 5.0 SDK.
Source: MSDN
Using the Enterprise Library Data Access Block for .NET 2.0   16 Mar 2006 22:06 GMT
Writing database-access code is a repetitious and time-consuming task, but now that it's available as a reusable Enterprise Data Access Application Block, you'll never have to write such code again.
Source: DevX
Using P/Invoke to Call Unmanaged APIs from Your Managed Classes   16 Mar 2006 21:19 GMT
Learn how to use P/Invoke to call unmaged Win32 APIs from managed code. These sample applications show how to mute sounds, change Windows resolution, and display ballon tips from your managed code.
Source: MSDN
How To Control Robots (and Other Devices) with Your Voice   16 Mar 2006 20:24 GMT
Learn how to build speech recognition applications that let you control devices using voice commands. This article shows how you can control a robot's movement with spoken commands.
Source: DevX
An Incremental Search in the .NET IDE   15 Mar 2006 03:09 GMT
Learn about this simple method to perform incremental searches in the .NET IDE.
Source: DevX
Custom Paging in ASP.NET 2.0 with SQL Server 2005   15 Mar 2006 00:00 GMT

A common pattern in web development is providing paged access to data. Rather than displaying the entire contents of a report or database table to an end user, developers often show only a subset of records per web page, with controls for moving from page to page. With ASP.NET 1.x, the DataGrid made paging incredibly simple - just set the AllowPaging property to True and add a few lines of code in the PageIndexChanged event handler and you were done! ASP.NET 2.0's GridView makes the process even simpler - just check the Enable Paging option from the GridView's smart tag - no code needed.

Of course nothing is free in life, and the tradeoff you make with the ease of checking a checkbox to enable paging (or, in the DataGrid's case, writing a couple lines of code) is performance. Out of the box, the DataGrid and GridView use default paging, which is a simple paging model that returns all of the records for each every page of data shown. When paging through small amounts of data (dozens to a hundred or so records), this inefficiency is likely outweighed by the ease of adding the feature. However, if you want to page through thousands, tens of thousands, or hundreds of thousands of records the default paging model is not viable.

The alternative to default paging is custom paging, in which you are tasked with writing code that intelligently grabs the correct subset of data. It requires a bit more work, but is essential when dealing with sufficiently-sized data. I discuss how to implement custom paging in ASP.NET 1.x in my book ASP.NET Data Web Controls Kick Start. In this article we'll look at how to implement custom paging in ASP.NET 2.0 using SQL Server 2005's new ROW_NUMBER() feature. (For more information on SQL Server's new ranking features, including ROW_NUMBER(), see Returning Ranked Results with Microsoft SQL Server 2005.)

Read on to learn more!
Read More >


Source: 4GuysFromRolla
1 2 3 4 5
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.