Professional ADO.NET 2
Programming with SQL Server 2005,
Oracle®, and MySQL®
Wallace B. McClure
Gregory A. Beamer
John J. Croft IV
J. Ambrose Little
Bill Ryan
Phil Winstanley
David Yack
Jeremy Zongker
01_584375 ffirs.qxd 10/28/05 10:49 PM Page iii
Professional ADO.NET 2
Programming with SQL Server 2005,
Oracle®, and MySQL®
01_584375 ffirs.qxd 10/28/05 10:49 PM Page i
01_584375 ffirs.qxd 10/28/05 10:49 PM Page ii
Professional ADO.NET 2
Programming with SQL Server 2005,
Oracle®, and MySQL®
Wallace B. McClure
Gregory A. Beamer
John J. Croft IV
J. Ambrose Little
Bill Ryan
Phil Winstanley
David Yack
Jeremy Zongker
01_584375 ffirs.qxd 10/28/05 10:49 PM Page iii
Professional ADO.NET 2 Programming with SQL Server

FROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS WORK AS A
CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT
THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR
WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE
AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAP-
PEARED 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 (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.
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. MySQL is a registered trademark of MySQL AB A Company. 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_584375 ffirs.qxd 10/28/05 10:49 PM Page iv
About the Authors
Wallace B. McClure
Wallace B. McClure graduated from the Georgia Institute of Technology in 1990 with a bachelor of
science degree in electrical engineering. He continued his education there, receiving a master’s degree in
the same field in 1991. Since that time, he has done consulting and development for such companies as
Coca-Cola, Bechtel National, Magnatron, and Lucent Technologies, among others. Products and
services have included work with ASP, ADO, XML, and SQL Server, as well as numerous applications in
the Microsoft .NET Framework. Wally McClure specializes in building applications that have large
numbers of users and large amounts of data. He is a Microsoft MVP and an ASPInsider, and a partner in
Scalable Development, Inc. You can read Wally’s blog at
/>/.
Gregory A. Beamer
Gregory A. Beamer is a solutions architect specializing in Microsoft Internet technologies. Greg got

and
www.knowdotnet.com
) and his blog
www.msmvps.com/WilliamRyan
. After earning his master’s degree in business administration, Bill
began work as a statistical analyst, but quickly realized that his true love was programming. He has
worked in multiple industries, including financial services/securities, manufacturing, health care, phar-
maceuticals, and, currently, consulting. Bill is a frequent speaker at user’s group meetings, has spoken at
multiple Microsoft Code Camps, and has hosted multiple MSDN Webcasts. Although technologically
related things consume most of his time, Bill’s other interests include cult films, economics,
Freemasonry, cuckoo clocks, and, most important, his girlfriend, Kim, and her daughter, Sarah.
Phil Winstanley
Phil Winstanley is a Web applications developer working for Portfolio Europe, located in Manchester,
England. He has been involved with ASP.NET since its inception, and has developed a deep understand-
ing of the platform. As a Microsoft MVP (Most Valuable Professional), member of the ASPInsiders,
co-owner of Microsoft Web Developers UK, and the North West England Regional Director for the .NET
Exchange, Phil is deeply embedded in the development community and works closely with the Web
Platforms team at Microsoft, regularly visiting the developers in Redmond, Washington.
David Yack
David is the president of Colorado Technology Consultants, Inc. He is a hands-on technology
consultant with solid management experience in privately held and Fortune 500 companies and has over
15 years of experience in the IT industry. David is currently responsible for leading Colorado Technology
Consultants’ focus on Microsoft .NET technologies. David is an active participant in the Microsoft
development community, ranging from the Denver .NET user group to Microsoft’s Public Communities,
such as
www.asp.net
and

. David is the leader of the South Colorado .NET
user group. David is recognized by Microsoft as a .NET MVP (Most Valuable Professional).

John Greenough
Media Development Specialists
Angela Denny
Kit Malone
Travis Silvers
Proofreading and Indexing
TECHBOOKS Production Services
01_584375 ffirs.qxd 10/28/05 10:49 PM Page vii
01_584375 ffirs.qxd 10/28/05 10:49 PM Page viii
For my wife, Ronda, my two children, Kirsten and Bradley, and the rest of my family.
—Wallace B. McClure
To my loving wife and four daughters, and to God, without whom the aforementioned miracles would
not be possible.
—Greg Beamer
To my wife, Valerie, for her support, and to my boys, Jack and Conor, for their patience on the weekends
while I was writing.
—John J. Croft IV
To my mom and stepfather, for putting up with me all of these years and always being there. To my
girlfriend, Kim, and her daughter, Sarah, for always being able to make me smile.
—Bill Ryan
For my wife, Julie, and my two great kids, Drew and Jacqueline.
—David Yack
For my wife, Jeanette, for her support, patience, and understanding during the many hours I worked on
this book.
—Jeremy Zongker
To my caring father and mother, my loving brother, and to the Almighty, for giving me the power to
work every day.
—Anand Narayanaswamy,
Technical Editor
01_584375 ffirs.qxd 10/28/05 10:49 PM Page ix