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:
How to embed UpdatePanel in a Repeater : Daron Yandem
Global.asax? Use HttpModules Instead! : Karl Seguin
Serialization in .NET : Joydip Kanjilal
Client Callback in a Website Registration Page : Omer Kamal
Code Snippets in Visual Studio 2005 : Patrick Santry

Post your comment

Comment