LearnKey Training

VB.NET 1.2 for Developers Part 2 Course

VB.NET 1.2 for Developers Part 2 Course

Back to Product Page


VB.NET 1.2 for Developers Part 2 Course

8 Sessions -
21 Hours of Interactive Training

In the VB.NET 1.2 for Developers Part 2 course from LearnKey, expert instructors Andy Baron, Mary Chipman and Ken Getz continue their instruction begun in Part 1. Existing application developers who want to make the transition to developing for .NET will learn skills needed to employ this major upgrade to Visual Basic to use XML web services and access data from database records.

Benefits
  • Increase earning potential with IT programming knowledge
  • Demonstrate your IT proficiency and technical mastery
  • Gain new skills in a useful, productive manner

About The Author
Andy Baron is a Senior Consultant with MCW Technologies, a contributing editor for Advisor Media and for Pinnacle Publications, a writer for SQL Server Magazine, and co-author of the Microsoft Access Developer's Guide to SQL Server. Since 1995, Andy has been selected each year as a Microsoft MVP.
Ken Getz is a senior consultant with MCW Technologies and a Microsoft MVP. Getz has written for MSDN, Visual Basic Programmer's Journal, asp.netPRO, Access-VB-SQL Advisor, MSOfficePro, and SQL Server Magazine. He speaks regularly at industry conferences, including Microsoft's Tech-Ed and DevDays, and DevConnections, VBITS, and Advisor Devcon.
Mary Chipman and Andy Baron are Senior Consultants with MCW Technologies and both are Microsoft MVPs specializing in database application development and writing about SQL Server, Visual Basic, the .NET framework, and related technologies. They are co-authors of the Microsoft Access Developer's Guide to SQL Server, published by Sams.

Session 1

Section A: ADO.NET

  • Overview
  • ADO.NET Classes
  • OleDb vs. SqlClient
  • System.Data
  • ADO.NET Architecture
  • Presentation Tier
  • DataTable Object
  • Filling a DataTable

Section B: Connections / Commands

  • Connect to Data Source
  • Set Up Connections
  • Make the Connections
  • Commands
  • Command Object
  • DataReader
  • SqlDataReader
  • Close Connections

Section C: Working with Data

  • DataAdapter Object
  • DataSet Object
  • Filling a DataSet
  • OleDb DataSet
  • Iterate Rows and Bind
  • Rows and Columns
  • Using SqlDataAdapter
  • Iterate Columns

Section D: ADO.NET Providers

  • Choosing a Provider
  • SQL Data Provider
  • OLE DB Provider
  • ODBC Data Provider
  • Multiple Providers
  • Use Interface Inheritance
  • ReadData Procedure
  • Using IDataReader

Section E: Using COM Objects

  • How COM Works
  • .NET Advantages
  • CLR vs. COM
  • Runtime Callable Wrapper
  • Use VB6 COM Object

Section F: Support Data to Excel

  • Send to COM Object
  • Send Data to Excel
  • ReleaseComObject
  • Explicitly Declare / Release

Section G: Platform Invocation Services

  • Overview
  • Create Wrapper Class
  • Call Wrapper Class

Session 2

Section A: COM Callable Wrapper

  • Overview
  • Create COM Object
  • Set Properties
  • Calling .NET

Section B: DataBinding Basics

  • .NET DataBinding
  • Setting Up DataSource
  • Data Adapter Wizard
  • Generating a DataSet
  • Bind DataGrid Control
  • Add Fill Method

Section C: Limiting Results

  • Query by Form
  • Generate DataAdapter
  • Categories DataSet
  • Bind / Fill ComboBox
  • Create Parameter Query
  • ComboBox Categories

Section D: Data Navigation

  • Context and Navigation
  • Set Properties
  • BindingContext
  • Run Navigation Buttons
  • Binding Alternatives

Section E: Data Form Wizard

  • Overview
  • Build from DataSet
  • Run / Load Form
  • Add / Bind Controls
  • Bind Control in Code
  • Bind Control to Controls

Section F: Review Classic ASP

  • Overview
  • ASP Example
  • Data Access Code
  • ASP Object Model
  • View Example
  • Handling ASP Postbacks
  • Mixing Code & HTML
  • Generated HTML

Section G: ASP vs. ASP.NET

  • Overview
  • Loosely-typed Code
  • Limited Tools
  • Obscure Settings
  • Compiled Code
  • XML-based Files
  • Automatic Handling

Section H: Create ASP.NET Application

  • Create New Project
  • Web Form Layout
  • HTML View
  • Edit Control Properties
  • Code Window
  • Edit Code
  • Test Application
  • Rendering HTML

Session 3

Section A: Server Controls

  • Overview
  • HTML Controls
  • Work with HTML Controls
  • Retrieve Data
  • Hidden Control
  • HTML Table Control
  • Setting HTML Properties

Section B: Using Web Controls

  • Overview
  • DataGrid Properties
  • Bind Data to DataGrid
  • Use Control Events
  • AutoPostBack
  • Client-side Code

Section C: Using DataSets

  • ADO.NET Object Model
  • Advantages
  • XML Bridge
  • ASP.NET Using DataSet
  • Caching Data Changes
  • Accept / Reject Changes
  • Constraints in DataSets
  • Update Database

Section D: Creating DataSets

  • Code Overview
  • Page_Load Event
  • Fill Method
  • DataSet to Session
  • Retrieve DataSet
  • Add Constraints
  • Constraints
  • Add Relations

Section E: Update with DataAdapters

  • CommandBuilder
  • Get Commands
  • ASP.NET DataGrid
  • Custom Commands
  • Add Parameters
  • SourceVersion
  • Stored Procedures
  • Output Parameters

Session 4

Section A: AutoIncrement

  • Column Properties
  • Value Conflicts
  • AutoIncrement Strategy

Section B: Transactional Model

  • ADO.NET Batch Process
  • BeginEdit / EndEdit
  • Explicit Transaction
  • DataRowVersion
  • RowState
  • GetChanges Method
  • AcceptChanges
  • RejectChanges

Section C: DataSets and XML

  • Data and Schema
  • File Creation
  • Create Nested XML
  • Open XML Schema
  • XML View
  • Constraints

Section D: DataSets and Nested XML

  • Open Nested Schema
  • Reading XML File
  • Implement XML Schema
  • ReadXML

Section E: Typed DataSets

  • Advantages
  • Fill DataSet
  • View Typed Schema
  • Generate DataSet
  • View Typed Objects
  • Work with Typed DataSets

Section F: Creating XML Schema

  • Create Typed DataSet
  • Modify Schema
  • Define Relationship
  • Add Constraints
  • Saving Schema

Section G: Using Crystal Reports

  • Overview
  • Report Layout
  • Report Issues
  • Setting Up Data
  • Create Report
  • View Expert Results

Section H: Modifying Reports

  • Modify Fields
  • Format Objects
  • Format Sections
  • Set Up to View Report
  • Load Report
  • View Report

Session 5

Section A: Crystal Reports Formula

  • Customized Behavior
  • Background Formula
  • Build Expression
  • Review Expression
  • Apply Formula to Report
  • Calculated Fields
  • Format Calculated Fields

Section B: Grouping / Totaling Reports

  • Group Options
  • View Grouped Report
  • Subtotal / Grand Total
  • Format Options
  • Filtering Reports
  • Programmatic Filtering

Section C: Windows Services

  • Overview
  • Considerations
  • Building Windows Services
  • Windows Services Code
  • Service Properties
  • Build Service Installer
  • Install Service
  • Test / Uninstall

Section D: Windows Service Example

  • Overview
  • Event Procedures
  • OnStart Event
  • Install Setup
  • Test
  • Debug

Section E: Understanding Web Service

  • Requirements
  • Service Providers
  • Web Service
  • Web Service Code
  • Test Web Service

Section F: Web Service Example

  • Overview
  • Web Service Methods
  • GetAllInventory Method
  • GetInventory Method
  • WSDL Document
  • Namespace

Session 6

Section A: Web Service Clients

  • Web References
  • Web Reference Files
  • Reference.vb
  • Calling Web Services
  • Retrieve Value
  • Retrieve DataSet

Section B: MS SOAP Toolkit

  • Consume Web Service
  • Set COM Reference
  • Using SOAP
  • Call Web Services

Section C: Using UDDI

  • Overview
  • Search UDDI Service
  • Add Reference
  • Implement Web Service

Section D: Binding to Views

  • Overview
  • Binding Context
  • Adding Relationships
  • Binding to Relations

Section E: Formatting the DataGrid

  • Overview
  • DataGridTableStyle Editor
  • Format DataGrid
  • DataGrid Format Property

Section F: Restrict DataGrid Editing

  • Read-only Columns
  • Allow Edit / New / Delete
  • Using DataViews

Section G: ListBox Controls

  • Overview
  • Add Items to ListBox
  • Set ListBox Focus
  • Bind to an Array

Section H: Working with Images

  • Overview
  • Populate ListBox
  • Remove Header
  • Picture Box
  • Get Image
  • Insert Image
  • Clean Up Database

Section I: Code Access Security

  • Overview
  • Code-based Security
  • Policy Levels
  • Configuration Tool
  • Evidence
  • Stack Walk
  • Permission Requests
  • How Managed Code Works

Section J: Implementing Requests

  • Declarative Security
  • Security Action
  • Embedded Attributes
  • Imperative Security

Session 7

Section A: Using Role-based Security

  • Overview
  • Principal Objects
  • Enable Role Example
  • Add New Group
  • Security Implementation
  • Validate Identity Role
  • Set Security Attributes
  • Permission in Code

Section B: MDI Properties

  • Overview
  • IsMdiContainer
  • IsMdiChild
  • Create MdiParent
  • Code MDI Forms

Section C: Menus in MDI

  • Overview
  • Merge Menus
  • MDI List Properties
  • Active MdiChild Properties
  • MergeType / MergeOrder
  • MDIChild Code
  • Add Menus and Submenus
  • Cut / Copy / Paste Code

Section D: Microsoft MDI Sample

  • Overview
  • Image Organization
  • Use MDI ToolBars
  • ImageList Controls
  • Built-in Components
  • Serializable Classes
  • Graphical Procedures
  • Serialize / Deserialize

Section E: Graphic Manipulation

  • Overview
  • OwnerDraw ComboBox
  • OwnerDraw Options
  • DrawItem Event
  • DrawList Item
  • Use GDI+ Objects
  • Array List
  • DrawItem

Session 8

Section A: Drawing on Forms

  • Populate Lists
  • Reflection
  • Assign Array
  • CreateGraphics
  • Pass Parameters
  • Set Up GDI+ Objects
  • GDI+ Brush Object
  • Override OnPaint

Section B: Transparency and Shaping

  • Transparent Areas
  • Shaping Forms
  • OwnerDraw Menu
  • MenuItem Size
  • Draw MenuItem
  • TransparencyKey
  • GraphicsPath
  • Regions and Opacity

Section C: Sample Deployment

  • Deploying Assemblies
  • Use ILDASM.EXE
  • Private / Shared Assembly
  • Deployment Options

Section D: Windows Installer

  • Overview
  • Create New Package
  • Select Files
  • Build MSI File
  • Install / Uninstall
  • Registry / File Types
  • Custom Actions
  • Replace MSI Files

Section E: Deploying to the GAC

  • Versioning
  • Version Numbers
  • Assembly Cache Viewer
  • Using Strong Names
  • SN.EXE
  • Sharing Components
  • Install in GAC
  • Add Merge Module Project

Section F: HTTP Deployment

  • Overview
  • XCopy Deployment
  • Security Settings
  • Run Deployed Application
  • Configure Evidence
  • Configure Assembly Trust