The goal of Data Access in ASP.NET 2.0 Framework is to show you everything that you need to know to start building database-driven web applications using the Microsoft ASP.NET 2.0 framework and the Microsoft Visual Studio Development environment.
Your instructor for this video is Stephen Walther, a long time developer of commercial websites including Collegescape.com which is used by Harvard, Stanford, and MIT to accept admission applications. He was also named a software legend by Microsoft.
This training package contains a video that is divided into 5 modules and runs around 4 hours and 20 minutes. There is also a workbook that is divided into 3 sections. The first section is a step-by-step companion to the video. After you watch the video, you can use this section to review a topic without having to go back and re-watch the video to remember some part of the technique. The second section contains an introduction to SQL. This is aimed at those who are new to Microsoft SQL Server 2005 or to the SQL language. The third part is an introduction to ASP.NET 2.0 - again, this is for those who are new to the subject.
To work with Data Access in ASP.NET 2.0 Framework you will need to have one of the Visual Studio 2005 (or greater) editions installed on your system; this can be the express edition that is available for free from Microsoft.
Module 1, "Getting Familiar" will introduce you to the Microsoft Visual Studio development environment. You will learn about the different versions and what they offer. The version that is expected you have is the Visual Web Developer Express edition. You will step through the interface and then you will create a new website, learn how to use the solution explorer, the editor, the toolbox, and the properties windows. You will then see how to run an ASP.NET page.
Module 2, "Creating an Employee Directory" shows you how to create an employee database table. This is done to illustrate how you can create a functional database driven application using ASP.NET From there you will create the default.aspx page that displays a list of all employees as well as creating an add and edit page that will allow you to modify the table.