ASP.NET: Using Visual C# ADO.NET and XML

Course Specifications

Course Description

You already know how to write simple, static Web pages using HTML and perhaps Cascading Stylesheets and client-side JavaScript code. Now you are ready to create dynamic Web pages using the latest Microsoft server-side technology: ASP.NET.

• Object-Oriented ProgrammingPrinciples

• .NET FrameworkIntroduction

• HTML 4.01Level 1

• HTML 4.01Level 2

Knowledge of C#, or prior experience with C++, is also required. If you will be using VisualStudio.NET in the course, then we recommend Visual Studio.NETIntroduction, or prior experience with Visual Basic, Visual C++, or Visual InterDev. Prior experience with ASP Classic (2.0 or 3.0) is helpful, but not required. Knowledge of XML basics is also helpful, and so we recommend XMLIntroduction (Second Edition). Knowledge of SQL is also recommended, though not required.

Hardware Requirements

• PC with a Pentium II-class processor, 500 megahertz (MHz); Pentium III-class processor, 600 MHz recommended.
• A minimum of 4.0 GB hard drive is required for Windows 2000 Professional; 5.0 GB for Windows XP Professional. 8 GB or more is highly recommended.
• CD-ROM drive.
• Super VGA or higher-resolution monitor (set to at least 800 x 600 screen resolution).
• An Internet connection with access to the World Wide Web.

Platform Requirements

• Microsoft Windows 2000, Server (192 MB of RAM (min), 256 MB (recommended)); or Windows 2000, Professional (128 MB of RAM (min), 256 MB (recommended)); or Windows XP Professional (128 MB of RAM (min), 256 MB (recommended)).

Software Requirements

• Microsoft Windows 2000, Server (192 MB of RAM (min), 256 MB (recommended)); or Windows 2000, Professional (128 MB of RAM (min), 256 MB (recommended)); or Windows XP Professional (128 MB of RAM (min), 256 MB (recommended)).
• Microsoft Internet Explorer Version 6.0+.
• Netscape Navigator Version 6.2+.
• Microsoft Access 2000.
• You must install either: A complete installation of Microsoft Visual Studio.NET; or the .NET Framework SDK (available at http://msdn.microsoft.com/ or at www.asp.net).

Performance-Based Objectives

• write your first ASP.NET Web pages by using the basic features of the Page class.
• increase the separation of code from content and the modularity of your code.
• create Web forms using Web controls.
• display and modify data from a database by using ADO.NET with ASP.NET Web controls.
• manipulate and update data using ADO.NET DataSets.
• read, write, edit, and validate XML documents.
• convert and transform XML data.
• architect and configure numerous aspects of an ASP.NET application.

Course Content

Lesson 1: Writing Basic ASP.NET Pages

Topic 1A: Write a Simple ASP.NET Web Page

Topic 1B: Output Content and Redirect to a Different Page

Topic 1C: Pass User Information Between Pages

Topic 1D: Store and Retrieve Data Using a Cookie

Topic 1E: Perform Browser Detection

Topic 1F: Transfer Processing

Lesson 2: Increasing Code Separation and Modularity

Topic 2A: Separate Code From Content with HTML Controls

Topic 2B: Implement a Postback Form

Topic 2C: Increase Code Separation with a Code-Behind File

Topic 2D: Increase Modularity with a User Control

Lesson 3: Creating Web Forms with Web Controls

Topic 3A: Create a Web Form Using ASP.NET Web Controls

Topic 3B: Create Grouped Elements with List Controls

Topic 3C: Display Data with a Repeater Control

Topic 3D: Display Data with a DataList Control

Topic 3E: Display Data with a DataGrid Control

Topic 3F: Verify User Input with Validation Controls

Topic 3G: Rotate Banner Ads with the Ad Rotator Control

Topic 3H: Create a Calendar using a Calendar Control

Lesson 4: Accessing Databases with ADO.NET

Topic 4A: Display Data from a Database

Topic 4B: Display Data From a Database Using Web Controls

Topic 4C: Customize Databound Results Using Style Sections

Topic 4D: Customize Databound Results Using Templates

Topic 4E: Modify Data with SQL Commands

Lesson 5: Manipulating Data with ADO.NET DataSets

Topic 5A: Create a DataSet with Multiple Tables

Topic 5B: Display Data from Related Tables

Topic 5C: Manipulate Data in a DataGrid Control

Topic 5D: Modify DataSet Records and Merge

Lesson 6: Programming XML Documents with ASP.NET

Topic 6A: Access and Display an XML Document

Topic 6B: Validate an XML Document Using a Schema

Topic 6C: Search an XML Document for Specific Information

Topic 6D: Edit an XML Document

Topic 6E: Write XML Documents to Disk

Lesson 7: Converting and Transforming XML Data with ASP.NET

Topic 7A: Write Data From a DataSet to an XML Document

Topic 7B: Create Nested XML from a DataSet Object

Topic 7C: Read Data into a DataSet from an XML Document

Topic 7D: Transform an XML Document

Topic 7E: Output XSLT Results Using the XML Control

Lesson 8: Architecting and Configuring an ASP.NET Application

Topic 8A: Configure an ASP.NET Application

Topic 8B: Configure ASP.NET Error Tracing

Topic 8C: Manage Application State

Topic 8D: Preserve Session State

Topic 8E: Cache Page Output

Topic 8F: Cache a User Control