Asp.Net Database Programming Weekend Crash Course

409 Pages·2002·3.166 MB·English

by  Jason Butler, Tony Caudill

4830-1 cover 10/25/01 2:13 PM Page 1
BUTLER
GGeett UUpp ttoo SSppeeeedd oonn AASSPP..NNEETT
CAUDILL ASP.NET
DDaattaabbaassee PPrrooggrraammmmiinngg ——
iinn aa WWeeeekkeenndd!!
CD-ROM INCLUDES:
15
T
he big day is Monday. The day you get to show off what you
• Assessment software
know about ASP.NET database programming. The problem is, you’re not DATABASE PROGRAMMING
to help gauge your
progress really up to speed. Maybe it’s been a while since you worked with
Active Server Pages. Or maybe you’re new to Microsoft .NET or database HOUR
• General Membership
programming. In any event, we’ve got a solution for you — ASP.NET WEEKEND
on Brinkster.com
Database Programming Weekend Crash Course. Open the book Friday CRASH
Web Hosting Service WWEEEEKKEENNDD CCRRAASSHH CCOOUURRSSEE™
evening and on Sunday afternoon, after completing 30 fast, focused COURSE
• .NET Compression sessions, you’ll be able to jump right in and start to create dynamic,
Library trial version data-driven Web applications. It’s as simple as that.
WW A
• BrowserHawk S
The Curriculum P
evaluation version EE
.
FRIDAY SATURDAY, continued SUNDAY EE N
• Infragistics
Evening: 4 Sessions, 2 Hours Afternoon: 6 Sessions, 3 Hours Morning: 6 Sessions, 3 Hours KK E
UltraSuite and • Introducing ASP.NET • Validating User Input • Introducing Datasets, T
ASPUpload trial • Setting Up .NET • Maintaining State in Part II ENEN D
versions • Designing a Database ASP.NET • Data Binding A
• SQL, A Primer • Authentication and • Using the DataGrid Control DD T JASON
• Sample code from Authorization with Bound Data A 15
BUTLER
• ASP.NET Caching • Beating the CRUD out of
the book SATURDAY B
• Introducing ADO.NET the DataGrid CC
Morning: 6 Sessions, 3 Hours A TONY
• Databases, A Primer on • NObavjeicgta tMinogd eTlhe ADO.NET • DAaDtOa. NSEhTaping with RR S CAUDILL
SQL Server 2000 E
• Handling ADO.NET Errors AA
• XML, A Primer
P
• Developing ASP.NET Pages Evening: 4 Sessions, 2 Hours SS
Afternoon: 4 Sessions, 2 Hours R HOURS
• Opening a Connection
• Using HTML Controls HH
• Executing Commands • SOAP O
• Using ASP.NET Controls
• Using The DataReader • Web Services G
• User Controls
Object • Migrating From ASP to CC R 30 Sessions That
• Introducing Datasets, ASP.NET OO A CD-ROM Will Have You
Part I • Migration From ADO to
M
ADO.Net
UU with assessment Creating Dynamic,
M
RR software, sample Data-Driven Web
I
System Requirements: ISBN 0-7645-4830-1 SS N code, and more Applications in
Pentium PC running Windows 95 EE G
or later, Windows NT 4 or later. *85555-AIABIi For more information on ,!7IA7G4-feidah!:P;m;o;t;T Only 15 Hours
128 MB RAM. See the About the Hungry Minds, go to ™
CDAppendix fordetails and www.hungryminds.com
complete system requirements.
$24.99 US
Category: $37.99 CAN
Programming/Web Development £19.99 UK incl. VAT
014830-1 FM.F 11/7/01 9:00 AM Page i
ASP.NET
Database Programming
Weekend Crash Course™
Jason Butler and Tony Caudill
Cleveland, OH • Indianapolis, IN • New York, NY
014830-1 FM.F 11/7/01 9:00 AM Page ii
ASP.NET Database Programming Weekend Computer Publishing Corporation, Inc., for the
Crash Course™ Philippines; by Contemporanea de Ediciones for
Published by Venezuela; by Express Computer Distributors for
Hungry Minds, Inc. the Caribbean and West Indies; by Micronesia Media
909 Third Avenue Distributor, Inc. for Micronesia; by Chips
New York, NY 10022 Computadoras S.A. de C.V. for Mexico; by Editorial
www.hungryminds.com Norma de Panama S.A. for Panama; by American
Copyright © 2002 Hungry Minds, Inc. All rights Bookshops for Finland.
reserved. No part of this book, including interior For general information on Hungry Minds’ products
design, cover design, and icons, may be reproduced and services please contact our Customer Care
or transmitted in any form, by any means (elec- department within the U.S. at 800-762-2974, out-
tronic, photocopying, recording, or otherwise) with- side the U.S. at 317-572-3993 or fax [phone].
out the prior written permission of the publisher. For sales inquiries and reseller information, includ-
Library of Congress Catalog Card No.: 2001089343 ing discounts, premium and bulk quantity sales,
ISBN: 0-7645-4830-1 and foreign-language translations, please contact
Printed in the United States of America our Customer Care department at 800-434-3422, fax
10 9 8 7 6 5 4 3 2 1 317-572-4002 or write to Hungry Minds, Inc., Attn:
IB/SZ/RR/QR/IN Customer Care Department, 10475 Crosspoint
Distributed in the United States by Hungry Minds, Boulevard, Indianapolis, IN 46256.
Inc. For information on licensing foreign or domestic
Distributed by CDG Books Canada Inc. for Canada; rights, please contact our Sub-Rights Customer Care
by Transworld Publishers Limited in the United department at 212-884-5000.
Kingdom; by IDG Norge Books for Norway; by IDG For information on using Hungry Minds’ products
Sweden Books for Sweden; by IDG Books Australia and services in the classroom or for ordering exam-
Publishing Corporation Pty. Ltd. for Australia and ination copies, please contact our Educational Sales
New Zealand; by TransQuest Publishers Pte Ltd. for department at 800-434-2086 or fax [phone].
Singapore, Malaysia, Thailand, Indonesia, and Hong For press review copies, author interviews, or other
Kong; by Gotop Information Inc. for Taiwan; by ICG publicity information, please contact our Public
Muse, Inc. for Japan; by Intersoft for South Africa; Relations department at 317-572-3168 or fax
by Eyrolles for France; by International Thomson 317-572-4168.
Publishing for Germany, Austria, and Switzerland; For authorization to photocopy items for corporate,
by Distribuidora Cuspide for Argentina; by LR personal, or educational use, please contact
International for Brazil; by Galileo Libros for Chile; Copyright Clearance Center, 222 Rosewood Drive,
by Ediciones ZETA S.C.R. Ltda. for Peru; by WS Danvers, MA 01923, or fax [phone].
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND AUTHOR HAVE USED THEIR
BEST EFFORTS IN PREPARING THIS BOOK. THE PUBLISHER AND AUTHOR MAKE NO REPRESENTA-
TIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS
OF THIS BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR
FITNESS FOR A PARTICULAR PURPOSE. THERE ARE NO WARRANTIES WHICH EXTEND BEYOND THE
DESCRIPTIONS CONTAINED IN THIS PARAGRAPH. NO WARRANTY MAY BE CREATED OR EXTENDED
BY SALES REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ACCURACY AND COMPLETENESS
OF THE INFORMATION PROVIDED HEREIN AND THE OPINIONS STATED HEREIN ARE NOT GUARAN-
TEED OR WARRANTED TO PRODUCE ANY PARTICULAR RESULTS, AND THE ADVICE AND STRATEGIES
CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY INDIVIDUAL. NEITHER THE PUBLISHER
NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES,
INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES.
Trademarks:Hungry Minds, the Hungry Minds logo, Weekend Crash Course and related trademarks are
trademarks or registered trademarks of Hungry Minds, Inc. in the United States and other countries and
may not be used without written permission. All other trademarks are the property of their respective
owners. Hungry Minds, Inc., is not associated with any product or vendor mentioned in this book.
is a trademark of Hungry Minds, Inc.
014830-1 FM.F 11/7/01 9:00 AM Page iii
About the Authors
Jason Butleris a Principal Consultant with PricewaterhouseCoopers LLP. Jason has built
numerous Microsoft-centric Web applications for Fortune 500 companies. When not writing
code, he religiously works out at a gym near his home in northern Virginia. Jason is also a
devoted Hootie & The Blowfish fan.
Tony Caudillis a Principal Consultant at PricewaterhouseCoopers LLP. Tony has written and
deployed custom Microsoft Solutions for twenty Fortune 500 Companies to support the inte-
gration of SAP, Siebel, and other ERP/CRM applications. When not managing system imple-
mentation projects, he avidly pursues surfing in southern California at his favorite beaches
and tackles skiing at Big Bear.
Dedications
I would like to dedicate this book to my family and friends who have provided
me with tremendous support and happiness throughout my life. To my mother,
Marian, for inspiring me to be that best person that I possibly can. To Donna,
without whose support, encouragement, and patience this book would never
have been completed. To my father, Al, for always providing much needed
advice and support. And to my stepfather, Steve, for being who you didn't have
to be. I would also like to send my prayers to all of the families impacted by
the tragic events of September 11, 2001.
- Jason
I would like to dedicate this book to my family and friends, who have
supported me and given me tremendous joy over the past year: Marie and
Bradley Caudill. I also would like to offer my prayers for the families impacted
by the tremendous tragedies of September 11 and my support for the
policemen, firefighters, and communities of New York and Washington. And to
the US military leadership, such as my father, Sy, and his wife Sue, who like so
many soldiers before them will face a long, challenging, and difficult road to
building a foundation for us all in our search for peace.
-Tony
014830-1 FM.F 11/7/01 9:00 AM Page iv
Credits
Acquisitions Editor Project Coordinator
Sharon Cox Maridee Ennis
Project Editor Graphics and Production Specialists
Sharon Nash Sean Decker
Joyce Haughey
Development Editor
Gabriele McCann
Michael Koch
Kristin McMullan
Technical Editors Jill Piscitelli
Todd Meister Betty Schulte
Peter MacIntyre Erin Zeltner
Copy Editor Quality Control Technician
Maarten Reilingh John Bitter
Susan Moritz
Editorial Assistant
Angel Perez
Cordelia Heaney
Carl Pierce
Editorial Manager Sossity R. Smith
Mary Beth Wakefield
Proofreading and Indexing
Senior Vice President, Technical Publishing TECHBOOKS Production Services
Richard Swadley
Vice President and Publisher
Joseph B. Wikert
014830-1 FM.F 11/7/01 9:00 AM Page v
Preface
A
SP.NET Database Programming Weekend Crash Course™introduces the reader to
ASP.NET database programming in one weekend: 30 sessions of a half hour each, for
15 hours stretching from Friday afternoon to Sunday evening. At the end of each sec-
tion of the book, you’ll get a chance to test your knowledge before continuing. Good luck!
Who Should Read This Book
This book is for people who want to learn to write ASP.NET applications in order to access
and manipulate data in a Web environment. This book assumes that you have a basic
understanding of Web development, including experience with Visual Basic or Visual Basic
Scripting in developing ASP-based applications. The book’s focus is on ASP.NET and ADO.NET
as a suite of components used in data-driven Web application development. It includes a
CD-ROM with ASP.NET editor software and sample code mentioned in the text.
Organization and Presentation
We’ve organized the book into 30 sessions, each requiring approximately 30 minutes. We
divide the sessions as follows:
(cid:2)
Friday evening.Sessions 1 through 4. Reading time: 2 hours.
(cid:2)
Saturday morning.Sessions 5 through 10. Reading time: 3 hours
(cid:2)
Saturday afternoon. Sessions 11 through 16. Reading time: 3 hours.
(cid:2)
Saturday evening.Sessions 17 through 20. Reading time: 2 hours.
(cid:2)
Sunday morning.Sessions 21 through 26. Reading time: 3 hours.
(cid:2)
Sunday afternoon.Sessions 27 through 30. Reading time: 2 hours.
At the end of each session, we present questions designed to check your progress.
The text is sprinkled with icons designed to catch your attention.
014830-1 FM.F 11/7/01 9:00 AM Page vi
vi Foreword
The “minutes to go” icons mark your progress in the session.
The Tip icons offer suggestions on style and mention shortcuts that can save
programming effort.
Tip
The Note icons highlight incidental or technical information that clarifies
and expands upon the discussion.
Note
The CD-ROM icon refers to material furnished on the book’s CD. Use it to find
electronic versions of programs and software elements mentioned in the
CD-ROM
text.
Contacting the Authors
We can’t guarantee we will solve all of your ASP.NET database programming problems in this
book, but we promise to take a look at your questions and see if we can help. If you get
stuck, you can contact us at the following e-mail address:
[email protected]
Acknowledgments
Tony: First, I would like to acknowledge my wife, Marie, who has been extremely patient and
has provided tremendous support throughout the course of this project. A lot of new life
changes and accomplishments are hitting us this year, including our first child, Brad, and of
course the publication of this book. I’d like to thank Jason Butler, my co-author, for making
this opportunity available and being a solid source of support in its development.
Jason:I would like to dedicate this book to two people: my mother, who has always
inspired me to be the best person I can, and Donna, without whose patience, support, and
encouragement this book would never have been completed.
There are also a few people whom I would like to thank for their support throughout this
project. First, I would like to thank the PwC-eArmyU team, especially Chrystyna, Chris, FJ,
Mark, Volodya, PV, Julie, Travis, and Michael. They truly are some of the finest people with
whom I have had the privilege to work. I would also like to thank my fathers, Steve and Al,
for their unwavering support.
Last but not least, I would like to thank Tony Caudill, my co-author, for being a great
friend and mentor.
Tony and Jason:We would both like to thank PricewaterhouseCoopers LLP and Hungry
Minds for providing the financial and motivational support to accomplish this task while
supporting an extensive consulting practice.
Health and Peace . . .
014830-1 FM.F 11/7/01 9:00 AM Page vii
Contents at a Glance
Preface....................................................................................................................................v
Introduction........................................................................................................................xvii
FRIDAY......................................................................................................................2
Part I—Friday Evening ..................................................................................................4
Session 1–Introducing ASP.NET ..................................................................................................5
Session 2–Setting Up .NET ......................................................................................................13
Session 3–Designing a Database ...............................................................................................21
Session 4–Building a Database .................................................................................................29
SATURDAY.................................................................................................................44
Part II—Saturday Morning .....................................................................................................46
Session 5–Using SQL: A Primer .................................................................................................47
Session 6–XML: A Primer .........................................................................................................55
Session 7–Developing ASP.NET Pages ........................................................................................61
Session 8–Using HTML Controls ................................................................................................69
Session 9–Using Web Controls ..................................................................................................79
Session 10–Introducing User Controls .......................................................................................89
Part III—Saturday Afternoon ...............................................................................................100
Session 11–Validating User Input ...........................................................................................101
Session 12–Maintaining State in ASP.NET ................................................................................113
Session 13–Authentication and Authorization .........................................................................123
Session 14–ASP.NET Caching ..................................................................................................135
Session 15–Introducing ADO.NET ............................................................................................149
Session 16–Navigating the ADO.NET Object Model .....................................................................155
Part IV—Saturday Evening ...................................................................................................168
Session 17–Opening a Connection ..........................................................................................169
Session 18–Executing Commands ............................................................................................177
Session 19–Using DataReaders ................................................................................................187
Session 20–Introducing DataSets, Part I ..................................................................................197
SUNDAY..................................................................................................................208
Part V—Sunday Morning ......................................................................................................210
Session 21–Introducing DataSets, Part II .................................................................................211
Session 22–Introducing Data Binding ......................................................................................223
Session 23–Using the DataGrid Control with Bound Data ...........................................................233
Session 24–Beating the CRUD out of the DataGrid Control .........................................................243
Session 25–Data Shaping with ADO.NET ..................................................................................255
Session 26–Handling ADO.NET Errors .......................................................................................263
Part VI—Sunday Afternoon ..................................................................................................276
Session 27–SOAP It Up! .........................................................................................................277
Session 28–Web Services .......................................................................................................283
Session 29–Migrating from ASP to ASP.Net ..............................................................................291
Session 30–Migrating from ADO to ADO.NET .............................................................................299
Appendix A–Answers to Part Reviews ....................................................................................309
Appendix B–What’s on the CD-ROM .......................................................................................315
Appendix C–ADO.NET Class Descriptions ................................................................................319
Appendix D–Coding Differences in ASP and ASP.NET ...............................................................355
Index..................................................................................................................................369
Hungry Minds, Inc. End User License Agreement.....................................................................387
014830-1 FM.F 11/7/01 9:00 AM Page viii
014830-1 FM.F 11/7/01 9:00 AM Page ix
Contents
Preface.....................................................................................................................v
Introduction..........................................................................................................xvii
FRIDAY...................................................................................................................2
Part I—Friday Evening .......................................................................................4
Session 1–Introducing ASP.NET ..................................................................................5
Internet Standards .............................................................................................5
The Evolution of ASP ..........................................................................................6
The Benefits of ASP.NET ......................................................................................8
What Is .NET? ....................................................................................................9
.NET Experiences ........................................................................................................9
.NET Clients .............................................................................................................10
.NET Services ...........................................................................................................10
.NET Servers .............................................................................................................10
.NET Tools ................................................................................................................11
Session 2–Setting Up .NET ......................................................................................13
Installation Requirements ..................................................................................13
Installing ASP.NET and ADO.NET ..........................................................................15
Installing the .NET Framework SDK .............................................................................15
Testing Your Installation ....................................................................................17
Support for .NET ..............................................................................................19
Session 3–Designing a Database ..............................................................................21
Designing a Database ........................................................................................21
Normalization of Data .......................................................................................24
Security Considerations .....................................................................................26
Session 4–Building a Database ................................................................................29
Creating a Database ..........................................................................................29
Creating SQL Server Tables .................................................................................32
Creating a View ................................................................................................37
Creating a Stored Procedure ...............................................................................37
Creating a Trigger .............................................................................................38
SATURDAY...........................................................................................................44
Part II—Saturday Morning ..............................................................................46
Session 5–Using SQL: A Primer ................................................................................47
INSERT Statements ...........................................................................................47
DELETE Statements ...........................................................................................49
UPDATE Statements ..........................................................................................50
SELECT Statements ...........................................................................................51
Session 6–XML: A Primer .........................................................................................55
The XML Design Specs .......................................................................................55
The Structure of XML Documents .........................................................................56
XML Syntax .....................................................................................................58
XML and the .NET Framework .............................................................................59
Session 7–Developing ASP.NET Pages ........................................................................61
ASP.NET Events ................................................................................................61
Page Directives ................................................................................................64
Namespaces .....................................................................................................66
Choosing a Language ........................................................................................67