This step of the VIDEO TUTORIAL will emphasize on the two types of database patterns in manipulating the underlying data in a database table. They are database direct and batch update patterns, respectively. In the database direct pattern, the INSERT, UPDATE and DELETE commands are operated on a single record in a database table, where as the batch update pattern involves operating on entire dataset. For detailed information and source code for this step, please refer to the original article.

These steps of the VIDEO TUTORIALS(Part I and Part II) will show on how to generate TableAdapters to the remaining tables of the Northwind database by using the dataset designer of Visual Studio.NET 2005 as well as generating various methods to the respective TableAdapters using TableAdapter Configuration Wizard. The tutorial will also familiarize the user on how to locate the code-behind file of the dataset designer and browse the code definitions of various methods that were generated using the Class View utility. This final step will conclude in generating a complete data access layer that will serve as one of the key tiers of our proposed 3-tier architecture of the ASP.NET 2.0 website. For detailed information and source code for this step, please refer to the original article.

These steps of the VIDEO TUTORIALS(Part I and Part II) will show on how to generate TableAdapters to the remaining tables of the Northwind database by using the dataset designer of Visual Studio.NET 2005 as well as generating various methods to the respective TableAdapters using TableAdapter Configuration Wizard. The tutorial will also familiarize the user on how to locate the code-behind file of the dataset designer and browse the code definitions of various methods that were generated using the Class View utility. In addition, concept of partial classes will also be introduced.This final step will conclude in generating a complete data access layer that will serve as one of the key tiers of our proposed 3-tier architecture of the ASP.NET 2.0 website. For detailed information and source code for this step, please refer to the original article.