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.
The steps for adding the Northwind database to the Server Explorer depend on whether you want to use the SQL Server 2005 Express Edition database in the folder or if you have a Microsoft SQL Server 2000 or 2005 database server setup that you want to use instead.
If you do not have a SQL Server 2000 or 2005 database server to connect to, or you simply want to avoid having to add the database to a database server, you can use the SQL Server 2005 Express Edition version of the Northwind database that is located in the downloaded website's folder is automatically added to the Server Explorer.
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.
Before we can create our Data Access Layer (DAL), we first need to create a web site and setup our database. With the web site created, the next step is to add a reference to the database in Visual Studio's Server Explorer.
In this tutorial we'll start from the very beginning and create the Data Access Layer (DAL), followed by creating the Business Logic Layer (BLL) in the second tutorial, and working on page layout and navigation in the third.
The tutorials after the third one will build upon the foundation laid in the first three.
Once you have the database installed, go to the Server Explorer in Visual Studio, right-click on the Data Connections node, and choose Add Connection.
If you don't see the Server Explorer go to the View / Server Explorer, or click Ctrl Alt S.