AUDIENCE:   This course is for all delegates interested in gaining a solid grounding in the use of Active Server Pages. PREREQUISITES:   Understanding of web development and programming techniques. Previous experience with a suitable programming language, e.g.VB.net, C# and a knowledge of HTML would be useful. DURATION:   5 days. Hands on. OBJECTIVES:   Microsoft's .NET architecture is revolutionising Internet application development. This course will teach students how to master building data-driven Web applications and services with ASP.net, the next generation of Microsoft Active Server Pages technology. After completing this course, students will be able to: - Successfully design the architecture of ASP.net applications - Write ASP.net applications in VB.net, the successor to 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 utilize 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 2005 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 • Exercise 1: 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 2: Completing a More Complex Application that Uses Web ServerControls Data Types and More Control Flow Structures Fundamental Data Types in VB.NET • Select Case • Loops in VB.NET • Exercise 3: Implementing a For Each Loop Arrays, Subroutines, and Functions Arrays • Subroutines • Functions Exercise 4: Implementing the Previous Exercise Application UsingSubroutines Events in ASP.NET Page events • Web Server Control Events • Example: payperviewdemo.aspx • Exercise 5: 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 • Exercise 6: 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 • Exercise 7: 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 8: Building a LastName Query Interface Handling Exceptions Handling Database Exceptions • Try-Catch-Finally-End Try • Exercise 9: 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 • Exercise 10: Building Your First Disconnected Recordset Application Inserting Records into the Database Inserting Records via a Disconnected Recordset • Inserting a Record Directly Into the Database • Exercise 11: Inserting a Viewer into the Database via a DisconnectedRecordset Data Drilldowns with Data Bound Controls Exercise 12: Building a Drilldown Application with a DynamicallyPopulated DropDownList Working with Stored Procedures Passing Input Parameters to a Stored Procedure • Exercise 13: Building an Application that Uses a Stored Procedure Application Variables and global.asax What is an Application? • A Sample global.asax File • A Hit Counter Application Variable Example • Exercise 14: Setting and Retrieving Application Variables Session Variables Exercise 15: Using Session Variables Introducing XML XML Logical Structure • XML Physical Structure • Why Use Attributes? • XML Design Patterns • Applications of XML (and related technologies) • What We’ll Cover in the Following Four Sections Producing XML from Database Data via ADO.NET Exercise 16: Generating XML from the Viewers Table Reading XML Data into a DataSet Exercise 17: Reading an XML File into a DataSet Importing XML into the Database Exercise 18: Importing an XML File into the Viewers Table Performing XSLT with ASP.NET Exercise 19: Transforming an XML Document via XSL Working with Validation Controls RequiredFieldValidator, CompareValidator, and RangeValidator • The ValidationSummary Control • Exercise 20: Implementing Validation Controls 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: \b and \B • Using the RegularExpressionValidator • Exercise 21: Using the RegularExpressionValidator Control Custom Validators Exercise 22: Implementing the CustomValidator Control User Controls Exercise 23: Completing and Implementing a User Control Code Behind Exercise 24: Completing and Implementing a Code Behind Assemblies Exercise 25: 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 • Exercise 26: Building Your First Web Service Appendix A: 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