Fastrack2.NET – Part 2: Windows Application Development & Data Access with Visual Basic.NET 5 Days £1,395    
 
 
Target Audience:

This five-day instructor-led course forms part of the Fastrack2.NET programme. By combining Microsoft Official Curriculum with a focused and accelerated delivery, an individual can gain a deep understanding of .NET technologies in the shortest possible time. With a quicker pace of delivery, these courses are designed for individuals with existing Visual Basic experience who need to start developing with Microsoft .NET. By reducing the time to acquire sound .NET skills, we provide greater flexibility and reduced cost of platform migration.

This course combines an accelerated schedule of learning, and will help Visual Basic programmers migrate their skills to Visual Basic.NET by providing the skills required to build Microsoft Windows Forms applications using the Microsoft .NET Framework. In addition, the course covers building data-centric applications and Web services with ADO.NET and SQL Server.

This course covers many of the objectives of the Microsoft MCP, MCAD or MCSD certification programmes exam 70-306

Prerequisites:

Before attending this course, students must:

  • Have experience developing applications with Visual Basic 4.0 or later

  • Be familiar with Microsoft's .NET strategy

  • Understanding of relational database concepts such as table, row, column, primary keys, foreign keys, constraints and views.

  • Completed Fastrack2.NET Part 1 or have equivalent knowledge.

 

MOC Course Number: 25652389
Course Outline

CONTROLS AND FORMS REVIEW

BUILDING CONTROLS:

The following areas are covered:

Extending and Creating Controls

Adding Design-Time Support for Controls

Licensing a Control

USING DATA IN WINDOWS FORMS APPLICATIONS:

The following areas are covered:

Adding ADO.NET Objects to and Configuring ADO.NET Objects in a Windows Forms Application

Accessing and Modifying Data by Using DataSets

Binding Data to Controls

Overview of XML Web Services

Creating a Simple XML Web Services Client

Persisting Data

INTEROPERATING WITH MANAGED OBJECTS:

The following areas are covered:

Using .NET and COM Components in a Windows Forms Application

Calling Win32 APIs from Windows Forms Applications

Upgrading Visual Basic 6.0 Applications to Visual Basic .NET

PRINTING AND REPORTING IN WINDOWS FORMS APPLICATIONS:

The following areas are covered:

Printing From a Windows Forms Application

Using the Print Preview, Page Setup, and Print Dialogs

Constructing Print Document Content by Using GDI+

Creating Reports by Using Crystal Reports

ASYNCHRONOUS PROGRAMMING:

The following areas are covered:

The .NET Asynchronous Programming Model

The Asynchronous Programming Model Design Pattern

How to Make Asynchronous Calls to Any Method

Helping Protect State and Data in a Multithreaded Environment

ENHANCING THE USABILITY OF APPLICATIONS:

The following areas are covered:

Adding Accessibility Features

Adding Help to an Application

Localizing an Application

DEPLOYING WINDOWS FORMS APPLICATIONS:

The following areas are covered:

.NET Assemblies

Deploying Windows Forms Applications

SECURING WINDOWS FORMS APPLICATIONS:

The following areas are covered:

Security in the .NET Framework

Using Code Access Security

Using Role-Based Security

CONNECTING TO DATA SOURCES:

The following areas are covered:

Working in a Connected Environment

Defining a Connection

Managing a Connection

Handling Connection Exceptions

Connection Pooling

PERFORMING CONNECTED DATABASE OPERATIONS:

The following areas are covered:

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:

The following areas are covered:

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:

The following areas are covered:

Creating XSD Schemas

Loading Schemas and Data into DataSets

Writing XML from a DataSet

BUILDING DATASETS FROM EXISTING DATA SOURCES:

The following areas are covered:

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:

The following areas are covered:

Building and Consuming a Web Service That Returns Data

Delegates will learn how to

  • Implement code access and role-based security in a Windows Forms application
  • Connect to SQL Server and other data sources
  • Bind Windows Forms applications to various data sources by using Microsoft ADO.NET
  • Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments
  • Add code to form and control event procedures in a Windows Forms application
  • Print documents in a Windows Forms application
  • Debug a Windows Forms application.
  • Localize a Windows Forms application
  • Create Help files in a Windows Forms application
  • Deploy a Windows Forms application
  • Add deployment flexibility to applications by using shared assemblies
  • Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML
  • 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
  • Build a DataSet schema, populate it with data, and modify the data programmatically
  • 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
  • Migrate Visual Basic 6.0 applications to Visual Basic .NET
  • Make asynchronous calls to methods from a Windows Forms application
  • Add support for Help to localize a Windows Forms application
  • Create and populate Windows Forms
  • Organize controls on Windows Forms
  • Create menus in a Windows Forms application
  • Create Multiple Document Interface (MDI) applications
  • Use dialog boxes in Windows Forms applications
  • Validate user input in a Windows Forms application
  • Create and use user controls in a Windows Forms application
  • Create licenses for controls
  • Consume XML Web services from Windows Forms applications
  • Use .NET and COM components in a Windows Forms application
  • Call Microsoft Win32® APIs from a Windows Forms application