Learn your way! Get started

Visual Basic .NET 2003 Part 2

with experts Andy Baron, Ken Getz, Mary Chipman

Course at a glance

Included in these subscriptions:

Dev & IT Pro Video
Dev & IT Pro Power Pack

	Release date	8/27/2003
	Level	Intermediate
	Runtime	13h 21m
	Closed captioning	N/A
	Transcript	N/A
	eBooks / courseware	Included
	Hands-on labs	Included
	Sample code	Included
	Exams	N/A
	Platform	Internet Explorer Only

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

In the first part of this course you will learn how to use Visual Studio .NET and Visual Basic .NET to build applications to run on the .NET platform. You will become familiar with the new Visual Basic .NET programming syntax including new object-oriented enhancements like inheritance. This course teaches you how to create Windows Forms and trap Windows Forms Events. You will learn how to access data using the new objects in ADO.NET including the DataReader, DataAdapter, and DataSet. Learn to build solid applications using the new Try/Catch block and Exception Object for efficient error trapping and Event logging and Breakpoints for effective debugging. Tap into the Internet by building Web-based application and XML Web Services including understanding the SOAP toolkit, UDDI, and how to build Web Services consumers. Learn how to leverage the security features in the .NET framework and build powerful reports using Crystal Reports.

Meet the experts

Andy Baron is a nationally recognized industry expert specializing in Visual Basic, Visual C#, ASP.NET, ADO.NET, SQL Server, and SQL Server Business Intelligence. He is an experienced consultant, author, and editor for several industry publications and speaker at industry conferences. Andy has also been repeatedly selected as a Microsoft MVP for his contributions to Microsoft's online support.

Ken Getz is a featured instructor for several of our Visual Studio courses. He is a Visual Basic and Visual C# expert and has been recognized multiple times as a Microsoft MVP. Ken is a seasoned instructor, successful consultant, and the author or co-author of several best-selling books. He is a frequent speaker at technical conferences like Tech-Ed, VSLive, and DevConnections and he has written for several of the industry's most-respected publications including Visual Studio Magazine, CoDe Magazine, and MSDN Magazine.

Mary Chipman is a programmer-writer for the Data Access Technologies team at Microsoft. Previously, she was a senior consultant and was repeatedly recognized as a Microsoft MVP. Mary is the co-author of the "Microsoft Access Developer's Guide to SQL Server" (Sams) and has written additional books and articles for technical journals. She has been a frequent speaker at industry conferences and is an experienced trainer and courseware author.

Course outline

Module 9

ADO.NET (18:55)

Overview (01:56)
Introduction to ADO.NET (02:03)
ADO.NET Classes (00:50)
OleDb vs. SqlClient (01:05)
System.Data (02:06)
ADO.NET Architecture (03:13)
Presentation Tier (02:15)
DataTable Object (00:48)
Filling a DataTable (03:55)
Summary (00:38)

Connections and Commands (15:00)

Overview (00:58)
Set Up Connections (02:57)
Make the Connections (01:16)
Commands (01:20)
Command Object (01:26)
DataReader (01:10)
SqlDataReader (04:13)
Close Connections (00:37)
Summary (00:59)

Working with Data (18:07)

Overview (00:43)
DataAdapter Object (03:16)
DataSet Object (01:50)
Filling a DataSet (01:30)
OleDb DataSet (01:52)
Iterate Rows and Bind (02:26)
Rows and Columns (02:18)
Using SqlDataAdapter (01:12)
Iterate Columns (02:05)
Summary (00:51)

ADO.NET Providers (11:25)

Overview (00:43)
Choosing a Provider (00:42)
SQL Data Provider (00:50)
OLE DB Provider (00:52)
ODBC Data Provider (00:26)
Multiple Providers (00:35)
Use Interface Inheritance (02:18)
ReadData Procedure (01:18)
Using IDataReader (02:30)
Summary (01:07)

Using COM Objects (11:07)

Overview (00:44)
Component Types (02:22)
.NET Advantages (00:51)
CLR vs. COM (01:38)
Runtime Callable Wrapper (00:52)
Use VB6 COM Object (04:15)
Summary (00:22)

Support Data to Excel (08:33)

Overview (00:29)
Working in Excel (00:59)
Send Data to Excel (02:06)
ReleaseComObject (03:15)
Explicitly Declare / Release (00:45)
Summary (00:56)

Platform Invocation Services (06:43)

Overview (00:52)
Calling Windows API (01:48)
Create Wrapper Class (02:15)
Call Wrapper Class (01:09)
Summary (00:37)

Module 10

COM Callable Wrapper (08:17)

Overview (00:36)
Compiler (01:29)
Create COM Object (02:23)
Set Properties (00:58)
Calling .NET (02:13)
Summary (00:36)

DataBinding Basics (11:49)

Overview (00:38)
.NET DataBinding (01:00)
Setting Up DataSource (01:25)
Data Adapter Wizard (03:21)
Generating a DataSet (01:58)
Bind DataGrid Control (01:31)
Add Fill Method (00:59)
Summary (00:55)

Limiting Results (13:35)

Overview (00:57)
Query by Form (00:58)
Generate DataAdapter (02:03)
Categories DataSet (00:55)
Bind / Fill ComboBox (01:54)
Create Parameter Query (04:20)
ComboBox Categories (01:56)
Summary (00:29)

Data Navigation (07:20)

Overview (00:31)
Context and Navigation (01:26)
Set Properties (00:58)
BindingContext (01:29)
Run Navigation Buttons (00:53)
Binding Alternatives (01:36)
Summary (00:24)

Data Form Wizard (10:53)

Overview (00:28)
Access the Wizard (00:43)
Build from DataSet (01:37)
Run / Load Form (02:10)
Add / Bind Controls (01:13)
Bind Control in Code (02:18)
Bind Control to Controls (01:25)
Summary (00:56)

Review Classic ASP (20:07)

Overview (01:10)
ASP Example (02:17)
Data Access Code (01:13)
ASP Object Model (02:21)
View Example (02:10)
Handling ASP Postbacks (03:46)
Mixing Code & HTML (04:32)
Generated HTML (02:09)
Summary (00:26)

ASP vs. ASP.NET (11:48)

Overview (00:52)
Loosely-typed Code (02:20)
Limited Tools (01:35)
Obscure Settings (02:04)
Compiled Code (01:41)
XML-based Files (01:11)
Automatic Handling (00:49)
Summary (01:12)

Create ASP.NET Application (19:25)

Overview (00:18)
Create New Project (01:32)
Web Form Layout (02:24)
HTML View (03:14)
Edit Control Properties (02:48)
Code Window (02:02)
Edit Code (01:37)
Test Application (00:30)
Rendering HTML (04:22)
Summary (00:34)

Module 11

Server Controls (23:07)

Overview (01:18)
Sample Page (01:21)
HTML Controls (03:52)
Work with HTML Controls (03:11)
Retrieve Data (02:21)
Hidden Control (03:04)
HTML Table Control (04:35)
Setting HTML Properties (01:16)
Summary (02:05)

Using Web Controls (15:57)

Overview (00:48)
Sample Page (00:45)
DataGrid Properties (03:40)
Bind Data to DataGrid (02:06)
Use Control Events (01:43)
AutoPostBack (04:08)
Client-side Code (01:56)
Summary (00:46)

Using DataSets (20:46)

Overview (00:32)
ADO.NET Object Model (04:04)
Advantages (03:11)
XML Bridge (02:18)
ASP.NET Using DataSet (02:12)
Caching Data Changes (03:58)
Accept / Reject Changes (00:30)
Constraints in DataSets (01:57)
Update Database (01:26)
Summary (00:34)

Creating DataSets (25:19)

Overview (00:27)
Code Overview (02:52)
Page_Load Event (00:43)
Fill Method (03:09)
DataSet to Session (01:36)
Retrieve DataSet (01:29)
Add Constraints (02:58)
Constraints (07:43)
Add Relations (03:38)
Summary (00:39)

Update with DataAdapters (20:51)

Overview (01:01)
Add Commands (02:42)
Get Commands (01:38)
ASP.NET DataGrid (03:07)
Custom Commands (01:36)
Add Parameters (01:50)
SourceVersion (03:17)
Stored Procedures (02:35)
Output Parameters (01:50)
Summary (01:10)

Module 12

AutoIncrement (07:52)

Overview (01:10)
Column Properties (02:38)
Value Conflicts (01:40)
AutoIncrement Strategy (00:49)
Summary (01:33)

Transactional Model (21:03)

Overview (00:59)
ADO.NET Batch Process (01:16)
BeginEdit / EndEdit (01:57)
Explicit Transaction (01:12)
DataRowVersion (03:46)
RowState (03:03)
GetChanges Method (01:52)
AcceptChanges (02:22)
RejectChanges (02:29)
Summary (02:01)

DataSets and XML (15:23)

Overview (01:35)
Data and Schema (02:00)
File Creation (01:57)
Create Nested XML (01:30)
Open XML Schema (01:10)
XML View (02:58)
Constraints (04:04)
Summary (00:05)

DataSets and Nested XML (08:02)

Overview (00:23)
Open Nested Schema (01:34)
Reading XML File (02:14)
Implement XML Schema (02:01)
ReadXML (00:59)
Summary (00:49)

Typed DataSets (12:56)

Overview (01:25)
Advantages (04:16)
Fill DataSet (01:09)
View Typed Schema (01:37)
Generate DataSet (01:32)
View Typed Objects (01:40)
Work with Typed DataSets (01:09)
Summary (00:06)

Creating XML Schema (09:27)

Overview (00:32)
Create Typed DataSet (02:16)
Modify Schema (00:35)
Define Relationship (02:49)
Add Constraints (01:14)
Saving Schema (01:16)
Summary (00:42)

Using Crystal Reports (15:37)

Overview (01:14)
Crystal Reports for VS.NET (01:03)
Report Layout (02:08)
Report Issues (03:45)
Setting Up Data (02:21)
Create Report (03:05)
View Expert Results (01:19)
Summary (00:38)

Modifying Reports (15:53)

Overview (00:30)
Modify Fields (01:05)
Format Objects (02:57)
Format Sections (02:15)
Set Up to View Report (01:48)
Load Report (03:02)
View Report (03:21)
Summary (00:52)

Module 13

Crystal Reports Formula (14:38)

Overview (00:37)
Customized Behavior (01:27)
Background Formula (03:04)
Build Expression (03:15)
Review Expression (00:46)
Apply Formula to Report (01:11)
Calculated Fields (02:04)
Format Calculated Fields (01:38)
Summary (00:31)

Grouping and Totaling Reports (15:22)

Overview (00:47)
Group Options (02:30)
View Grouped Report (02:05)
Subtotal / Grand Total (02:07)
Format Options (01:34)
Filtering Reports (01:41)
Programmatic Filtering (03:48)
Summary (00:47)

Windows Services (18:54)

Overview (00:58)
Starting Services (02:12)
Considerations (01:21)
Building Windows Services (02:43)
Windows Services Code (01:53)
Service Properties (00:51)
Build Service Installer (02:38)
Install Service (02:16)
Test / Uninstall (02:24)
Summary (01:33)

Windows Service Example (17:20)

Overview (00:58)
Starting Example (03:39)
Event Procedures (03:21)
OnStart Event (01:52)
Install Setup (01:35)
Test (00:42)
Debug (04:16)
Summary (00:54)

Understanding Web Service (16:40)

Overview (01:04)
Functionality Issues (02:09)
Web Service Code (01:58)
Test Web Service (01:04)
Service Providers (01:51)
Web Service (07:27)
Summary (01:03)

Web Service Example (12:43)

Overview (00:48)
Sample Project (01:02)
Web Service Methods (03:22)
GetAllInventory Method (01:22)
GetInventory Method (01:03)
WSDL Document (01:18)
Namespace (02:04)
Summary (01:41)

Module 14

Web Service Clients (14:37)

Namespace (02:04)
Overview (00:50)
Web Reference Files (01:19)
Reference.vb (03:02)
Calling Web Services (00:59)
Retrieve Value (02:28)
Retrieve DataSet (01:54)
Summary (01:35)

MS SOAP Toolkit (08:23)

Overview (00:58)
Downloading SOAP (00:51)
Set COM Reference (01:04)
Using SOAP (02:56)
Call Web Services (01:23)
Summary (01:09)

Using UDDI (08:42)

Overview (00:50)
UDDI on the Web (00:32)
Search UDDI Service (02:14)
Add Reference (01:46)
Implement Web Service (02:34)
Summary (00:43)

Binding to Views (07:55)

Overview (00:46)
Data Grid Controls (00:51)
Binding Context (01:38)
Adding Relationships (02:12)
Binding to Relations (02:06)
Summary (00:21)

Formatting the DataGrid (10:09)

Overview (00:27)
Table Styles (00:36)
DataGridTableStyle Editor (03:34)
Format DataGrid (01:55)
DataGrid Format Property (02:53)
Summary (00:42)

Restrict DataGrid Editing (06:05)

Overview (00:43)
Updating Columns (01:25)
Allow Edit / New / Delete (02:31)
Using DataViews (00:57)
Summary (00:27)

ListBox Controls (08:03)

Overview (00:44)
ListBox Tools (00:49)
Add Items to ListBox (02:43)
Set ListBox Focus (01:36)
Bind to an Array (01:46)
Summary (00:24)

Working with Images (15:10)

Overview (00:41)
Populating Options (01:30)
Populate ListBox (02:05)
Remove Header (01:48)
Picture Box (02:34)
Get Image (01:02)
Insert Image (03:41)
Clean Up Database (01:14)
Summary (00:29)

Code Access Security (16:10)

Overview (01:25)
Security Features (00:59)
Code-based Security (01:32)
Policy Levels (01:17)
Configuration Tool (03:41)
Evidence (01:17)
Stack Walk (01:15)
Permission Requests (01:23)
How Managed Code Works (02:23)
Summary (00:54)

Implementing Requests (07:42)

Overview (00:33)
Declarative Security (01:04)
Security Action (02:28)
Embedded Attributes (00:37)
Imperative Security (02:22)
Summary (00:35)

Module 15

Using Role-based Security (12:47)

Overview (00:40)
Concepts (00:58)
Principal Objects (01:10)
Enable Role Example (01:07)
Add New Group (01:16)
Security Implementation (00:52)
Validate Identity Role (02:29)
Set Security Attributes (01:50)
Permission in Code (01:40)
Summary (00:40)

MDI Properties (13:31)

Overview (01:41)
Sample Project (00:20)
IsMdiChild (01:10)
IsMdiContainer (00:46)
Create MdiParent (05:36)
Code MDI Forms (02:58)
Summary (00:57)

Menus in MDI (24:30)

Overview (01:41)
Merge Menus (01:51)
MDI List Properties (03:00)
Active MdiChild Properties (01:50)
MergeType / MergeOrder (03:58)
MDIChild Code (04:31)
Add Menus and Submenus (04:05)
Cut / Copy / Paste Code (02:50)
Summary (00:40)

Microsoft MDI Sample (20:03)

Overview (00:37)
MDI Samples (01:58)
Image Organization (04:44)
Use MDI ToolBars (02:06)
ImageList Controls (02:57)
Built-in Components (01:17)
Serializable Classes (02:39)
Graphical Procedures (00:52)
Serialize / Deserialize (02:22)
Summary (00:26)

Graphic Manipulation (22:29)

Overview (01:21)
Sample Form (01:56)
OwnerDraw ComboBox (02:34)
OwnerDraw Options (04:18)
DrawItem Event (02:51)
DrawList Item (02:21)
Use GDI+ Objects (01:06)
Array List (02:38)
DrawItem (02:50)
Summary (00:29)

Module 16

Drawing on Forms (23:32)

Overview (00:48)
Example Code (02:31)
Reflection (01:47)
Assign Array (02:15)
CreateGraphics (01:11)
Pass Parameters (02:33)
Set Up GDI+ Objects (02:45)
GDI+ Brush Object (03:12)
Override OnPaint (04:40)
Summary (01:45)

Transparency and Shaping (18:36)

Overview (01:13)
Transparency Example (01:39)
Shaping Forms (01:48)
OwnerDraw Menu (02:41)
MenuItem Size (02:17)
Draw MenuItem (01:50)
TransparencyKey (01:13)
GraphicsPath (01:30)
Regions and Opacity (03:04)
Summary (01:16)

Sample Deployment (10:37)

Overview (00:39)
The Basic Unit of Deployment (02:05)
Use ILDASM.EXE (01:55)
Private / Shared Assembly (02:09)
Deployment Options (03:26)
Summary (00:21)

Windows Installer (17:16)

Overview (00:32)
MSI (00:37)
Create New Package (03:32)
Select Files (02:01)
Build MSI File (01:38)
Install / Uninstall (01:53)
Registry / File Types (02:31)
Custom Actions (03:23)
Replace MSI Files (00:32)
Summary (00:32)

Deploying to the GAC (21:04)

Overview (00:47)
Versioning (01:19)
Version Numbers (02:11)
Assembly Cache Viewer (01:30)
Using Strong Names (01:49)
SN.EXE (01:53)
Sharing Components (03:18)
Install in GAC (03:28)
Add Merge Module Project (04:07)
Summary (00:37)

HTTP Deployment (13:10)

Overview (00:36)
Example (00:52)
XCopy Deployment (02:55)
Security Settings (01:53)
Run Deployed Application (00:51)
Configure Evidence (02:30)
Configure Assembly Trust (02:56)
Summary (00:34)