Learn your way! Get started

Visual Basic .NET 2003

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/26/2003
Level Intermediate
Runtime 24h 40m
Closed captioning N/A
Transcript N/A
eBooks / courseware Included
Hands-on labs Included
Sample code Included
Exams Included
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 1

Introduction (20:07)
  • Overview (01:56)
  • Create New Project (03:03)
  • Workspace Layout (00:44)
  • Solution Explorer (02:29)
  • Properties Window (03:15)
  • Size Properties / Handles (03:28)
  • Run / Compile (01:38)
  • Form Properties (02:40)
  • Summary (00:50)
Form Controls (10:50)
  • Add Controls (00:31)
  • Size / Position (04:46)
  • Multiple Controls (02:25)
  • Format Toolbar (02:36)
  • Summary (00:30)
Behind the Scenes (19:07)
  • View Code (01:08)
  • Regions (02:41)
  • Form Classes (03:10)
  • Dispose Method (01:35)
  • Variables (03:15)
  • Attributes (03:10)
  • Comments (00:59)
  • Set Properties (02:05)
  • Summary (01:01)
Event Handling Code (09:13)
  • Control Properties (01:02)
  • Create Handles (04:06)
  • Add Event Code (02:30)
  • Event Handlers (00:57)
  • Summary (00:37)
Form Menu (16:54)
  • Add Menus (00:40)
  • Menu Properties (04:17)
  • Add Menu Code (02:49)
  • Change Controls (01:58)
  • Modify Form Behavior (02:23)
  • Keyboard Shortcuts (04:13)
  • Summary (00:32)
Form Components (17:54)
  • Add Components (01:06)
  • Tool Tips (02:05)
  • Use Tool Tips (02:24)
  • Timer (02:14)
  • Form Opacity (03:46)
  • Closing Event (04:44)
  • Summary (01:34)
Create Console Application (06:20)
  • Key Terms (00:28)
  • vbc.exe (02:57)
  • Create with Notepad (01:42)
  • Use vbc.exe (00:47)
  • Summary (00:24)
Visual Studio .NET (11:09)
  • Profiles / Options (00:37)
  • View (04:01)
  • Solution Properties (01:54)
  • Implicit vs. Explicit (02:46)
  • Modules / Classes (01:10)
  • Summary (00:38)

Module 2

Variable and Data Types (17:35)
  • Declare Variables (00:28)
  • Outside of Procedures (04:14)
  • Static Variables (01:35)
  • Block Variables (01:26)
  • .NET Data Types (03:15)
  • Convert Data Types (02:49)
  • View Variable Properties (00:43)
  • Use CType Conversion (02:32)
  • Summary (00:30)
Operators (52:19)
  • Overview (00:24)
  • AndAlso / OrElse (04:22)
  • Use Operators (01:59)
  • Summary (00:14)
  • Overview (00:37)
  • Overview (01:21)
  • 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 (-16:-36)
  • 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:26)
  • Summary (00:29)
  • Overview (00:48)
  • Overview (01:13)
  • Overview (00:39)
  • Overview (00:32)
  • Overview (00:47)
  • Overview (00:36)
  • 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 (-16:-18)
  • 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 (-13:-02)
  • The Basic Unit of Deployment (02:05)
  • Use ILDASM.EXE (01:55)
  • Private / Shared Assembly (02:09)
  • Deployment Options (-06:-10)
  • 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 (-15:-38)
  • 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 (-15:-32)
  • 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 (01:45)
  • Summary (01:16)
  • Summary (00:21)
  • Summary (00:32)
  • Summary (00:37)
  • Summary (00:34)
Working with Code (20:01)
  • Functions (00:23)
  • Declare Function (03:02)
  • Sub Procedure (01:08)
  • Parameters (02:22)
  • For Loop (03:12)
  • Do Loop (03:08)
  • If Statements (02:14)
  • Select Case (04:11)
  • Summary (00:18)
Enumeration and Structures (08:41)
  • Enumeration (00:29)
  • Constants w/Enumeration (04:20)
  • Structures (01:14)
  • Enumeration w/Structure (02:10)
  • Summary (00:26)
VB.NET Event Handling (12:53)
  • Delegates (00:52)
  • Event Handler (02:59)
  • Multiple Controls (02:36)
  • Multiple Handlers (02:44)
  • AddHandler (03:08)
  • Summary (00:32)
Form And Control Events (23:10)
  • Inheritance Chain (00:25)
  • Form Events (04:32)
  • Mouse Events (01:55)
  • Keyboard Events (03:08)
  • KeyUp / KeyDown (03:46)
  • Disable Keys (01:17)
  • Control Events (04:01)
  • Validate Events (03:33)
  • Summary (00:28)

Module 3

Classes and Objects (13:17)
  • Class Usage (01:46)
  • CLR Types (04:30)
  • Object Creation (01:26)
  • Advantages (04:47)
  • Summary (00:45)
Class Library (09:22)
  • Overview (01:04)
  • Properties (02:58)
  • View Library Object (02:12)
  • Set Reference (02:05)
  • Summary (01:02)
Constructors (13:23)
  • Overview (00:58)
  • Imports Statement (03:25)
  • Call Constructor (02:39)
  • Naming Conventions (02:22)
  • Overload (03:16)
  • Summary (00:40)
Properties (21:02)
  • Overview (01:42)
  • Fields vs. Properties (03:12)
  • Public Properties (01:27)
  • Use Private Field (01:02)
  • Advantages (02:02)
  • Validate (06:38)
  • Calculated (02:29)
  • Summary (02:27)
Methods (21:30)
  • Overview (01:14)
  • Create Method (04:24)
  • Call Method (02:17)
  • Create Events (04:32)
  • Raise Event (02:02)
  • Declare Var w/Events (01:54)
  • Handle Events (02:09)
  • Dispose (02:22)
  • Summary (00:33)
Tab Controls and Context Menu (17:59)
  • Tab Control (00:38)
  • TabAlignment (05:02)
  • TabAppearance (03:33)
  • Context Menu (01:40)
  • Context Menu Code (02:49)
  • TabPages Order (03:07)
  • Summary (01:08)

Module 4

Range Selection Controls (14:41)
  • TrackBar Control (01:05)
  • TrackBar Properties (04:17)
  • Shortcut Keys (00:59)
  • NumericUpDown (03:30)
  • DomainUpDown (02:47)
  • Properties (00:58)
  • Summary (01:01)
Range Selection Code (17:12)
  • TrackBar Events (00:39)
  • Scroll Event (03:25)
  • ValueChanged Event (01:33)
  • Context Menus (01:43)
  • RadioCheck Procedure (03:27)
  • Change Properties (03:57)
  • Using Enum.Parse (01:38)
  • Summary (00:47)
Option Controls (16:34)
  • GroupBox Control (00:50)
  • CheckBox (02:43)
  • ControlBox Options (02:42)
  • TopMost (02:53)
  • CheckBox Location (01:15)
  • Labels / Images (01:59)
  • RadioButton (00:55)
  • WindowState Property (02:00)
  • Summary (01:14)
LinkLabel and List Controls (16:43)
  • LinkLabel (00:47)
  • LinkLabel Procedure (04:53)
  • ListBox (02:24)
  • ComboBox (01:42)
  • Fill ListBox (01:36)
  • Cast ListBox Items (01:19)
  • Anchoring (01:44)
  • Add Controls Dynamically (01:24)
  • Summary (00:49)
Anchoring and CheckedListBox (20:51)
  • Anchoring Properties (00:19)
  • AutoScroll (03:38)
  • ListBox Options (03:18)
  • Select Event (03:57)
  • Toggling Visibility (00:48)
  • CheckedListBox (06:56)
  • CheckOnClick Property (01:26)
  • Summary (00:25)
Docking and Splitter Controls (12:19)
  • Docking Concepts (01:05)
  • Splitter Control (03:53)
  • Build Split Object (03:51)
  • TextBox (01:01)
  • Set Border Style (01:27)
  • Summary (00:59)
Dialog Control and Tab Order (06:11)
  • Dialog Controls (00:40)
  • Create Icon Object (02:52)
  • Create Color / Font Object (00:24)
  • Tab Order (01:28)
  • Summary (00:44)

Module 5

String Class (19:15)
  • Overview (00:36)
  • String Constructors (09:30)
  • Static / Shared Method (03:02)
  • Compareordinal (01:15)
  • Concat / Format / Join (04:45)
  • No Summary (00:05)
Manipulating Strings (10:33)
  • Instance Methods (00:28)
  • String-returning Methods (05:30)
  • StringBuilder Class (02:22)
  • ToString Method (01:24)
  • Summary (00:48)
Dates and Times (16:46)
  • Overview (00:35)
  • DateTime Constructors (02:53)
  • Shared Methods (03:07)
  • DateTime Properties (01:04)
  • Conversion Methods (03:00)
  • Calculation Methods (01:21)
  • DateTime Methods (00:41)
  • Using DateTime Type (03:24)
  • Summary (00:37)
TimeSpan Type (10:03)
  • Elapsed Time (00:45)
  • Create TimeSpan Values (02:51)
  • TimeSpan Properties (01:09)
  • Create a TimeSpan (01:00)
  • TimeSpan Fields / Methods (02:00)
  • Parse TimeSpan (01:29)
  • Summary (00:45)
Exception Handling (13:46)
  • .NET Error Handling (00:59)
  • No Error Handling (04:04)
  • Simple Try / Catch Block (03:30)
  • Unhandled Error (01:08)
  • Exception Object (02:45)
  • Summary (01:16)
Catching Specific Exceptions (10:10)
  • Overview (01:02)
  • Multiple Exceptions (04:45)
  • Exception Order (01:37)
  • Exception Hierarchy (01:34)
  • Summary (01:10)
Throw and Finally (11:25)
  • Throw Keyword (00:51)
  • Exception Handling Options (02:35)
  • Passing Error Information (01:53)
  • InnerException (02:22)
  • Run Code Unconditionally (01:19)
  • Use Finally Block (01:42)
  • Summary (00:40)

Module 6

Debugging Environment (20:23)
  • Configure (00:30)
  • Configuration Properties (03:03)
  • Debug Setup / Use (02:24)
  • Debug Window (03:06)
  • Watch Expressions (02:17)
  • Conditional Breakpoint (03:03)
  • Multiple Languages (03:49)
  • Debug Stored Procedure (01:30)
  • Summary (00:38)
Logging and Tracing (14:15)
  • Windows Event Log (00:38)
  • Create Event Log (02:19)
  • Write to / View Log (01:18)
  • Tracing Application (03:06)
  • Trace Switch / Listeners (03:04)
  • Write Trace Listeners (01:52)
  • Modify Configuration (00:54)
  • Summary (01:01)
Understanding Inheritance (14:07)
  • Overview (01:32)
  • Inheritance Class (03:01)
  • Overriding (01:47)
  • Virtual (02:20)
  • Shadowing (02:37)
  • Protected (02:05)
  • Summary (00:42)
Implementing Inheritance (20:10)
  • Supporting Inheritance (00:31)
  • Setting Class / Properties (05:19)
  • Override Methods (00:52)
  • Create Derived Class (04:17)
  • Overloads Overrides (03:06)
  • Implement Derived Class (01:34)
  • Overriding in Action (03:25)
  • Summary (01:02)
Using Inheritance (20:10)
  • Customize Controls (02:12)
  • Create Derived Group Box (05:06)
  • Create Custom Control (03:22)
  • Create Custom Event (02:18)
  • Override Inherited Class (05:55)
  • Summary (01:14)
Using Custom Controls (08:45)
  • Setting Up Component (00:50)
  • Add to Toolbox (03:35)
  • Create Control Toolbox (02:14)
  • Test Derived Control (00:34)
  • Summary (01:31)
Polymorphism (09:39)
  • Overview (02:57)
  • Inheritance-based (03:03)
  • Base Class Type (01:57)
  • Summary (01:40)

Module 7

Using Interfaces (21:44)
  • Overview (01:06)
  • Work with Interfaces (04:58)
  • Implement Interfaces (03:59)
  • Implement IComparable (02:16)
  • IComparable.CompareTo (02:08)
  • Implement IComparer (02:05)
  • Use Dual Interfaces (04:04)
  • Summary (01:06)
Selecting Files (13:17)
  • Useable Form Controls (00:45)
  • ShowDialog Method (05:21)
  • Filter Property (01:30)
  • Control Properties (02:19)
  • Events (02:38)
  • Summary (00:42)
Path and FileSystemInfo (14:34)
  • Path Class (01:03)
  • Path Class Methods (04:28)
  • Directory / File Classes (02:23)
  • Object Hierarchy (00:44)
  • FileSystemInfo Class (00:44)
  • Directory Class Methods (03:20)
  • Create Directory Method (01:19)
  • Summary (00:30)
TreeView Control (17:09)
  • Get Logical Drives (00:40)
  • Add Nodes (02:17)
  • Expand Nodes (02:47)
  • Get Folder Names (03:11)
  • View Expanded Tree (01:12)
  • File / Folder Properties (01:45)
  • TreeView After Select (02:26)
  • Polymorphism (01:51)
  • Summary (00:55)
Reading and Writing Files (12:42)
  • Stream-based Objects (00:47)
  • FillList Procedure (04:18)
  • FileStream Object (01:01)
  • FileStream Reader (02:13)
  • Alternative Solutions (01:14)
  • StreamWriter (01:50)
  • Summary (01:16)

Module 8

Working with Arrays (18:50)
  • Overview (00:59)
  • Create Arrays (02:30)
  • Dynamically Sized Arrays (04:00)
  • Arrays as Objects (01:58)
  • Clone an Array (01:53)
  • User-defined Arrays (01:51)
  • Initializing Arrays (02:41)
  • Multidimensional Arrays (01:33)
  • Summary (01:22)
Controlling Arrays (19:32)
  • Retrieve Array Items (00:34)
  • For Each Loop (04:00)
  • GetUpperBound Method (02:05)
  • Pass an Array (02:03)
  • System.Array Members (01:23)
  • Sort Arrays (04:19)
  • Search Arrays (04:15)
  • Summary (00:51)
Arrays in .NET (12:01)
  • Array Examples (00:53)
  • Arrays and Text Files (06:20)
  • Resize Theory (01:38)
  • Sort TextLine Array (02:24)
  • Summary (00:44)
ArrayList Class (15:14)
  • Overview (00:49)
  • Add / Insert Method (03:17)
  • AddRange Method (01:46)
  • Manipulate ArrayList (04:20)
  • ArrayList and Text Files (04:20)
  • Summary (00:39)
HashTable and SortedList (14:46)
  • HashTable DataStructure (01:13)
  • Add Item to HashTable (02:05)
  • HashTable Theory (02:52)
  • Assign HashTable Value (01:03)
  • Retrieve From HashTable (01:46)
  • Iterate Through HashTable (02:06)
  • SortedList Class (02:41)
  • Summary (00:56)
Stack Queue and Collections (18:53)
  • Stack And Queue Concepts (01:32)
  • Add Items (02:34)
  • Peek Method (01:56)
  • Pop / Dequeue (03:04)
  • Typed Collections (02:37)
  • Array Problems / Solutions (04:13)
  • FillTextLineCollection (01:50)
  • Summary (01:03)

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)
  • Overview (00:50)
  • Adding Web References (02:26)
  • 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

Operators (52:19)
  • Overview (00:24)
  • AndAlso / OrElse (04:22)
  • Use Operators (01:59)
  • Summary (00:14)
  • Overview (00:37)
  • Overview (01:21)
  • 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 (-16:-36)
  • 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:26)
  • Summary (00:29)
  • Overview (00:48)
  • Overview (01:13)
  • Overview (00:39)
  • Overview (00:32)
  • Overview (00:47)
  • Overview (00:36)
  • 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 (-16:-18)
  • 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 (-13:-02)
  • The Basic Unit of Deployment (02:05)
  • Use ILDASM.EXE (01:55)
  • Private / Shared Assembly (02:09)
  • Deployment Options (-06:-10)
  • 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 (-15:-38)
  • 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 (-15:-32)
  • 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 (01:45)
  • Summary (01:16)
  • Summary (00:21)
  • Summary (00:32)
  • Summary (00:37)
  • Summary (00:34)
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)

Module 16

Operators (52:19)
  • Overview (00:24)
  • AndAlso / OrElse (04:22)
  • Use Operators (01:59)
  • Summary (00:14)
  • Overview (00:37)
  • Overview (01:21)
  • 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 (-16:-36)
  • 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:26)
  • Summary (00:29)
  • Overview (00:48)
  • Overview (01:13)
  • Overview (00:39)
  • Overview (00:32)
  • Overview (00:47)
  • Overview (00:36)
  • 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 (-16:-18)
  • 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 (-13:-02)
  • The Basic Unit of Deployment (02:05)
  • Use ILDASM.EXE (01:55)
  • Private / Shared Assembly (02:09)
  • Deployment Options (-06:-10)
  • 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 (-15:-38)
  • 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 (-15:-32)
  • 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 (01:45)
  • Summary (01:16)
  • Summary (00:21)
  • Summary (00:32)
  • Summary (00:37)
  • Summary (00:34)