Creating a Data Acces Layer:
Step1-Creating a Web Project and Connecting to the Database
This VIDEO TUTORIAL demonstrates on how to create the basic plumbing i.e., creating a data access layer for an ASP.NET 2.0 based website in a 3-tier architecture using Visual Studio.NET 2005. The tutorial will demonstrate on how to connect to an existing Northwind database (installed on SQL Server 2005 Express or Enterprise Server) that was already available on a client or server. In addition, it will also demonstrate on how to connect to Northwind database that was downloaded with the source code of this article to create the data access layer that will be used in building various upcoming video tutorials of the proposed ASP.NET 2.0 web site. This video tutorial assumes that users have prior knowledge of building web applications using Visual Studio.NET 2003/SQL Server 2000 or familiar with building web applications using Microsoft tools and technologies. For getting additional information or for obtaining the source code and Northwind database of the video tutorial, please refer to the original article that served as a basis for this tutorial.