ASP.NET 1.x: Bundle: MS2310 + MS2389

Course Overview

This course combines an accelerated schedule of learning, and will teach Visual Basic programmers and Web application developers the fundamentals of Web application site implementation using ASP.NET. The course focuses on using the Microsoft Visual Studio .NET environment and the Microsoft .NET platform to create an ASP.NET Web application that delivers dynamic content to a Web site. In addition, the course covers building data-centric applications and Web services with ADO.NET and SQL Server.

Audience

This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organisation. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio.

Skills Gained

• Build a DataSet schema, populate it with data, and modify the data programmatically
• Create an ASP.NET Web application project by using Visual Studio .NET
• Configure and deploy an ASP.NET Web application
• Connect to SQL Server and other data sources
• Explain the Microsoft .NET Framework and ASP.NET
• Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML
• Add server controls to an ASP.NET Web Form
• Accomplish complex data access tasks from an ASP.NET Web application
• Access Extensible Markup Language (XML) data and read it into a DataSet
• Help protect an ASP.NET Web application by using a variety of technologies
• Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML
• Create a component in Visual Basic .NET or C#
• Create and populate ASP.NET Web Forms
• Add functionality to server controls that are on an ASP.NET Web Form
• Use the Trace and Debug objects that are provided with Visual Studio .NET
• Use validation controls to validate user input.
• Access data by using the built-in data access tools that are available in Visual Studio .NET
• Use Microsoft ADO.NET to access data in an ASP.NET Web application
• Call an XML Web service from an ASP.NET Web application and incorporate the returned data into a Web application
• Store application and session data by using a variety of methods
• Build a DataSet from an existing data source.
• Build a Web service that uses ADO.NET to query and update a data source
• Troubleshoot errors within an ADO.NET application

Examinations

• 70-305 - Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio.NET
• 70-306 - Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• 70-315 - Developing and Implementing Web Applications with Microsoft Visual C#(TM) .NET and Microsoft Visual Studio .NET
• 70-316 - Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Prerequisites

• Experience developing applications with Visual Basic 4.0 or later
• Exposure to XML documents, style sheets and schemas
• Understanding of relational database concepts such as table, row, column, primary keys, foreign keys, constraints and views.

Course Outline

INTRODUCTION TO ASP.NET

• Identify the languages that support ASP.NET.
• Choose an appropriate development language for their needs.
• Create a component by using Visual Studio .NET
• Creating Web Forms
• Using Server Controls
• Creating the default.aspx Web Form
• Creating the life.aspx Web Form

ADDING CODE TO A MICROSOFT ASP.NET WEB FORM

• Using Code-Behind Pages
• Adding Event Procedures to Web Server Controls
• Using Page Events

TRACING IN MICROSOFT ASP.NET WEB APPLICATIONS:

• Understanding Tracing
• Remote Debugging
• VALIDATING USER INPUT:
• The following areas are covered:
• Using Validation Controls
• Page Validation

CREATING USER CONTROLS

• Adding User Controls to an ASP.NET Web Form
• Creating User Controls
• More ....dependant on timing

ACCESSING RELATIONAL DATA WITH VISUAL STUDIO.NET:

• Overview of ADO.NET
• Creating a Connection to the Database
• Displaying a DataSet in a List-Bound Control
• Overview in preparation for ADO.NET modules

READING, WRITING AND CONSUMING XML WEB SERVICES

• Overview of Using XML Web Services
• Calling an XML Web Service by HTTP
• Using a Proxy to Call an XML Web Service
• Creating an XML Web Service

ACCESSING RELATIONAL DATA WITH ADO.NET - (Introduction)

• Overview of ADO.NET
• Creating a Connection to the Database
• Displaying a DataSet in a List-Bound Control

ACCESSING DATA WITH MICROSOFT ADO.NET

• Connecting to a Database
• Accessing Data with DataSets
• Using Multiple Tables
• Accessing Data with DataReaders

CALLING STORED PROCEDURES WITH ADO.NET

• Overview of Stored Procedures
• The instructor may choose to cover ADO.NET material from later in the course at this time.

READING AND WRITING XML DATA:

• Overview of XML Architecture in ASP.NET
• XML and the DataSet Object
• Working with XML Data
• Using the XML Web Server Control

CONSUMING AND CREATING XML WEB SERVICES

• Overview of Using XML Web Services
• Calling an XML Web Service by HTTP
• Using a Proxy to Call an XML Web Service
• Creating an XML Web Service

MANAGING STATE

• State management
• Application and Session Variables
• Cookies and Cookieless Sessions

CONFIGURING, OPTIMISING, AND DEPLOYING A ASP.NET WEB APPLICATION

• Using the Cache Object
• Using ASP.NET Output Caching
• Configuring an ASP.NET Web Application
• Deploying an ASP.NET Web Application

HELPING TO PROTECT A MICROSOFT ASP.NET WEB APPLICATION

• Web Application Security Overview
• Working with Windows-Based Authentication
• Working with Forms-Based Authentication
• Overview of Microsoft Passport Authentication

CONNECTING TO DATA SOURCES:

• Working in a Connected Environment
• Defining a Connection
• Managing a Connection
• Handling Connection Exceptions
• Connection Pooling

PERFORMING CONNECTED DATABASE OPERATIONS

• Working in a Connected Environment
• Building Command Objects
• Executing Commands That Return a Single Value
• Executing Commands That Return Rows
• Executing Commands That Do Not Return Rows
• Using Transactions

BUILDING DATASETS

• Working in a Disconnected Environment
• Building DataSets and DataTables
• Binding and Saving a DataSet
• Defining Data Relationships
• Modifying Data in a DataTable
• Sorting and Filtering

READING AND WRITING XML WITH ADO.NET

• Creating XSD Schemas
• Loading Schemas and Data into DataSets
• Writing XML from a DataSet

BUILDING DATASETS FROM EXISTING DATA SOURCES

• Configuring a DataAdapter to Retrieve Information
• Populating a DataSet Using a DataAdapter
• Configuring a DataAdapter to Update the Underlying Data Source
• Persisting Changes to a Data Source
• How to Handle Conflicts

BUILDING AND CONSUMING A WEB SERVICE THAT USES ADO.NET

• Building and Consuming a Web Service That Returns Data

ASP.NET 1.x: Bundle: MS2310 + MS2389 / MS23102389