Course Objectives

After completing this course, students will be able to:

·       Describe data – centric applications, ADO .Net architecture, and ADO .Net and XML

·       Connect to SQL server and other data sources

·       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 web service that uses ADO .Net to query and update a data source.

·       Troubleshoot errors within an ADO .Net application.

Prerequisites

The course assumes that students have the following skills:

·       Understanding of C# programming

·       Experience building applications

Course Track

Lesson 1: Create Windows Forms by using windows forms designer

• Add and set properties on windows forms
• Create a windows form by using a visual interface
• Build graphical interface elements by using the system.drawing namespace.

Lesson 2: AddControls to windows forms

• Set properties on controls
• Load controls dynamically
• Write code to handle control events and add the code to a control
• Create menus and menu items

Lesson 3: Implementerror handling in the UI

• Create and implement custom error messages
• Create and implement custom error handlers
• Raise and handle errors

Lesson 4:  Creating and Managing components and .Netassemblies

• Create and modify a .Net assembly
• Create a Windows Control

Lesson 5:  Consuming and Manipulating Data

• Access and manipulate data from a Microsoft SQL Server™ database by creating and using ad hoc queries and stored procedures.
• Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO .NET.
• Handle data errors.

Lesson 6: Testing andDebugging

• Create a unit test plan
• Add trace listeners and trace switches to an application
• Display trace output
• Configure the debugging environment
• Create and apply Debugging code to components and applications.

Lesson 7: Deploying aWindows – Based application

• Plan the deployment of windows based application
• Create a setup program that installs the application and allows for the application to be uninstalled
• Deploy a windows – based application
• Add assemblies to global assembly cache
• Verify security policies for a deployed application

Lesson 8: Maintainingand supporting windows based application

• Optimize the performance of a Windows-based application.
• Diagnose and resolve errors and issues.

Lesson 9:  Configuring and Securing a Windows-basedApplication

• Configure a Windows-based application.
• Configure security for a Windows-based application.
• Configure authorization.

Course Benefits

Students will be prepared to work with ADO .Net and to connect with Microsoft SQL Server Database.  Students will learn the skills and techniques to work with .Net programs and to design and implement advanced Database Structures.

Course Duration

This course is covered in 40 hours of Hands -on instructor led training sessions.