Apress - Beginning SQL Server 2005 Express - Database Applications with VB Express and VWD Express (2006).pdf
(
10151 KB
)
Pobierz
28859017 UNPDF
Beginning SQL Server
2005 Express Database
Applications
with Visual Basic Express and
Visual Web Developer Express
From Novice to Professional
Rick Dobson
Beginning SQL Server 2005 Express Database Applications
with Visual Basic Express and Visual Web Developer Express From Novice to Professional
Copyright © 2006 by Rick Dobson
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN (pbk): 1-59059-523-8
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence
of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark
owner, with no intention of infringement of the trademark.
Lead Editors: Tony Davis and Matthew Moodie
Technical Reviewer: Cristian Lefter
Editorial Board: Steve Anglin, Dan Appleman, Ewan Buckingham, Gary Cornell, Tony Davis, Jason Gilmore,
Jonathan Hassell, Chris Mills, Dominic Shakeshaft, Jim Sumser
Project Manager: Beth Christmas
Copy Edit Manager: Nicole LeClerc
Copy Editors: Damon Larson and Freelance Editorial Services
Assistant Production Director: Kari Brooks-Copony
Production Editor: Kelly Winquist
Compositors: Dina Quan and Diana Van Winkle, Van Winkle Design Group
Proofreader: April Eddy
Indexer: Valerie Perry
Cover Designer: Kurt Krames
Manufacturing Director: Tom Debolski
Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,
New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail
orders-ny@springer-sbm.com
, or
visit
http://www.springeronline.com
.
For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley,
CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail
info@apress.com
, or visit
http://www.apress.com
.
The information in this book is distributed on an “as is” basis, without warranty. Although every precaution
has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to
any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly
by the information contained in this work.
The source code for this book is available to readers at
http://www.apress.com
in the Source Code section.
You will need to answer questions pertaining to this book in order to successfully download the code.
Contents at a Glance
About the Author
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
About the Technical Reviewer
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Acknowledgments
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Introduction
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
PART 1
■ ■ ■
Working with SQL Server Express
■
CHAPTER 1
Getting Started with SQL Server Express
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
■
CHAPTER 2
Graphical and Command-Line Query Tools
. . . . . . . . . . . . . . . . . . . . . . . . . . . 33
■
CHAPTER 3
Exploring, Creating, and Recovering Databases
. . . . . . . . . . . . . . . . . . . . . . 73
■
CHAPTER 4
Data Types, Tables, and Constraints
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107
■
CHAPTER 5
Creating Queries from a Single Database Object
. . . . . . . . . . . . . . . . . . . . 155
■
CHAPTER 6
Querying Multiple Database Objects and Manipulating Result Sets
. . . 191
■
CHAPTER 7
Leveraging Database Objects That Encapsulate T-SQL
. . . . . . . . . . . . . . . 247
■
CHAPTER 8
Managing SQL Server Express Security
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307
PART 2
■ ■ ■
Working with Visual Basic Express
and Visual Web Developer Express
■
CHAPTER 9
Introduction to Visual Basic Express and Windows Forms
. . . . . . . . . . . . 371
■
CHAPTER 10
Introduction to Visual Web Developer Express,
Web Pages, and Web Forms
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409
■
CHAPTER 11
Programming ADO.NET
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 445
■
CHAPTER 12
Programming DataAdapter and DataSet Objects
. . . . . . . . . . . . . . . . . . . . 485
■
CHAPTER 13
Using Visual Database and Form Design Tools
. . . . . . . . . . . . . . . . . . . . . . 515
■
INDEX
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 575
iii
Plik z chomika:
darekisap
Inne pliki z tego folderu:
Apress - Pro SQL Server 2005 Integration Services (2008).pdf
(15672 KB)
Apress - Pro ASP.NET for SQL Server High Performance Data Access for Web Developers (2007).pdf
(3825 KB)
Apress - Expert SQL Server 2005 Development (2007).pdf
(6481 KB)
Manning - SQL Server 2005 Reporting Services in Action (2006).pdf
(23748 KB)
Wrox - SQL Server 2005 XML (2008).pdf
(12489 KB)
Inne foldery tego chomika:
MS SQL 2000 Server
MS SQL Server 7.0
Zgłoś jeśli
naruszono regulamin