This is the first tutorial in a lengthy series that will explore techniques for implementing these common patterns in ASP. We'll start with creating a software architecture composed of a Data Access Layer (DAL) using Typed Data Sets, a Business Logic Layer (BLL) that enforces custom business rules, and a presentation layer composed of ASP. Once this backend groundwork has been laid, we'll move into reporting, showing how to display, summarize, collect, and validate data from a web application.These tutorials are geared to be concise and provide step-by-step instructions with plenty of screen shots to walk you through the process visually.These scripts can be also be downloaded directly from Microsoft, if you'd prefer.If you use a different SQL Server version of the Northwind database, you will need to update the file.This will bring up the Add Connection dialog box, where you can specify the server to connect to, the authentication information, and the database name. NET page's code portion or using the Sql Data Source control from the markup portion.Once you have successfully configured the database connection information and clicked the OK button, the database will be added as a node underneath the Data Connections node. In either case, this approach tightly couples the data access logic with the presentation layer.The benefits of this layered architecture are well documented (see the "Further Readings" section at the end of this tutorial for information on these advantages) and is the approach we will take in this series.All code that is specific to the underlying data source – such as creating a connection to the database, issuing commands, and so on – should be located in the DAL.
We create databases to store the data, code to retrieve and modify it, and web pages to collect and summarize it.
Each tutorial is available in C# and Visual Basic versions and includes a download of the complete code used.
(This first tutorial is quite lengthy, but the rest are presented in much more digestible chunks.) For these tutorials we'll be using a Microsoft SQL Server 2005 Express Edition version of the Northwind database placed in the folder also contains the SQL scripts for creating the database, in case you want to use a different database version.
The web application was built using Visual Studio 2005 Professional Edition as a file system-based Web site project.
However, all of the tutorials will work equally well with the free version of Visual Studio 2005, Visual Web Developer.