Title |
Description |
Source |
Discovering Database Structure with VB .NET
|
When you build a database yourself, you know what you've put in it. But what do you do if you have a legacy database thrust upon you? How do you figure out what tables are present? What fields are in the tables? How are the tables related? This article explains some useful techniques for learning about the structure of an MSDE or SQL Server database using Visual Basic .NET.
See also my book Visual Basic .NET Database Programming.
|
InformIT
|
Executing Ad Hoc Queries with VB .NET
|
Database applications typically include an assortment of prepackaged queries and reports, but no application can anticipate every user's needs. An ad hoc query system allows an application to meet unforeseen requirements. Rod Stephens explains how to use VB .NET database objects to perform queries and manipulate the database by executing SQL scripts.
See also my book Visual Basic .NET Database Programming.
|
InformIT
|
Twos Complement Numbers
|
This article explains twos complement representations for numbers. This information can help you understand which bits are set to represent integer values.
|
VB Helper
|
Using Floating Point Numbers
|
This article explains some obscure and puzzling bugs that can occur when you use floating point numbers.
See also my book Bug Proofing Visual Basic.
|
VB Helper
|
Introduction to DataSets with Visual Basic .NET
|
ADO stores data in a relatively simple Recordset object. ADO.NET, on the other hand, uses a bewildering assortment of classes including DataSet, DataTable, DataColumn, and various constraint objects. Rod Stephens provides an introduction to the most basic of these classes, and shows how you can use them to manage data in a simple database application.
See also my book Visual Basic .NET Database Programming.
|
InformIT
|
S. Ibaraki Interviews Rod Stephens
|
In this interview, Stephen Ibaraki asks for tips, things I've learned in past projects, development topics to watch, and more.
|
Canadian Information Processing Society
|
Binding Controls with VB .NET
|
Would you believe that you can make a program that lets the user view, insert, update, and delete records in a database table with only two lines of code? You can by using bound controls. Rod Stephens explains how you can bind controls to data at design time or at runtime to provide simple but powerful database access with no muss or fuss.
See also my book Visual Basic .NET Database Programming.
|
InformIT
|
Getting Started with MSDE and VB .NET
|
Access databases are cheap, but they work well only for small, single-user applications. SQL Server is powerful enough to support huge databases with multiple simultaneous users, but it is very expensive. What if you're stuck somewhere in between? Rod Stephens explains how you can use MSDE to build small multiuser applications while preparing to scale up if your database needs increased performance.
See also my book Visual Basic .NET Database Programming.
|
InformIT
|
Automating the build process of a Visual Basic project
|
This tutorial explains how to use Windows Scripting Host to run the scripts, and use nmake to compile the project
|
Sridhar Natarajan
|
Getting Started with VB 6 and XML
|
VB.NET includes a lot of built-in support for XML but there's no reason to wait for VB.NET to use XML. This article explains how you can take advantage of XML in your VB 6 applications right now!
See also my book Visual Basic.NET and XML.
|
InformIT
|
VB.NET + XML = Object DB
|
When most programmers think about databases, they think of relational databases. Other kinds of databases are also sometimes very useful. This article explains how you can use XML to build your own object databases.
See also my book Visual Basic.NET and XML.
|
InformIT
|
VB.NET + XML = Undo/Redo
|
Undo and redo features are de rigueur in high-quality professional applications, yet no one tells you how to build them. This article explains how to use XML to add undo and redo features to your applications with ease.
See also my book Visual Basic.NET and XML.
|
InformIT
|
Where Was I? Restoring Application State with VB and XML
|
In complex applications, users spend a lot of time arranging forms, opening windows, and performing other startup chores. You can make this easier by having the application store and restore its state when it stops and restarts. This article shows how to use XML to save and restore program state quickly and easily.
See also my book Visual Basic.NET and XML.
|
InformIT
|
Reasons to Prototype in Visual Basic
|
Aircraft and automobile manufacturers don't start a multi-million dollar project without prototyping first. Why should you? This article explains some of the reasons you might want to build a prorotype before starting a software project. Once you know what's at stake, you can learn more about prototyping in Visual Basic from my book coincidentally named Prototyping with Visual Basic.
|
InformIT
|
Query By Example
|
The most useful prototypes are up and running quickly so users can provide feedback early on. This article, based on my book Prototyping with Visual Basic, explains how you can add a query by example feature to your database prototype quickly and easily.
|
InformIT
|
Making a Splash
|
First impressions can make or break a project. This article, based on my book Prototyping with Visual Basic, shows how to make eye-catching splash screens that will make your application the talk of the water cooler!
|
InformIT
|
Tales from the Trenches
|
Prototyping with Visual Basic uses amusing true stories to make a lot of important points. This article contains some of the more interesting stories. Have a chuckle at my expense!
|
InformIT
|
Steganography: Hidden in Plain Sight
|
This article explains basic steganography: the art of hiding information within other information. It shows a simple method for hiding text in an image.
|
|
Building Property Pages
|
This article explains the basic steps to building property pages for a new ActiveX control.
|
|
Screen Resolution
|
This article discusses several different ways to handle screens with different resolutions.
|
|
Cryptography
|
A series of articles on interesting topics in cryptography.
|
|
More on error handling
|
Lots of discussion of error handling by Per Sjoborg, based in part on my book Bug Proofing Visual Basic.
|
PUCC Multimedia
|
Using Direct3D with VB
|
An introduction to using Direct3D for higher performance three-dimensional graphics.
|
VB Explorer
|
International Character Sets
|
Describes character sets and shows how to select them for different languages.
|
Chris Wagg
|
Background Color
|
Notes on background colors and a routine that sets background color for the TreeView control.
|
Mike Klein
|
Direct3D
|
I'm writing this ongoing series of articles on Direct3D. The final goal is to build a 3-D maze war game.
|
VB Explorer
|
Internationalization
|
Tips and tricks for building international applications.
|
|
Sorting Viewer |
This program on Rick Meyer's Web site demonstates several different sorting algorithms. |
Makai's VISUAL BASIC & HTML Programming |
Does P = NP?
|
This article describes the sets P and NP, asks the question "does P = NP?" and explains why that question is of profound philosophical and practical importance.
|
|
ADO Tools
|
This is a talk I gave to the Denver Area Visual Basic User's Group metting on 1/24/00.
|
|
Constructors in VB
|
This article on the PUCC Multimedia Web site explains how to use constructors to initialize objects in VB.
|
PUCC Multimedia
|
Introduction to ADO
|
This is a PowerPoint presentation I gave to the Denver Area Visual Basic User's Group lab metting on 9/20/99.
|
|
Working With Remote Database Times
|
This article on SmithVoice.com explains how to use GMT times to coordinate data access from different locations around the world.
|
Robert Smith
|
Drawing Platonic Solids
|
This article explains how to calculate the
coordinates of the corners of the Platonic solids:
tetrahedron, cube (hexahedron), octahedron,
dodecahedron, and icosahedron.
|
For more information on three-dimensional graphics, see
Visual Basic Graphics Programming
|
An Introduction to Visual Basic
(Leads to a different Web site)
|
Provides an introduction to Visual Basic, explaining fundamentals such as loops, subroutines, etc. Compares VB to Delphi. |
Peter McMahon, CEO, !Run Software |
Error Handling Fundamentals
|
Explains the basics of using error handlers to protect a
program from unexpected errors. |
Bug Proofing Visual Basic book |
Object Serialization
|
Make complex objects save and restore themselves
quickly and easily. |
Microsoft Office & Visual Basic for Applications Developer (MOD) magazine |
Beyond Flatland |
3-D graphics and 3-D surface drawing in Visual Basic. |
Visual Basic
Developer magazine |
FlappingFlag Control |
An ActiveX control demonstrating image processing and animation in VB5/6 |
Custom Controls Library book |
Slightly Irregular |
Irregular and sparse arrays, and other memory-saving data structures |
Microsoft Office & Visual Basic for Applications Developer (MOD) magazine |
Sorting It Out |
Sorting algorithms |
Visual Basic
Developer magazine |