ASP.NET Programming with Visual Basic (.NET 3.5 & 4.0)

Audience

This course is for all delegates interested in gaining a solid grounding in the use of ASP.NET (Active Server Pages) with Visual Basic. (Equivalent ASP.NET C# class available on request.)

Prerequisites

Understanding of web development and programming techniques. Previous experience of development with VB.NET would be useful.

Duration

5 days. Hands on.

Course Objectives

Microsoft's .NET architecture has revolutionised Internet application development.  This course will teach students how to master building data-driven Web applications and services with ASP.NET, Microsofts Active Server Pages technology.  After completing this course students will be able to:

• Design the architecture of ASP.NET applications.
• Write ASP.NET applications in Visual Basic and VBScript (the course is also available using C# if required).
• Create Web forms with ASP.NET Form Controls. - Work with ASP.NET Server Controls to validate and process form submissions and perform other vital tasks. - Build database-driven applications with ASP.NET and ADO.NET
• Produce XML data from your ASP.NET applications, and utilise ASP.NET to parse XML data and store it in a database.
• Declare and control Web applications with global.asax - Maintain state for each user via ASP.NET session management.
• Understand the role of Web services and build your first data-driven Web services.
• Successfully debug and deploy your ASP.NET applications.

Course Content

Introducing ASP.NET
What experience does this course presume? • What is the .NET Framework? • What is ASP.NET? • What languages are supported for writing ASP.NET applications? • What software do I need in order to run ASP.NET applications? • What does the Microsoft .NET Framework SDK include? • What happens the first time an ASP.NET file is executed? • Examining a Sample .NET Application that Uses asp:label • Processing Form Submissions Under the New Model • Processing Form Submissions and Working with asp:label

Conditionals and Additional Web Server Controls
Conditionals in VB.NET • asp:dropdownlist and asp:listbox • asp:radiobuttonlist • asp:checkbox • Exercise: Completing an Application that Uses Web ServerControls

Data Types and More Control Flow Structures
Fundamental Data Types in VB.NET • Select Case • Loops in VB.NET • Implementing a For Each Loop

Arrays, Subroutines, and Functions
Arrays • Subroutines • Functions - Implementing the Previous Exercise Application UsingSubroutines

Events in ASP.NET
Page events • Web Server Control Events • Example: payperviewdemo.aspx • Handling a Server-Side Click Event

Introduction to Object Oriented Concepts
Objects are Created from Classes • To Instantiate an Object, Call the Class’s Constructor • In VB.NET, All Variables are Typed • Objects in VB.NET Have Methods and Properties • Methods and Properties are Unique to Each Class • Classes Relate to Each Other in Hierarchies • Classes Automatically Inherit All Methods and Properties of The ClassesAbove Them • Example: Building and Using a Viewer Class • Defining Methods • Writing and Using your First Class

Inheritance and Overriding
Declaring the Class as a Subclass of Viewer • Writing the New Constructor • Method Overriding • Shared (Static) Properties • Subclassing Program with Movie

Request, Response, and Server
Side Note: Server.HTMLEncode()

Introducing ADO.NET
ADO.NET Uses OleDB Instead of ODBC • System.Data and System.Data.OleDb Contain the Classes for DatabaseAccess • Further Comparison of ADO.NET and ADO • Introducing the Database Used for the Course • Selecting Records from the Database via ADO.NET • asp:datagrid • Exercise: Building a LastName Query Interface

Handling Exceptions
Handling Database Exceptions • Try-Catch-Finally-End Try • Writing a Query Viewer that Handles SQL Errors and EmptyDataSets

Working with Disconnected DataSets
OledbAdapter and DataSet • Populating a DataGrid from a DataSet • Examining a More Complex Example

Inserting Records into the Database
Inserting Records via a Disconnected Recordset • Inserting a Record Directly Into the Database

Data Drilldowns with Data Bound Controls
Building a Drilldown Application with a DynamicallyPopulated DropDownList

Working with Stored Procedures
Passing Input Parameters to a Stored Procedure

Application Variables and global.asax
What is an Application? • A Sample global.asax File • A Hit Counter Application Variable Example

Session Variables
Using Session Variables

Introducing XML
XML Logical Structure • XML Physical Structure • Why Use Attributes? • XML Design Patterns • Applications of XML (and related technologies)

Producing XML from Database Data via ADO.NET
Generating XML from the Viewers Table

Reading XML Data into a DataSet

Importing XML into the Database
Importing an XML File into the Viewers Table

Performing XSLT with ASP.NET
Transforming an XML Document via XSL

Working with Validation Controls
RequiredFieldValidator, CompareValidator, and RangeValidator • The ValidationSummary Control

Regular Expression Validation
Introducing Regular Expressions • Regular Expression Tester • Special Characters for Pattern Matching • Escape Sequences for Special Characters • Specifying Ranges in Patterns • Matching a Specified Number of Occurrences • Character-Range Escape Sequences • Matching at the Beginning or End of a String with ^ and $ • The Word-Boundary Pattern Anchors:  and B • Using the RegularExpressionValidator

Custom Validators
Implementing the CustomValidator Control

User Controls
Completing and Implementing a User Control

Code Behind
Completing and Implementing a Code Behind

Assemblies
Building and Deploying an Assembly

Introduction to Web Services with SOAP
What are Web Services? • What is SOAP? • Examining a Web Service • Calling a Web Service from another Application • Setting up a Web Service Proxy • Building Your First Web Service

SQL Refresher
Data Types in SQL • Creating a Table in SQL • Inserting a Row into the Table in SQL • Inserting a Partial Row (or Fields in a Different Order) in SQL • Retrieving Information from the Database via SELECT • Editing Records in the Database with the UPDATE Statement • Removing Records from the Database with the DELETE Statement