VB.NET For Developers Part 2

VB.NET For Developers Part 2

8 Sessions –
24 Hours of Interactive Training

In the VB.NET 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.

Prerequisites: Previous programming experience, familiarity with Visual Basic 6 and a basic understanding of the .NET platform are helpful.

Benefits

Increase your earning potential with in-demand IT programming knowledge.

Gain technical mastery of development tools and demonstrate your IT proficiency.

LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

About The Author

Andy Baron, Mary Chipman, and Ken Getz are all Senior Consultants with MCW Technologies, a Microsoft Solution Provider. All have been Microsoft MVPs since 1995. When not creating applications for clients, Baron, Chipman and Getz write articles for technical journals including MSDN, Visual Basic Programmer's Journal, asp.netPRO, Access-VB-SQL Advisor, MsOfficePro, and SQL Server Magazine. The three authors have between them written over 10 technical books on various development topics. All three speak regularly at industry conferences, including Microsoft's Tech-Ed and DevDays, and DevConnections, VBITS, and Advisor Devcon.

Session 1

Section A: ADO.NET
· ADO.NET Classes
· OleDb vs. SQLClient
· System.Data
· ADO.NET Architecture
· Presentation Tier
· DataTable Object
· Filling a DataTable

Section B: Connections & Commands
· Connecting to a Data Source
· Setting Up Connections
· Making the Connections
· Commands
· Command Objects
· DataReader
· SqlDataReader
· Closing Connections

Section C: Working with Data
· DataAdapter Object
· DataSet Object
· Filling a DataSet
· OleDB DataSet
· Iterate Rows & Bind
· Rows & Columns
· Using SqlDataAdapter
· Iterate Columns

Section D: ADO.NET Providers
· Choosing a Provider
· SQL Data Provider
· OLE DB Provider
· ODBC Data Provider
· Multiple Providers
· Using Interface Inheritance
· ReadData Procedure
· Using IData Reader

Section E: Using COM Objects
· How COM Works
· .NET Advantages
· CLR vs. COM
· Runtime Callable Wrapper
· Use VB6 COM Object

Section F: Exporting Data to Excel
· Send Data to COM Object
· Send Data to Excel
· Release Excel COM Object
· Explicitly Declare & Release

Section G: Platform Invocation Services
· Create Wrapper Class
· Call Wrapper Class

Session 2

Section A: COM Callable Wrapper
· Create COM Object
· Set Properties
· Calling .NET from VB6.0

Section B: Data Binding Basics
· .NET Data Binding
· Setting Up Data Source
· DataAdaptor Wizard
· Generating a DataSet
· Bind DataGrid Control
· Add Fill Method

Section C: Limiting Results
· Query by Form

· Generate SP DataAdaptor
· Generate Categories DataSet
· Bind & Fill ComboBox
· Create Parameter Query
· Select ComboBox Categories

Section D: Data Navigation
· Binding Context & Navigation
· Set Properties
· BindContext
· Run Navigation Buttons
· Binding Alternatives

Section E: Data Form Wizard
· Build Form from DataSet
· Run & Load Form
· Add & Bind Controls
· Bind Control in Code
· Bind Control to Controls

Section F: Review Classic ASP
· ASP Example
· Data Access Code
· ASP Object Model
· View the Example
· Handling ASP PostBacks
· Mixing Code & HTML
· Generated HTML

Section G: ASP vs. ASP.NET
· Loose Code & Collaboration Difficulty
· Limited Tools & Server Affinity
· Obscure Configuration & PostBacks
· Compiled Code & Code Separation
· Cluster-friendly & XML-based Configuration
· Automatic PostBack Handling

Section H: Creating ASP.NET App.
· 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
· HTML Controls
· Working with HTML Server Controls
· Use ADO.NET to Retrieve Data
· Hidden ViewState Control
· HTML Table Control
· Setting HTML Properties

Section B: Using Web Controls
· Working with DataGrid Properties
· Binding Data to a DataGrid
· Using 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
· PageLoad Event
· Fill Method
· DataSet in Session
· Retrieve DataSet
· Add Constraints
· Unique Constraints
· Add Relations

Section E: Update with DataAdaptors
· Command Builder
· Get Commands
· ASP.NET DataGrid
· Custom Commands
· Add Parameters
· Source Version
· 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 & XML
· Data & Schema
· File Creation
· Create Nested XML
· Open XML Schema
· XML View
· Constraints
· Open Nested Schema
· Reading XML File
· Implementing SML Schema
· Readxml

Section D: Typed DataSets
· Using Typed DataSets
· Fill DataSet
· View Typed Schema
· Generate Typed DataSet
· View Typed Objects
· Working with Typed DataSet
· Create Typed DataSet
· Modify Fields
· Define Relationship
· Add Constraints
· Saving Schema

Section E: Using Crystal Reports
· Report Layout
· Report Issues
· Setting Up Data
· Create Report
· View Expert Results

VB.NET For Developers Part 2 continued

Section F: Modify Reports
· Modify Fields
· Format Objects
· Format Sections
· Setup to View Report
· Load Report
· View Report

Session 5

Section A: Crystal Reports Formulas
· Customized Formula Behavior
· Create Background Formula
· Build Expression
· Review Expression
· Apply Formula to Report
· Calculated Fields
· Format Calculated Field

Section B: Grouping & Totaling Reports
· Group Options
· View Grouped Report
· Subtotals & Grand Total
· Format Options
· Filtering Reports
· Programmatic Filtering

Section C: Windows Services
· Considerations
· Building Windows Services
· Windows Services Code
· Services Properties
· Build Service Installer
· Install Service
· Test & Uninstall

Section D: Window Service Example
· Event Procedures
· OnStart Event
· Install Setup
· Test
· Debug

Section E: Understanding XML Web Service
· Web Service Requirements
· Discovering Service Providers
· Web Service
· Web Service Code
· Test Web Service

Section F: XML Web Service Example
· 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 Service

Section C: Using UDDI
· Search UDDI Service
· Add UDDI Reference
· Implement Web Service

Section D: Binding to Views
· Binding Context
· Adding Relationships
· Binding to Relations

Section E: Formatting the DataGrid
· DataGridTableStyle Editor
· Format DataGrid
· DataGrid Format Properties

Section F: Restrict DataGrid Editing
· Read-only Columns
· Allow New, Edit & Delete
· Using DataViews

Section G: ListBox Controls
· Add Items to ListBox
· Set ListBox Focus
· Bind to an Array

Section H: Working with Images
· Populate ListBox
· Remove Header
· Picture Box
· Get Image
· Insert Image
· Cleanup Database

Section I: Code Access Security
· Code Based Security
· Policy Levels
· .NET Framework Configuration Tool
· Runtime Security Policy
· Evidence
· The Stack Walk
· Permission Requests
· How Managed Code Works

Section J: Implementing Permissions Requests
· Declarative Security
· Security Action
· Embedded Attributes
· Imperative Security

Session 7

Section A: Using Role-Based Security
· Principal Objects
· Enabling Role Example
· Add New Group
· Security Implementation
· Validate Identity Role
· Setting Security Attributes
· Permissions in Code

Section B: MDI Properties
· IsMdiContainer
· IsMdiChild
· Create MDI Parent
· Coding MDI Forms

Section C: Menus in MDI
· Merging Menus
· MDI List Properties
· ActiveMdiChild Properties
· MergeType & MergeOrder
· MDI Child Code
· Add Menus
· Add Submenus
· Cut, Copy & Paste Code

Section D: Microsoft MDI Sample
· MDI with Toolbar
· Image Organization
· Using MDI Toolbars
· Image List Controls
· Built-in Components
· Serializable Classes
· Graphical Procedures
· Serialize & De-serialize

Section E: Graphic Manipulation
· Owner-Draw ComboBox
· Owner-Draw Options
· DrawItem Event
· Draw ListItem
· Using GDI+ Objects
· Array List
· Drawing Item

Session 8

Section A: Drawing on Forms
· Populate Lists
· Reflection
· Assign Array
· Create Graphics
· Pass Parameters
· Setup GDI+ Brush Object
· Override on Paint

Section B: Transparency & Shaping
· Transparent Areas
· Shaping Forms
· Owner-Draw Menu
· Menu Item Size
· Draw Menu Item
· ME. Transparency Key
· Graphics Path
· Regions & Opacity

Section C: Sample Deployment
· Deploying Assemblies
· Using ILDASM.EXE
· Private & Shared Assemblies
· Deployment Options

Section D: Windows Installer Deployment
· Create New Package
· Select Files
· Build MSI File
· Install & Uninstall
· Registry & File Types Editor
· 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 Components in GAC
· Add Merge Module Project

Section F: HTTP Deployment
· XCOPY Deployment
· Security Setting
· Run Deployed Application
· Configure Evidence
· Configure Assembly Trust