Creating a Data Access Layer:
Step2-Creating a Data Access Layer
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.