Microsoft VB.NET Training

Introduction to ADO.NET

• What is .NET?
• VB.NET Application Types
• Windows Programming Overview

Object Oriented Programming

• Buzzwords
• Classes and Objects
• Properties, Modifiers, Methods, Namespaces and Events
• Constructors and Destructors

Forms

• Forms and Control Events
• Sample Applications

Mathematical and Relational Operators

• Overview
• Sample Application
• Additional Math and Relational Operators
• The Order of Precedence

Introduction to VS.NET

• The VS.NET Start Page
• VS.NET Application Templates
• VS.NET Productivity Feature

Controls

• Control Types
• Forms and Controls
• Control Properties
• Radio Button, Check Box and Picture Box Controls

Variable Types

• Assigning Values to Variable Types
• Sample Applications

Flow Control and Logic Structures

• If..Then
• Select Case
• Compiler Directives
• Looping
• With..End With

Arrays and Constants

• Arrays
• Using Arrays
• Creating Your Own Arrays
• Miscellaneous Array Topics
• Multi-dimensional Arrays
• Constants

DataBinding on Windows Forms

• ADO.NET Data Binding
• Binding Data to a DataGrid
• Working with Combo Boxes
• Displaying Data Based on a Parameterized Query
• Manually Binding Data
• What's Different from VB

Methods

• The VS.NET Start Page
• VS.NET Application Templates
• VS.NET Productivity Features
• Functions
• Parameters
• Calling By Value Versus by Reference
• Optional Arguments
• Built-in Methods on Data Types

Introduction to ADO.NET

• Getting Started with ADO.NET
• Benefits of ADO.NET

Creating Classes

• Overview
• Creating a Class
• Creating Properties
• Passing Data to a Constructor
• Namespace

The MessageBox Class

• Working with MessageBox

Working with MDI Forms

• MDI Overview
• Creating an MDI Project
• Creating Menus
• Working with MDI Child Forms
• Creating Popup Menus
• Manipulating Menus at Runtime

The StringBuilder Class

• Introduction to StringBuilder
• Using the StringBuilder Class

Creating Dialog Forms

• Creating Dialog Box Forms

Introduction to Web Forms

• Overview of ASP.NET and Web Forms
• Creating a Web Form

Debugger

• Breakpoints and Stepping
• Breakpoint Window
• Setting the Next Statement and Watching Variables
• Command Window, Call Stack and Other Misc. Windows
• Debug Object

Collection Classes

• Array Lists
• Hasthtables
• Queues and Stacks

Exception Handling

• No Exception Handling and Simple Exception Handling
• Catching Specific Exceptions
• Throwing Exceptions
• The Finally Block
• Inner Exceptions
• Custom Exceptions

Variables

• Introduction to Data Types
• Assigning Values to Variables

Value and Reference Types

• Creating Value and Reference Types
• Passing Value and Reference Types
• Strings - Both Value and Reference!

Data Type Conversations

• Introduction to Option Strict
• Implicit and Explicit Conversations
• The C Family of Conversations
• The C Type Command

Arrays

• Simple Arrays
• Multidimensional Arrays
• Jagged Arrays

Adding Events

• Introduction
• Multiple Event Handlers
• The e Parameter

Working With Classes

• Classes with Events
• Multicast Classes
• All Together Classes

Working With Delegates

• Simple Delegates
• The Delegate Parameters
• Event Like Delegates
• Multi Cast Delegates

Multithreaded Applications

• The Timer
• Sleep
• Launching a Thread
• The Slow Thread
• The Call Back
• Write After Write
• Helpful VB.NET Tools for Threading

Creating Classes

• Defining Classes
• Encapsulation and Information Hiding
• Adding Field and Property Members
• Adding Methods to Classes
• Adding Class Events
• defining nested Classes
• Creating Instances of a Class

Shared Members

• Declaring Shared Fields
• Defining Shared Properties
• Using Shared Methods
• Defining shared Constructors

Inheritance and Polymorphism

• Inheritance Basics
• What is Inheritance
• Defining Classes that Must be Sub Classed
• Defining classes that Cannot be Sub Classed
• Polymorphism
• Dynamic typecasting
• Defining interfaces

Working with the Visual Database Tools in .NET

• Introduction to the Visual Studio.NET Database Tools
• Using the Database Designer
• Using the Query Designer
• Using the SQL Editor
• Using the Component Designer
• Using the XML Designer

Working with the Visual Database Tools in .NET

• Exploring the Benefits of ADO.NET
• Getting to Know the ADO.NET Object Model
• Getting to Know the System.Data Namespace
• Working with the .NET Data Providers
• Introducing the ADO.NET Connection Object
• Introducing the ADO.NET Command Object
• Introducing the ADO.NET DataAdapter Object
• Introducing the ADO.NET DataSet Object
• Introducing the ADO.NET DataTableObject
• Introducing the ADO.NET DataView Ojbect
• Introducing the ADO.NET DataReader Object
• Editing Data with ADO.NET

Working with Data Aware Controls

• Simple Data Binding
• Complex Data Binding
• The Data form Wizard
• The Drop-down List Web Control
• The CheckBoxList Web Control
• The RadioButtonList Web Control
• The ListBox Control
• The DataGrid Control
• The Repeater Web Control
• The DataList Web Control
• The ComboBox Windows Control
• The CheckedListBox Windows Control

ADO.NET and Stored Procedures

• Benefits of using Stored Procedures
• Creating and Working with Stored Procedures in Visual Studio.NET
• Using ADO.NET to Execute Stored Procedures
• Using Stored Procedures to Retrieve Data
• Using Stored Procedures to Modify Data

Basics of Working with the DataGrid Control

• Benefits of the DataGrid Control
• Loading the DataGrid Control with Data
• DataGrid Control Properties
• Formatting Data in a DataGrid Control
• Working with Columns in a DataGrid Control
• Enabling Paging on a DataGrid Control
• Allowing the User to Select a Row on a DataGrid Control
• Sorting Grid Columns

Expanding Your Knowledge of the DataGrid Control

• Adding a Hyperlink Column
• Allowing the user to Edit Data on a Detail Page
• Allowing the User to Edit Data in the Grid
• Adding a Template Column
• Allowing the User to Add New Rows
• Allowing the user to Delete Data

Basics of Working with the DataGrid Control

• Working with the DataSource Property
• Overview of the Repeater Control Templates
• Adding the Item Template
• Adding the HeaderTemplate and the FooterTemplate
• Adding the AlteratingItem Template
• Adding the SeparatorTemplate
• Adding Hyperlinks and Other Embedded Controls
• Working with the itemCommand Event Procedure

Expanding Your Knowledge of the DataGrid Control

• Working with the DataSource Property
• Adding the itemTemplate
• Adding the AlternatingItemTemplate
• Adding the HeaderTemplate and the Footer Template
• Adding the Selecteditem Template
• Adding the Seperator Template
• Adding the EdititemTemplate Section
• Working with the DataList Control's Properties
• Adding Event Handling code

Advanced Dataset Features

• Adding Primary Keys to DataTables
• Adding AutoIncrement Columns to Data Tables
• Adding Constraints to DataTables
• Adding Foreign Keys to DataTables
• Establishing Relationships Between DataTables
• Enforcing Referential integrity Between Data Tables
• Using the DataTable Original, Current AND Proposed Values
• Getting Only The Changed Rows From A Data Table
• Using DataAdapters With CommandBuilders

Working With XML

• XML Introduced
• XML vs. HTML
• How To Represent Related Data
• Document Type Definition Files
• XML Schema
• XPath
• XSLT Transformations

ADO.NET and XML

• Working With XML in Design View
• Creating XML From DataSets
• Reading XML Into A DataSet

Web Services

• Create A Simple Web Service
• Adding Parameters To The Web Service
• Consuming A Web Service
• Web Service Proxy Class
• Web Services That Returns A DataSet
• Consuming A DataSet to a WEB Service
• Passing A DataSet To A Web Service
• Web Service Security