Microsoft C#.NET Training

Introduction to C#

• Why Use the C# Language
• Creating a C# Application
• Adding Comments
• Basic Data Types
• Code Editor
• Constants
• Converting Variable Types
• Enumerations
• Source Code Formatting Issues

Operators

• Overview
• Mathematical Operators
• AND or OR Operators
• C# Conditional Operator
• Bit Shifting Operator
• Short Circuiting
• C# Compound Assignment Operator

Conditions, Classes, Methods, and Constructs

• Looping and Branching Constructs and the IF Condition
• ELSE IF Clause
• Code Blocks
• Switch Statement
• Creating and Calling Methods
• FOR and While Constructs

Objects & Classes

• Objects and Classes
• Methods
• Constructor
• THIS Keyword
• NEW Keyword
• STATIC Members
• Stack and Heap Oriented Objects
• OUT KeyWord
• Static Constructor
• Private Default Constructor

More on Operators

• Operator Overloading Capabilities
• Operator Functionality to User Defined Classes
• Overloading Relational Operators
• Unreadable or Non-Maintainable Code

Methods

• Inheritance
• Boxing
• Virtual Keyword
• Abstract Classes and Abstract Methods
• One Version of a Constructor Calling Another
• Derived Class Method Calling a Base Class Method

The Finer Points of the .NET Base Framework

• Interfaces
• Extending the Interface
• Mixing and Matching Interfaces
• How to Determine if any Other Interfaces are Implemented
• Two Interfaces With a Common Member Name
• Hiding the Members When an Object of the Class is Created

Managing Arrays

• Utilizing the Foreach Loop
• Arraylist
• Sorting Items in an Arraylist

Arrays

• Creating and Array
• The Foreach Loop
• Filling Arrays with Data
• Multidimensional Arrays
• Throwing Exceptions
• Populating Multidimensional Arrays
• Creating Jagged Arrays
• Accepting an Array of Parameters
• Object Mimicking Arrays
• Text Files
• Non-standard Array Manipulation Features

Delegates

• Introduction
• Instance and Static
• Passing Delegates
• Multicast Delegates
• Static Members

Errors

• Start Page-User Profile
• Setting Breakpoints and Viewing and Modifying Their Properties
• Stepping Through the Program
• Watch Variables
• The Immediate Window and Other Windows
• Debug Class
• Hard Coding Checks (Debug. Assert)
• Conditional Compilation
• Debug Write Methods

Events

• Creating a Set of Classes that Publish and Subscribe to Events
• Adding the Additional Parameters (System.EventArgs)
• Event Handlers and Event Publishers

Exception Handling

• Non-Trapped Error
• Try Catch Block
• Determining the Type of Exception
• Creating Methods that can Throw an Exception
• Finally Block
• Innerexception
• Creating A User-Defined Exception Class

Introduction to ADO.NET

• Creating an OleDb And SQLClient Connection
• Using the IDbConnection Interface
• Start The Data Access Class Library
• Executing Action Queries With The Command Object
• Executing Scalar Queries With The Command Object
• The Different Scalar Return Types
• Add The Command Object To The Class Library

Parameterized Queries

• Introduction
• A Query With Multiple OleDb Parameters
• Solving The String Delimiter Problem
• A Query Wit hMuyltiple SqlClient Parameters
• Add Parameterized Queries To The Class Library

The Datareader Class

• Introduction
• Get Data by Ordinal Position
• Get Specific Data Types
• Automatically Close The Connection
• Get One Row of Data
• Read Columns Sequentially
• Combine Multiple Command Behaviors
• Return Multiple Result Sets
• Add The Datareader To The Class Library
• Nested Data Readers

Stored Procedures

• Introduction
• OleDb Stored Procedures With One Parameter
• OleDb With Inputs, Outputs, And Return Values
• OleDb Alternate Syntax
• SqlClient With Inputs, Outputs, And Return Value

Introduction to DataTables

• Introduction to Data Tables
• Adding DataColumns
• Adding DataRows
• Adding Primary Keys
• Adding Unique Constraints
• Adding Multi Column Constraints
• Adding Read Only Columns
• Allow Null Values in Selected Columns
• Set A Max Length For Text Columns
• Use An Autoincrement For a Primary Key
• Add A Calculated Column
• Calculations Based On a Group of Rows

Introduction to DataSets

• Introduction to DataSets
• Adding DataTables To A DataSets
• Foreign Key Constraints
• Cascading Updates
• Enforce Referential Integrity
• Null Values in Foreign Keys
• Adding Relationships
• Using Relationships To Get Child Rows
• Using Relationships to Get Parent Row

DataTable Row

• Find a Data Table Row Using The Primary Key
• Selecting A Set of Rows
• Using The RowState Property
• The BeginEdit. EndEdit, and CancelEdit Methods
• Using The RowVersions
• Selecting Rows Using RowVersion
• Row Version With BeginEdit and EndEdit
• Create one DataTable From Another
• Using DataViews

Introduction to DataAdapters

• Introduction To DataAdapters
• Filling a DataSet
• TableMappings
• TableMapping Pass Through Fields
• TableMapping Blocked Fields
• Throw An Exception For Unmapped Fields
• Get A DataSet From The Class Library

Working with Data Adapter

• Update Data with Data Adapter
• Insert and Delete Data with Data Adapter
• Save Changes Without a Data Adapter
• Save Changes Using Stored Procedures
• Dealing with Concurrency Issues
• Detecting a Failed Concurrency Issue
• Using Transactions

Using Data Application Block

• Introducing the Data Access Application Block
• Examining the DAAB Help File
• Adding the DAAB to a Project and Creating a Simple Dataset
• Create a Wrapper Around the DAAB
• Using Stored Procedures to Create Dataset
• A Stored Procedure Parameter Wrapper
• Wrapper Class Code Generator

Using Visual Database Tools

• Introduction to the Visual Database Tools
• Adding a DataAdapter Using the Visual Tools
• Using the DataAdapter to Fill a DataSet
• The Problem With Regular DataSets
• Solving The Problem With Typed DataSets
• The Problem With Typed DataSets
• Using The Visual Tools vs. Programming