Welcome to the second and final part of this tutorial regarding how to build an ASP.NET application that utilizes ADO.NET as the data provider. During part 1 we explored the scenario where a single developer builds everything from the database up in a 2-tier design by utilizing the data wizards of the data controls designed for ASP.NET WebForms.
The purpose of this second part of the tutorial is to build the same features that were built during part 1, but instead to use an N-tier design to create a more reusable data tier. Although this process is much more manual it gives the developer greater flexibility and control over the data source coding and allows them to implement object oriented patterns which can be reused across the application.
Note: Visual Studio .NET running ASP.NET version 1.x is required for this tutorial. Access to SQL Server is not required but preferred, you must have access to a database however in order to properly implement the sample code. Both VB.NET and C# code samples will be provided