Visual Basic How Do I Video Series

WPF Forms over Data Video Series

This how-to video series is focused on data-based application development in Windows Presentation Foundation using Visual Studio 2008.

Presented by Beth Massi

Download Code and Discuss on Code Gallery

You will need: SQL Server or SQL Server 2005 Express and Visual Studio 2008 or Visual Basic 2008 Express

#1 | How Do I: Create a Simple Data Entry Form in WPF?
(24 minutes, 32 seconds)

#2 | How Do I: Display Data in a List in WPF?
(11 minutes, 47 seconds)

#3 | How Do I: Create a Lookup Combobox in WPF?
(23 minutes, 43 seconds)

#4 | How Do I: Hook Up and Display Validation in WPF?
(22 minutes, 20 seconds)

Language Integrated Query (LINQ) Series

This how-to video series is focused on the new LINQ language features of Visual Basic 9.0 included in Visual Studio 2008. LINQ stands for Language Integrated Query, and it enables you to write queries over things like objects, databases, and XML in a standard way using new language syntax. Learn how to use this productive new language feature in your Visual Basic programs.

Presented by Beth Massi

Download Code and Discuss on Code Gallery

You will need: Visual Studio 2008 or Visual Basic 2008 Express

#1 | How Do I: Get Started with LINQ?
(9 minutes, 14 seconds)

#2 | How Do I: Perform Group and Aggregate Queries?
(17 minutes, 22 seconds)

#3 | How Do I: LINQ over DataSets?
(9 minutes, 48 seconds)

#4 | How Do I: Get Started with LINQ to SQL?
(10 minutes, 52 seconds)

#5 | How Do I: Create a One-To-Many Form using LINQ to SQL?
(12 minutes, 29 seconds)

#6 | How Do I: Upgrade Visual Basic Projects to Enable LINQ?
(8 minutes, 28 seconds)

#7 | How Do I: Get Started with LINQ to XML?
(14 minutes, 10 seconds)

#8 | How Do I: Enable XML IntelliSense and Use XML Namespaces?
(13 minutes, 16 seconds)

#9 | How Do I: Create XML Documents from SQL Data?
(15 minutes, 58 seconds)

#10 | How Do I: Create Excel Spreadsheets using LINQ to XML?
(10 minutes, 53 seconds)

Forms over Data Video Series

This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the details of connecting to and querying databases, Windows Forms development basics, Reporting, and Deployment using Visual Basic 2005.

Presented by Beth Massi

Download Code and Discuss on Code Gallery

You will need: SQL Server or SQL Server 2005 Express and Visual Studio or Visual Basic Express

#1 | How Do I: Create a Database?
(17 minutes, 23 seconds)

#2 | How Do I: Connect to a Database?
(10 minutes, 14 seconds)

#3 | How Do I: Create a One-to-Many Data Entry Form?
(5 minutes, 40 seconds)

#4 | How Do I: Create a Search Form?
(5 minutes, 30 seconds)

#5 | How Do I: Create Lookup Lists?
(9 minutes, 48 seconds)

#6 | How Do I: Filter Data on the Client?
(7 minutes, 52 seconds)

#7 | How Do I: Use Auto-Complete?
(7 minutes, 50 seconds)

#8 | How Do I: Format Data in Controls?
(12 minutes, 30 seconds)

#9 | How Do I: Add Validation?
(8 minutes, 56 seconds)

#10 | How Do I: Work with Local Data?
(5 minutes, 31 seconds)

#11 | How Do I: Modify the Database?
(3 minutes, 6 seconds)

#12 | How Do I: Deploy Local Data?
(8 minutes, 17 seconds)

#13 | How Do I: Print Forms?
(4 minutes, 30 seconds)

#14 | How Do I: Build Reports?
(7 minutes, 22 seconds)

#15 | How Do I: Understand Data?
(24 minutes, 8 seconds)

#16 | How Do I: Update Related Tables?
(19 minutes, 51 seconds)

#19 | How Do I: Build Reports Against Remote Data?
(18 minutes, 14 seconds)

#20 | How Do I: Modify Connection Strings at Runtime?
(12 minutes, 11 seconds)

#21 | How Do I: Get Started with the DataGridView?
(13 minutes, 19 seconds)

Visual Basic 2008 Forms over Data Videos

These videos continue our series on data-based Windows Application development, now for Visual Basic 2008. Most of the previous 2005 videos are the same experience in Visual Basic 2008, but these videos will highlight the differences and new capabilities.

Presented by Beth Massi

You will need: SQL Server or SQL Server 2005 Express and Visual Studio 2008 or Visual Basic 2008 Express

Download Code and Discuss on Code Gallery: http://code.msdn.microsoft.com/vbvideosdata

#17 | How Do I: Update Related Tables?
(13 minutes, 43 seconds)

#18 | How Do I: Use DataSets in an N-Tier Application?
(24 minutes, 9 seconds)

#22 | How Do I: Create an Occasionally Connected Application?
(9 minutes, 22 seconds)

#23 | How Do I: Create and Consume a Windows Communication Foundation Service?
(16 minutes, 27 seconds)

#24 | How Do I: Use the DataRepeater Control?
(8 minutes, 58 seconds)

Windows Development Video Series

In this how-to video series Visual Basic developers will learn additional techniques on how to program .NET applications on the Windows platform.

#1 | How Do I: Enable Logging in My Applications?
(25 minutes, 45 seconds)

#2 | How Do I: Enable Tracing in My Applications?
(27 minutes, 30 seconds)

#3 | How Do I: Send Log Files Through E-mail?
(21 minutes, 29 seconds)

#4 | How Do I: Use a Web Service in My Applications?
(11 minutes, 51 seconds)

#5 | How Do I: Deploy Applications with ClickOnce?
(10 minutes, 54 seconds)

#6 | How Do I: Use the ClickOnce Deployment API to Update My App?
(12 minutes, 40 seconds)

#7 | How Do I: Email Unhandled Exceptions?
(25 minutes, 20 seconds)

Office Development Video Series

In this how-to video series Visual Basic developers will learn about the premiere development tools for building Office Business Applications.

#1 | How Do I: Call VSTO Code from VBA?
(18 minutes, 29 seconds)

#2 | How Do I: Deploy an Office Solution Using ClickOnce in Visual Studio 2008?
(9 minutes, 28 seconds)

#3 | How Do I: Use LINQ Against Excel Ranges?
(18 minutes, 44 seconds)

#4 | How Do I: Create a List in Excel that is Connected to a SharePoint List?
(10 minutes, 39 seconds)

#5 | How Do I: Transfer Data Into an Excel Worksheet?
(18 minutes, 44 seconds)

#6 | How Do I: Add Controls to a Document Surface at Runtime?
(16 minutes, 20 seconds)

#7 | How Do I: Use WPF Controls Inside an Excel Actions Pane?
(11 minutes, 0 seconds)

#8 | How Do I: Interact with Web Services from Microsoft Excel?
(25 minutes, 29 seconds)

#9 | How Do I: Use the Ribbon Designer to Customize the Ribbon in Excel?
(17 minutes, 7 seconds)

#10 | How Do I: Consume Database Data in Excel?
(21 minutes, 11 seconds)

#11 | How Do I: Quickly Summarize Data in Excel with Database Functions?
(21 minutes, 14 seconds)

#12 | How Do I: Use XML Mapping in Excel?
(20 minutes, 54 seconds)

#13 | How Do I: Use Event Handlers in an Excel 2007 Add-in?
(12 minutes, 50 seconds)

#14 | How Do I: Use the Find Method in an Excel Add-in?
(15 minutes, 12 seconds)

#15 | How Do I: Automate PowerPoint from an Excel Add-in?
(18 minutes, 14 seconds)

#16 | How Do I: Add a Custom Menu Item to Outlook 2007?
(15 minutes, 38 seconds)

#17 | How Do I: Create Outlook Form Regions Using Visual Studio 2008?
(17 minutes, 10 seconds)

#18 | How Do I: Use Task Panes in Outlook?
(25 minutes, 2 seconds)

#19 | How Do I: Create an Add-in for Microsoft PowerPoint?
(18 minutes, 54 seconds)

#20 | How Do I: Create and Debug a SharePoint Workflow Template?
(15 minutes, 45 seconds)

#21 | How Do I: Use the Excel Web Services?
(16 minutes, 47 seconds)

#22 | How Do I: Use MOSS Enterprise Search in a Client Application?
(15 minutes, 38 seconds)

#23 | How Do I: Access and Manipulate Custom Document Properties in Microsoft Word?
(16 minutes, 40 seconds)

#24 | How Do I: Use Smart Tags in Microsoft Word?
(12 minutes, 33 seconds)

#25 | How Do I: Manage Task Panes in Word Add-ins?
(14 minutes, 53 seconds)

#26 | How Do I: Customize Outlook Item Context Menus?
(14 minutes, 32 seconds)

#27 | How Do I: Deploy a VSTO Add-In?
(15 minutes, 53 seconds)

#28 | How Do I: Add Smart Tags to Excel Workbooks?
(13 minutes, 19 seconds)

Object Binding Video Series

This how-to video series is focused on more advanced data binding techniques using object binding in Visual Basic 2005. The series walks through creating business objects and how to associate them in one-to-many relationships, how to provide searching capabilities and how to enable sorting.

Presented by Beth Massi

Download the Code: Videos 1–3 | Video 4

You will need: Visual Studio or Visual Basic Express

#1 | How Do I: Do Simple Object Binding?
(7 minutes, 34 seconds)

#2 | How Do I: Add Search Support with Object Binding?
(7 minutes, 0 seconds)

#3 | How Do I: Add Sorting Support with Object Binding?
(10 minutes, 19 seconds)

#4 | How Do I: Add Filter Support?
( 9 minutes, 33 seconds)

Visual Basic Interop Video Series

This how-to video series is focused on the Interop Forms Toolkit and working with Visual Basic .NET and Visual Basic 6 together. The Interop Forms Toolkit allows Visual Basic developers to migrate their Visual Basic 6 applications over to .NET using a phased migration strategy. Instead of having to convert the entire VB6 application at once, the toolkit enables .NET Forms and User Controls to run directly in Visual Basic 6 applications so that you can build the pieces that you need over time.

Presented by Beth Massi

Download the Code: Videos 1–3

You will need: Visual Studio and the Interop Forms Toolkit 2.0 in addition to Visual Basic 6.0

#1 | How Do I: Build Interop Forms?
(11 minutes, 28 seconds)

#2 | How Do I: Build Interop User Controls?
(9 minutes, 3 seconds)

#3 | How Do I: Deploy Hybrid Applications?
(6 minutes, 1 second)

Security Video Series

In this how-to video series Visual Basic developers will explore a variety of security questions, including encryption, handling attacks, security best practices, and a lot more.