Expert one-on-one Visual BASIC 2005 database programming

621 Pages·2005·12.134 MB·English

by  Roger Jennings

GGeettPPeeddiiaa :: GGeett HHooww SSttuuffff Works!

Works!

Welcome To GetPedia.com : The Online Information Resource.

Search GetPedia

Business Communications Health & Fitness
Advertising Broadband Internet Acne
Branding Mobile & Cell Phone Aerobics & Cardio
Business Management VOIP Alternative Medicine
Business Ethics Video Conferencing Beauty Tips
Careers, Jobs & Employment Satellite TV Depression
Customer Service Diabetes
Reference & Education
Marketing Exercise & Fitness
Networking Book Reviews Fitness Equipment
Network Marketing College & University Hair Loss
Pay-Per-Click Advertising Psychology Medicine
Presentation Science Articles Meditation
Public Relations Muscle Building & Bodybuilding
Food & Drinks
Sales Nutrition
Coffee
Sales Management Nutritional Supplements
Cooking Tips
Sales Telemarketing Weight Loss
Recipes & Food and Drink
Sales Training Yoga
Wine & Spirits
Small Business
Strategic Planning Recreation and Sport
Home & Family
Entrepreneur
Fishing
Negotiation Tips Crafts & Hobbies
Golf
Team Building Elder Care
Martial Arts
Top Quick Tips Holiday
Motorcycle
Home Improvement
Internet & Businesses Online
Home Security Self Improvement & Motivation
Affiliate Revenue Interior Design & Decorating Attraction
Blogging, RSS & Feeds Landscaping & Gardening Coaching
Domain Name Babies & Toddler Creativity
E-Book Pets Dealing with Grief & Loss
E-commerce Parenting Finding Happiness
Email Marketing Pregnancy Get Organized - Organization
Ezine Marketing
Leadership
News & Society
Ezine Publishing
Motivation
Forums & Boards Dating
Inspirational
Internet Marketing Divorce
Positive Attitude Tips
Online Auction Marriage & Wedding
Goal Setting
Search Engine Optimization Political
Innovation
(SEO) Relationships
Spirituality
Spam Blocking Religion
Stress Management
Streaming Audio & Online Sexuality
Success
Music
Computers & Technology Time Management
Traffic Building
Computer Hardware Writing & Speaking
Video Streaming
Data Recovery & Computer
Web Design Article Writing
Backup
Web Development Book Marketing
Game
Web Hosting Copywriting
Internet Security
Web Site Promotion Public Speaking
Personal Technology
Writing
Finance Software
Travel & Leisure
Credit
Arts & Entertainment
Currency Trading Aviation & Flying
Casino & Gambling
Debt Consolidation Cruising & Sailing
Humanities
Debt Relief Outdoors
Humor & Entertainment
Loan Vacation Rental
Language
Insurance
Music & MP3 Cancer
Investing
Philosophy Breast Cancer
Mortgage Refinance
Photography Mesothelioma & Asbestos
Personal Finance
Poetry Cancer
Real Estate
Taxes Shopping & Product Reviews
Stocks & Mutual Fund
Book Reviews
Structured Settlements
Fashion & Style
Leases & Leasing
Wealth Building

Copyrigh t © 2006
GetPedia | Links

01_57678x ffirs.qxd 11/10/05 11:25 PM Page iii
Expert One-on-One™ Visual Basic®2005
Database Programming
Roger Jennings
01_57678x ffirs.qxd 11/10/05 11:25 PM Page i
Expert One-on-One™ Visual Basic®2005
Database Programming
01_57678x ffirs.qxd 11/10/05 11:25 PM Page ii
01_57678x ffirs.qxd 11/10/05 11:25 PM Page iii
Expert One-on-One™ Visual Basic®2005
Database Programming
Roger Jennings
01_57678x ffirs.qxd 11/10/05 11:25 PM Page iv
Expert One-on-One™ Visual Basic®2005
Database Programming
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2006 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN-13: 978-0-7645-7678-2
ISBN-10: 0-7645-7678-X
Printed in the United States of America
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1B/TQ/RR/QV/IN
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section
107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or
authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222
Rosewood Drive, Danvers, MA01923, [phone], fax [phone]. Requests to the Publisher for permission
should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN
46256, [phone], fax [phone] or online at http://www.wiley.com/go/permissions.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY:THE PUBLISHER AND THE AUTHOR MAKE NO REP-
RESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACYOR COMPLETENESS OF THE CON-
TENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT
LIMITATION WARRANTIES OF FITNESS FOR APARTICULAR PURPOSE. NO WARRANTYMAYBE CREATED
OR EXTENDED BYSALES OR PROMOTIONALMATERIALS. THE ADVICE AND STRATEGIES CONTAINED
HEREIN MAYNOT BE SUITABLE FOR EVERYSITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING
THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFES-
SIONALSERVICES. IF PROFESSIONALASSISTANCE IS REQUIRED, THE SERVICES OF ACOMPETENT PROFES-
SIONALPERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALLBE LIABLE
FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO
IN THIS WORK AS ACITATION AND/OR APOTENTIALSOURCE OF FURTHER INFORMATION DOES NOT
MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR
WEBSITE MAYPROVIDE OR RECOMMENDATIONS IT MAYMAKE. FURTHER, READERS SHOULD BE AWARE
THAT INTERNET WEBSITES LISTED IN THIS WORK MAYHAVE CHANGED OR DISAPPEARED BETWEEN
WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.
For general information on our other products and services please contact our Customer Care Department
within the United States at [phone], outside the United States at [phone] or fax [phone].
Trademarks:Wiley, the Wiley logo, Wrox, the Wrox logo, Programmer to Programmer, and related trade
dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United
States and other countries, and may not be used without written permission. Linux is a registered trademark
of Linus Torvalds. MySQLis a registered trademark of MySQLAB ACompany. All other trademarks are the
property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor
mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not
be available in electronic books.
01_57678x ffirs.qxd 11/10/05 11:25 PM Page v
About the Author
Roger Jennings
Roger Jennings is an author and consultant specializing in Microsoft Visual Basic .NET n-tier and
client/server database applications, and data-intensive ASP.NET Web services. He’s been a member of
the beta test team for all versions of Visual Basic starting with the Professional Extensions for Visual
Basic 2.0 (code-named Rawhide) and Visual Studio, all releases of Microsoft SQLServer starting with
version 4.2 for OS/2, every version of Microsoft Access, and all Windows client and server operating
systems beginning with the Windows 3.0 Multimedia Extensions.
Roger’s 25 computer-oriented books have more than 1.25 million English copies in print and have been
translated into more than 20 languages. He’s the author of three editions of Database Developer’s Guide
to Visual Basic (SAMS Publishing), two editions of Access Developer’s Guide (SAMS), nine editions of
Special Edition Using Microsoft Access (QUE Publishing), and two editions of Special Edition Using
Windows NT 4.0 Server (QUE). He has also written developer-oriented books about Windows 3.1 multi-
media, Windows 95, Windows 2000 Server, Active Directory Group Policy, Visual Basic .NET Web
services, and Microsoft Office InfoPath 2003 SP-1. Roger is a contributing editor of Fawcette Technical
Publications’ Visual Studio Magazine and a columnist for Fawcette’s .NETInsight and XML& Web
Services Insight newsletters.
Roger has more than 25 years of computer-related experience, beginning with real-time medical data
acquisition and chemical process control systems driven by Wang 700 calculators/computers. He is
a principal of OakLeaf Systems, a Northern California software consulting firm, the developer of
the OakLeaf XMLWeb Services site (www.oakleaf.ws/), and author of the OakLeaf Systems weblog
(oakleafblog.blogspot.com). His OakLeaf Code of Federal Regulations (CFR) ASP.NET Web service
and client (www.oakleaf.ws/cfr/) projects won the charter Microsoft .NET Best Award for Horizontal
Solutions (www.microsoft.com/presspass/features/2002/aug02/08-07netwinners.mspx).
You can reach Roger at [email protected].
01_57678x ffirs.qxd 11/10/05 11:25 PM Page vi
01_57678x ffirs.qxd 11/10/05 11:25 PM Page vii
Credits
Executive Editor Vice President and Publisher
Robert Elliott Joseph B. Wikert
Development Editor Quality Control Technicians
Adaobi Obi Tulton Leeann Harney
Jessica Kramer
Technical Editor Joe Niesen
Thomas Rizzo
Project Coordinator
Production Editor Michael Kruzil
Pamela Hanley
Graphics and Production Specialists
Copy Editor Carrie Foster
Nancy Rapoport Denny Hager
Barbara Moore
Editorial Manager Alicia B. South
Mary Beth Wakefield
Proofreading and Indexing
Production Manager TECHBOOKS Production Services
Tim Tate
Vice President & Executive Group Publisher
Richard Swadley