VB.NET Fundamentals Phase I � Paul Sheriff
- 1.0 Introduction to ADO.NET
- 1.1 What is .NET?
- 1.2 VB.NET Application Types
- 1.3 Windows Programming Overview
- 2.0 Introduction to VS.NET
- 2.1 The VS.NET Start Page
- 2.2 VS.NET Application Templates
- 2.3 VS.NET Productivity Features
- 3.0 Object Oriented Programming
- 3.1 Buzzwords
- 3.2 Classes and Objects
- 3.3 Properties, Modifiers, Methods, Namespaces and Events
- 3.4 Constructors and Destructors
- 4.0 Controls
- 4.1 Control Types
- 4.2 Forms and Controls
- 4.3 Control Properties
- 4.4 Radio Button, Check Box and Picture Box Controls
- 5.0 Forms
- 5.1 Forms and Control Events
- 5.2 Sample Applications
- 6.0 Variable Types
- 6.1 Assigning Values to Variable Types
- 6.2 Sample Applications
- 7.0 Mathematical and Relational Operators
- 7.1 Overview
- 7.2 Sample Application
- 7.3 Additional Math and Relational Operators
- 7.4 The Order of Precedence
VB.NET Fundamentals Phase II � Alison Balter
- 1.0 Flow Control and Logic Structures
- 1.1 If..Then
- 1.2 Select Case
- 1.3 Compiler Directives
- 1.4 Looping
- 1.5 With..End With
- 2.0 Methods
- 2.1 The VS.NET Start Page
- 2.2 VS.NET Application Templates
- 2.3 VS.NET Productivity Features
- 2.4 Functions
- 2.5 Parameters
- 2.6 Calling By Value Versus by Reference
- 2.7 Optional Arguments
- 2.8 Built-in Methods on Data Types
- 3.0 Arrays and Constants
- 3.1 Arrays
- 3.2 Using Arrays
- 3.3 Creating Your Own Arrays
- 3.4 Miscellaneous Array Topics
- 3.5 Multi-dimensional Arrays
- 3.6 Constants
- 4.0 Introduction to ADO.NET
- 4.1 Getting Started with ADO.NET
- 4.2 Benefits of ADO.NET
- 5.0 DataBinding on Windows Forms
- 5.1 ADO.NET Data Binding
- 5.2 Binding Data to a DataGrid
- 5.3 Working with Combo Boxes
- 5.4 Displaying Data Based on a Parameterized Query
- 5.5 Manually Binding Data
- 5.6 What�s Different from VB 6.0
VB.NET Fundamentals Phase III � Alison Balter
- 1.0 Creating Classes
- 1.1 Overview
- 1.2 Creating a Class
- 1.3 Creating Properties
- 1.4 Creating Methods
- 1.5 Passing Data to a Constructor
- 1.6 Namespace
- 2.0 The StringBuilder Class
- 2.1 Introduction to StringBuilder
- 2.2 Using the StringBuilder Class
- 3.0 The MessageBox Class
- 3.1 Working with MessageBox
- 4.0 Creating Dialog Forms
- 4.1 Creating Dialog Box Forms
- 5.0 Working with MDI Forms
- 5.1 MDI Overview
- 5.2 Creating an MDI Project
- 5.3 Creating Menus
- 5.4 Working with MDI Child Forms
- 5.5 Creating Popip Menus
- 5.6 Manipulating Menus at Runtime
- 6.0 Introduction to Web Forms
- 6.1 Overview of ASP.NET and Web Forms
- 6.2 Creating a Web Form
VB.NET Desktop Development Phase I � Bruce Jones
- 1.0 Debugger
- 1.1 Breakpoints and Stepping
- 1.2 Breakpoint Window
- 1.3 Setting the Next Statement and Watching Variables
- 1.4 Command Window, Call Stack and Other Misc. Windows
- 1.5 Debug Object
- 2.0 Exception Handling
- 2.1 No Exception Handling and Simple Exception Handling
- 2.2 Catching Specific Exceptions
- 2.3 Throwing Exceptions
- 2.4 The Finally Block
- 2.5 Inner Exceptions
- 2.6 Custom Exceptions
- 3.0 Collection Classes
- 3.1 Array Lists
- 3.2 Hasthtables
- 3.3 Queues and Stacks
VB.NET Desktop Development Phase II � Bruce Jones
- 1.0 Variables
- 1.1 Introduction to Data Types
- 1.2 Assigning Values to Variables
- 2.0 Data Type Conversations
- 2.1 Introduction to Option Strict
- 2.2 Implicit and Explicit Conversations
- 2.3 The C Family of Conversations
- 2.4 The C Type Command
- 3.0 Value and Reference Types
- 3.1 Creating Value and Reference Types
- 3.2 Passing Value and Reference Types
- 3.3 Strings � Both Value and Reference!
- 4.0 Arrays
- 4.1 Simple Arrays
- 4.2 Multidimensional Arrays
- 4.3 Jagged Arrays
VB.NET Desktop Development Phase III � Bruce Jones
- 1.0 Adding Events
- 1.1 Introduction
- 1.2 Multiple Event Handlers
- 1.3 The e Parameter
- 2.0 Working With Delegates
- 2.1 Simple Delegates
- 2.2 The Delegate Parameters
- 2.3 Event Like Delegates
- 2.4 Multi Cast Delegates
- 3.0 Working With Classes
- 3.1 Classes with Events
- 3.2 Multicast Classes
- 3.3 All Together Classes
- 4.0 Multithreaded Applications
- 4.1 The Timer
- 4.2 Sleep
- 4.3 Launching a Thread
- 4.4 The Slow Thread
- 4.5 The Call Back
- 4.6 Write After Write
- 4.7 Helpful VB.NET Tools for Threading
VB.NET Desktop Development Phase IV � Alison Balter
- 1.0 The Code Behind the Form
- 1.1 Switching from Code View to Object View
- 1.2 Namespaces
- 1.3 Code Outlining
- 1.4 The #Region Directive
- 1.5 Code Editing and Documentation
- 2.0 Configuring the IDE
- 2.1 Exploring the IDE Options
- 3.0 Automating Repetitive Tasks with Macros
- 3.1 Recording a Macro
- 3.2 Viewing a Recorded Macro
- 3.3 Editing a Macro
- 3.4 Running a Macro
- 3.5 Using the Macro Explorer
- 3.6 Exporting a Macro
- 3.7 Using the Macro IDE
- 3.8 Creating a Macro Project
- 3.9 Responding to IDE Events
VB.NET Desktop Development Phase V � Alison Balter
- 1.0 Creating Classes
- 1.1 Defining Classes
- 1.2 Encapsulation and Information Hiding
- 1.3 Adding Field and Property Members
- 1.4 Adding Methods to Classes
- 1.5 Adding Class Events
- 1.6 defining nested Classes
- 1.7 Creating Instances of a Class
- 2.0 Inheritance and Polymorphism
- 2.1 Inheritance Basics
- 2.2 What is Inheritance
- 2.3 Defining Classes that Must be Sub Classed
- 2.4 Defining classes that Cannot be Sub Classed
- 2.5 Polymorphism
- 2.6 Dynamic typecasting
- 2.7 Defining interfaces
- 3.0 Shared Members
- 3.1 Declaring Shared Fields
- 3.2 Defining Shared Properties
- 3.3 Using Shared Methods
- 3.4 Defining shared Constructors
VB.NET Database Development Phase I � Alison Balter
- 1.0 Working with the Visual Database Tools in .NET
- 1.1 Why this Learning Module is Important
- 1.2 Introduction to the Visual Studio.NET Database Tools
- 1.3 Using the Database Designer
- 1.4 Using the Query Designer
- 1.5 Using the SQL Editor
- 1.6 Using the Component Designer
- 1.7 Using the XML Designer
VB.NET Database Development Phase II � Alison Balter
- 1.0 Working with the Visual Database Tools in .NET
- 1.1 Why this Chapter is Important
- 1.2 Exploring the Benefits of ADO.NET
- 1.3 Getting to Know the ADO.NET Object Model
- 1.4 Getting to Know the System.Data Namespace
- 1.5 Working with the .NET Data Providers
- 1.6 Introducing the ADO.NET Connection Object
- 1.7 Introducing the ADO.NET Command Object
- 1.8 Introducing the ADO.NET DataAdapter Object
- 1.9 Introducing the ADO.NET DataSet Object
- 1.10 Introducing the ADO.NET DataTableObject
- 1.11 Introducing the ADO.NET DataView Ojbect
- 1.12 Introducing the ADO.NET DataReader Object
- 1.13 Editing Data with ADO.NET
VB.NET Database Development Phase III � Alison Balter
- 1.0 Working with Data Aware Controls
- 1.1 Why this Chapter is Important
- 1.2 Simple Data Binding
- 1.3 Complex Data Binding
- 1.4 The Data form Wizard
- 1.5 The Drop-down List Web Control
- 1.6 The CheckBoxList Web Control
- 1.7 The RadioButtonList Web Control
- 1.8 The ListBox Control
- 1.9 The DataGrid Control
- 1.10 The Repeater Web Control
- 1.11 The DataList Web Control
- 1.12 The ComboBox Windows Control
- 1.13 The CheckedListBox Windows Control
- 2.0 ADO.NET and Stored Procedures
- 2.1 Benefits of using Stored Procedures
- 2.2 Creating and Working with Stored Procedures in Visual Studio.NET
- 2.3 Using ADO.NET to Execute Stored Procedures
- 2.4 Using Stored Procedures to Retrieve Data
- 2.5 Using Stored Procedures to Modify Data
Database Development Phase IV � Alison Balter
- 1.0 Basics of Working with the DataGrid Control
- 1.1 Why This Chapter is Important
- 1.2 Benefits of the DataGrid Control
- 1.3 Loading the DataGrid Control with Data
- 1.4 DataGrid Control Properties
- 1.5 Formatting Data in a DataGrid Control
- 1.6 Working with Columns in a DataGrid Control
- 1.7 Enabling Paging on a DataGrid Control
- 1.8 Allowing the User to Select a Row on a DataGrid Control
- 1.9 Sorting Grid Columns
- 2.0 Expanding Your Knowledge of the DataGrid Control
- 2.1 Adding a Hyperlink Column
- 2.2 Allowing the user to Edit Data on a Detail Page
- 2.3 Allowing the User to Edit Data in the Grid
- 2.4 Adding a Template Column
- 2.5 Allowing the User to Add New Rows
- 2.6 Allowing the user to Delete Data
VB.NET Database Development Phase V � Alison Balter
- 1.0 Basics of Working with the DataGrid Control
- 1.1 Why This Section is Important
- 1.2 Working with the DataSource Property
- 1.3 Overview of the Repeater Control Templates
- 1.4 Adding the Item Template
- 1.5 Adding the HeaderTemplate and the FooterTemplate
- 1.6 Adding the AlteratingItem Template
- 1.7 Adding the SeparatorTemplate
- 1.8 Adding Hyperlinks and Other Embedded Controls
- 1.9 Working with the itemCommand Event Procedure
- 2.0 Expanding Your Knowledge of the DataGrid Control
- 2.1 Why This Section is Important
- 2.2 Working with the DataSource Property
- 2.3 Adding the itemTemplate
- 2.4 Adding the AlternatingItemTemplate
- 2.5 Adding the HeaderTemplate and the Footer Template
- 2.6 Adding the Selecteditem Template
- 2.7 Adding the Seperator Template
- 2.8 Adding the EdititemTemplate Section
- 2.9 Working with the DataList Control�s Properties
- 2.10 Adding Event Handling code
VB.NET Database Development Phase VI � Bruce Jones
- 1.0 Advanced Dataset Features
- 1.1 Adding Primary Keys to DataTables
- 1.2 Adding AutoIncrement Columns to Data Tables
- 1.3 Adding Constraints to DataTables
- 1.4 Adding Foreign Keys to DataTables
- 1.5 Establishing Relationships Between DataTables
- 1.6 Enforcing Referential integrity Between Data Tables
- 1.7 Using the DataTable Original, Current AND Proposed Values
- 1.8 Getting Only The Changed Rows From A Data Table
- 1.9 Using DataAdapters With CommandBuilders
- 2.0 Working With XML
- 2.1 XML Introduced
- 2.2 XML vs. HTML
- 2.3 How To Represent Related Data
- 2.4 Document Type Definition Files
- 2.5 XML Schema
- 2.6 XPath
- 2.7 XSLT Transformations
VB.NET Database Development Phase VII � Bruce Jones
- 1.0 ADO.NET and XML
- 1.1 Working With XML in Design View
- 1.2 Creating XML From DataSets
- 1.3 Reading XML Into A DataSet
- 2.0 Web Services
- 2.1 Create A Simple Web Service
- 2.2 Adding Parameters To The Web Service
- 2.3 Consuming A Web Service
- 2.4 Web Service Proxy Class
- 2.5 Web Services That Returns A DataSet
- 2.6 Consuming A DataSet to a WEB Service
- 2.7 Passing A DataSet To A Web Service
- 2.8 Web Service Security