VB Code Helper


	Computer Science 105, 106, & 205

VB.Net Code Snippets for Visual Basic

When you need code for a specific job, then check out this list. Instead of scrounging around in your notes, I put some major code snippets here for you. In most cases they are copied from our VB classroom projects.

General Visual Basic Stuff	Collections For-Each Loop for a Windows application How to clear textboxes & radio buttons from the controls collection even if the form has a container control. Regular Expressions Some useful expressions VB Classes Summary Handout on classes Data Validation Validation Control Project Trapping keystrokes using Console & ControlChars namespaces How to get maps from MapQuest Create a search string
Data Entry	Assign data from textbox to label Copy selected item in Listbox to a textbox How to concatenate strings Simple math operations (computing sales tax) How to display items & pricing as currency
Using List Boxes/ Multiline Textboxes	Load list box from an arraylist Add Item to list box Remove list box item Add items from a dataset Load list box with items, pricing, & photo information Getting the list box items, pricing, & photo information Adding Items & Prices to a list box in one string Using a For-Each loop to save list box items Read filenames from a folder to a multiline textbox or list box Get the project Get the code
Using Controls	Web Browser control How to display image in a picture box
If , Select Case, & Do Loops	Using YES-NO buttons on message box Intro to using SELECT CASE Using IF END IF blocks instead of SELECT CASE For-Next Loops For Each Loops & the controls collection How to clear textboxes & radiobuttons from the controls collection even if the form has a container control. Using Do Loops Getting a users PIN number
Formatting Strings	How to format numbers How to format data as currency
String Functions	How to use the MID function How to use the LEFT function How to use the TRIM functions How to use vbCrLf How to use String.Replace
Variables	How to use module-level variables Using Totals & Counts with module-level variables

Forms & Functions	Multiple Forms Managing Multiple forms How to get data from one form and put it on another How to close all open forms Trapping Keystrokes Make the Enter Key work like Tab & how to limit data entry to just numbers or letters How to use the Keypress/Down/Up events to trap keys Functions How to create custom functions
File I/O	Reading & Writing to Disk Files and Error Handling Reading from a disk (simple) Using Variables for File Handles Using Custom Subroutines & Structured Error Handlers Reading & Writing to Disk Files using Streams Using Streams with Using Structure and For-Each loop How to search a text file for customer Read filenames from a folder to a textbox or listbox Get the project Get the code
Custom Classes	Math Solver How to call your custom classes Book Manager Keep running totals of customer activity inside a class Using Shared Members How to put your functions inside a class module
Multimedia	Music Box How to play wav files Media Demo How to play .wma, .wmv, .avi files
Custom Controls	Data Validation & Specialty Controls RK_Textbox control RK USA States control RK Masked TextBox (SS#, Tele, Zip)
Inheritance, XML documentation, & Windows Help tool.	Inheritance Project (Lesson 9) Using custom classes through inheritance Shows Help authoring tool you can buy and how to use XML documentation in your methods so they appear in intellisense & the object browser.
Working With Excel & VB	Importing Excel Data How to Import Excel Data into VB (Windows app) How to Export Excel Data into VB (Windows app)
Access Databases & ADO	Using ADO in Code Declaring your OLE ADO objects Get current record in dataset Add Databinding to textboxes Navigate a dataset Insert new record and/or update DB Delete record in DB Using BindingManager and Custom controls How to navigate a database with your own textboxes in code ADO class with Insert/Update/Delete Functions
Access DB & Wizards (VS2010 Version)	Show Images with Details View Confirm Delete records Search by last name Screen Shots of SQL query See my all Features Demo (VS2010) Creating a new SQL query document.
SQL Databases & ADO 2.0	Learning SQL for VB SQL Search string samples The ADO Model (slides) SQL Server Authentication Modes Using the MS Access Upsizing Wizard Using ADO in Code with the DataGridView Control Display data in a grid Find the selected row in a DataGridView Find the contents of a cell inside the grid. Update DatagridView changes Modify records using the DataGridView Delete record from DataGridView DataGridView Secrets DataGridView Tips & Tricks How to get cell data, row index, delete a row, cycle through the rows, etc. Code samples from Lesson 16 ADO for SQL Database Class Declaring ADO objects Class Stored Procedure Class SQL Stored procedures Store connection string in app.config Conn String with AttachDB function Using a combo box and grid (Bound controls) Using my custom ADO classes Declaring ADO in a separate class Using a class to manage ADO functions How to bind a listbox to DB table How to format DataGridView Cells SQL Command Object (Lesson 18) Parameterized Queries Using SQL Transactions SQL User Instances Run sp_configure in SQL Management Studio query window: -- Enable user instances. sp_configure 'user instances enabled','1' -- Disable user instances. sp_configure 'user instances enabled','0' Then execute the query
SQL 2005 & XML	Using XML Reader/Writers (See Lesson 18) Reading SQL Data into XML and saving data to XML file

VB.Net Support

.Net Classes
VB.Net Language
VB Keywords This lists the reserved or keywords of the VB language. I will show you how to turn this page into a "help" page on your computer
VB Data Types This lists the major data types we will be using.!
Quick Start Tutorials

Database Resources

The ADO Model
ADO Primer/examples
MS Access and ADO
SQL Server Books On Line (Excellent)
SQL Language tutorial
Adding A Crystal Report to your project
How to format DataGridView Cells
Tips & Tricks
DataGridView Secrets
How to handle Concurrency Errors

Return to Main Menu