Data Source Paging

Data source paging enables you to write custom logic for retrieving pages of database records. You can perform the paging in the component, a stored procedure, or a LINQ to SQL query.

If you want the best performance, you should write your paging logic in either a stored procedure or a LINQ query. We examine both approaches in this section.

Note

Chapter 20 is devoted to the topic of LINQ.

The page in Listing 18.20 contains an ObjectDataSource control with data source paging enabled.

Listing 18.20. ShowDSPaging.aspx

images

images

The

Get ASP.NET 4 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial