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.

This step of the VIDEO TUTORIAL will demonstrate on how to create Typed Dataset (Northwind.xsd), Table Adapter for Products Table of Northwind database and add to a dataset designer surface in the Visual Studio 2005. In addition, steps to add the Typed dataset to the App_code folder, configure the Table Adapter Configuration wizard such as saving the connection string to the web.config file of the proposed website, build and execute queries for returning data, method patterns to populate strongly typed dataset collection with data tables will also be introduced. A demonstration of the above steps will culminate in creating an .aspx page with a GridView displaying the data from the Products table of Northwind databases with just few lines of code. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will expand upon the previous of step of adding additional method to the ProductsTableAdapater which requires a parameter to return the DataTable. The tutorial will conclude by creating .aspx page that will display a GridView with Product information based on a particular categoryID. For detailed information and source code for this step, please refer to the original article.