AspNetAtoms.com daily updates on ASP.NET Tutorials, Articles, Authors and more. Subscribe to our newsletter and receive updates on ASP.NET resources on the Internet.

Categories

Recent Posts

Custom Paging for TableAdapters without using SPs : Manuel Abadia

Sunday, February 22 2009

TableAdapters are a quick way to create a DAL writing very little code or none at all. However, there isn’t an easy way to modify the generated code. You can extend the generated class adding methods but it would be cool if you could modify the generated methods, for example, how the insertions are performed. As this is not possible you have to live with the code that is generated. Anyway, for small projects with very little business logic and data intensive projects, TableAdapters are very helpful. Even for a simple project, you need to avoid retrieving all table records in a query for performance reasons so you have to do custom paging. TableAdapters don’t have direct support for custom paging (sad but true) so you are on your own to implement it....

Read More:
Custom Paging for TableAdapters without using SPs : Manuel Abadia
Also See:
Combine Classic ASP and ASP.NET Content Seamlessly with Invisible Blended IFrames : Peter Bromberg
Introduction to DotNetNuke® Module Development : Michael Washington
Implementing Generic Caching : DaveTheKnave
HTTP compression in .NET Framework 2.0 : Paulo Morgado
Drag and Drop Using JavaScript : Mohammad Azam

Post your comment

Comment