Microsoft’s ASP.NET site has a multi-part series on building a building and using three-tiered data architecture with ASP.NET 2.0. The series, currently at 23 lessons includes both C# and VB.NET sample code and as one would expect uses the familiar Northwind database.
Currently covered as building the data access layers with a typed dataset, created a business logic layer, using objectdatasource controls, basic reporting, master/detail filtering, custom formatting, and editing, inserting and deleting data. Using Master pages and themes is also covered. More lessons on sorting and paging are to come.
One item to note is how little code is needed to do updates compared to with ASP.NET 1.x.
This tutorial series and a host of other tips, tricks and traps are listed in ASP.NET team leader Scott Guthrie’s blog. Series author Scott Mitchell who co-founded ASP.NET site 4guysfromrolla.com also has a very useful blog.
Update: August 17, 2006
Scott Mitchell has added four more tutorials focusing on Paging and Sorting to the series. See the comments in his blog for a bug in lesson 25 that I found.