Scott Mitchell of 4GuysFromRolla fame has
a great tutorial on MSDN
that gives a lot of best practices for creating a site with ASP.NET
using a three-tier architecture for working with a database. I have
found this to be a great resource. The examples are short, simple and
perfectly suited to real-world applications. I was particularly
interested in examples of using
Typed DataSets,
with a Data Access Layer, which I had found to be surprisingly hard to
come by. The examples I did find were confusing or poorly written at
best. If you are still relatively new to creating data-driven web
applications, then this is a must read. All of the examples are written
in both C# and Visual Basic and cover: