MS VB .NET: Windows Development Part 5

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Description

Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access.

Audience

This course is designed for beginning Web developers and Microsoft Visual Basic developers who want to learn Visual Studio .NET and ASP.NET. Beginner Web developers have minimal experience with programming. However, they know the basic constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition.

Prerequisites

This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a scripting language, such as Visual Basic Scripting Edition or Microsoft JScript.

Objective

Upon completion of this course, the student will be able to:

• identify features of ADO.NET.
• identify the syntax for importing ADO.NET namespaces.
• identify features of the ADO.NET object model.
• identify features of SQL Server security authentication.
• match connection string parameters with their functions.
• identify characteristics of a DataAdapter.

Topics Include

Unit 1: Visual Studio .NET Data Access

• Identify features of ADO.NET.
• Identify the syntax for importing ADO.NET namespaces.
• Identify features of the ADO.NET object model.
• Sequence the steps for accessing data with ADO.NET.
• Connect a Web Form to a database by using Server Explorer.
• Identify features of the DataAdapter object.
• Sequence the steps to generate a DataSet.
• Match list-bound control types with their characteristics.
• Match list-bound control properties with their descriptions.
• Display data by using a DataGrid control.
• Create a custom column header in a DataGrid control.
• Page a DataGrid control.
• Identify the stages for displaying data using the Repeater and DataList controls.
• Match template types with their features.
• Identify the syntax for using templates with a DataList control.
• Match style properties of ASP.NET controls with their features.

Unit 2: ADO.NET Data Access

• Identify features of SQL Server security authentication.
• Match connection string parameters with their functions.
• Identify characteristics of a DataAdapter.
• Identify the syntax used to populate a DataSet with DataTable objects.
• Identify the syntax for accessing a DataTable.
• Identify data access considerations for selecting DataSet or DataReader objects.
• Identify the syntax for using DataView objects.
• Sequence the steps for binding a DataSet to a list-bound control.
• Identify the syntax for handling database errors.
• Identify the syntax for creating multiple tables.
• Identify the syntax for creating a relationship between DataTables.
• Identify the syntax for programmatically navigating between relationship tables.
• Sequence the steps for visually navigating between related tables by using DataViews.
• Identify characteristics of a DataReader.
• Sequence the steps for connecting a DataReader to a data source.
• Identify the syntax for reading data from a DataReader.
• Identify the syntax for binding a DataReader to a list-bound control.
• Match stored procedures with their functions.
• Identify the syntax used to call a stored procedure.
• Identify the syntax used to display data from a stored procedure in a list-bound control.
• Identify the syntax to use parameters with stored procedures.

Duration

8 Hours

Minimum Requirements

The CD-ROM version of this course requires: At least a 486DX 33Mhz CPU. Microsoft Windows 3.1 or higher and a Microsoft-compatible mouse. At least 8MB RAM. At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended). At least a double-speed CD-ROM drive. An MPC-compliant sound card with attached speakers or headphones is recommended. The network version of this course requires: At least a 486DX 33Mhz CPU. Microsoft Windows 3.1 or higher and a Microsoft-compatible mouse. At least 8MB RAM and 14MB available hard disk space or file server space. At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

© Copyright Serebra Learning Corp., 2002