Fastrack2C#.NET - Part 2: Windows Application Development & Data Access with C#

Course Details:

• Days: 5
• Course Code: MS25552389
• Booking: Please ring 08450 50 45 05

Overview

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 move over to C# development 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.

Leads to examination

• 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#™ .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
Familiarity with Microsoft's .NET strategy as described on:

Microsoft's .Net Web site

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 knowledg

Delegates will learn how to

• Debug a Windows Forms application
• Incorporate accessibility features in a Windows Forms application
• Implement code access and role-based security in a Windows Forms application
• Connect to SQL Server and other data sources
• Build a DataSet from an existing data source
• Consume XML Web services from Windows Forms applications
• Create and populate Windows Forms
• Organize controls on Windows Forms
• Create menus in a Windows Forms application
• Add code to form and control event procedures in a Windows Forms application
• 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
• Bind Windows Forms applications to various data sources by using Microsoft ADO.NET
• Use .NET and COM components in a Windows Forms application
• Make asynchronous calls to methods from 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
• Build a DataSet schema, populate it with data, and modify the data programmatically
• Create Multiple Document Interface (MDI) applications
• Call Microsoft Win32® APIs from a Windows Forms application
• Print documents in a Windows Forms application
• Localize a Windows Forms application
• Add support for Help to localize a Windows Forms application
• 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
• Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments
• Build a Web service that uses ADO.NET to query and update a data source.
• Troubleshoot errors within an ADO.NET application
  

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

  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