|
Provided by: Serebra Learning Corporation MS VB .NET: Web Development Part 3: Data Access in Visual Studio and ADO.NETMicrosoft Visual Basic (VB) |
 |
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 CDROM 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 CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
