Thư viện tri thức trực tuyến
Kho tài liệu với 50,000+ tài liệu học thuật
© 2023 Siêu thị PDF - Kho tài liệu học thuật hàng đầu Việt Nam
Applied ADO.NET
Nội dung xem thử
Mô tả chi tiết
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Back Cover
Applied ADO.NET: Building Data-Driven Solutions provides extensive coverage of ADO.NET technology including
ADO.NET internals, namespaces, classes, and interfaces. Where most books cover only SQL and OLE DB data
providers, Mahesh Chand and David Talbot cover SQL, OLE DB, ODBC data providers and the latest additions to
ADO.NET: Oracle, MySQL, and XML .NET data providers. Chand and Talbot also cover internals of data binding and
they provide detailed coverage on both Windows Forms and Web Forms data binding and data-bound controls.
Since XML plays a major role in .NET development, the authors also provide a comprehensive look at XML
namespaces and classes, and how to integrate both with ADO.NET.
Applied ADO.NET: Building Data-Driven Solutions begins with the basics of ASP.NET and data-bound controls. It
then delves into internals of data binding and shows how to use DataGrid, DataList, and other data-bound controls
in real-world applications. Chand and Talbot also discuss the ASP.NET guest book, database XML Web services, and
even an online bookstore site development and design process. Advanced developers will learn from the coverage
of ADO.NET architecture, related design issues, and how ADO.NET data providers are designed. The authors also
show how to create a Custom Data Provider. Event handling, server side programming, data relations and
constraints, Active Directory, messaging, exception and error handling, and object relational model are other topics
covered in detail.
About the Authors
Mahesh Chand is presently engaged as a software developer with Kruse. Inc. He has been working with Microsoft
database technologies including ODBC, DAO, ADO, and OLE-DB for over 5 years. He has a M.S. degree in Computer
Science, a B.S. in Mathematics, and is also a Microsoft Certified Professional in VC++.In addition to his day job,
Mahesh writes and programs for C# Corner on C#, VB .NET, ASP .NET and other .NET technologies and help site
visitors.
David Talbot's background is diverse, ranging from developing license plate recognition technology to television set
boxes to scalable Web applications. Currently, David works in the New Business Technologies group at FreeMarkets
applying cutting edge .NET technologies to solve business problems. He has been working with .NET since the early
betas, developing a number of solutions for several start-ups and established companies while working on several
.NET books and articles. Prior to the development of .NET, David worked primarily on Java, SCO UNIX, Linux, DB2,
SQL Server, and PERL.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Applied ADO.NET-Building Data-Driven Solutions
MAHESH CHAND AND
DAVID TALBOT
Copyright © 2003 by Mahesh Chand and David Talbot
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-073-2
Printed and bound in the United States of America 12345678910
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.
Technical Reviewer: Philip Pursglove
Editorial Directors: Dan Appleman, Gary Cornell, Jason Gilmore, Simon Hayes, Karen Watterson, John
Zukowski
Managing Editor: Grace Wong
Project Manager: Tracy Brown Collins
Development Editor: Philip Pursglove
Copy Editor: Kim Wimpsett
Compositor: Diana Van Winkle, Van Winkle Design Group
Artist and Cover Designer: Kurt Krames
Indexer: Ron Strauss
Production Manager: Kari Brooks
Manufacturing Manager: Tom Debolski
Distributed to the book trade in the United States by Springer-Verlag New York, Inc., 175 Fifth Avenue,
New York, NY, 10010 and outside the United States by Springer-Verlag GmbH & Co. KG, Tiergartenstr.
17, 69112 Heidelberg, Germany.
In the United States, phone 1-800-SPRINGER, email <[email protected]>, or visit
http://www.springer-ny.com.
Outside the United States, fax +49 6221 345229, email <[email protected]>, or visit
http://www.springer.de.
For information on translations, please contact Apress directly at 2560 9th Street, Suite 219, Berkeley, CA
94710. Phone 510-549-5930, fax: 510-549-5939, email <[email protected]>, 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 nor Apress shall have any liability to any
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
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 Downloads
section.
To uncles Banshi Lal and Rajbir Singh Malik for their support and guidance.
-Mahesh Chand
For Nadia whose patience has carried me through this book.
-David Talbot
About the Authors
Mahesh Chand is a Microsoft .NET consultant, an author, and the founder of C# Corner (www.csharpcorner.com), one of the leading online community for .NET (C#, VB .NET, and ASP.NET)
developers. He has a master's degree in computer science and a bachelor's degree in mathematics, and
he is a Microsoft Certified Professional in VC++. Mahesh is also the author of A Programmer's Guide to
ADO.NET in C# (Apress, 2002).
David Talbot has worked in a variety of technologies including television set top boxes, license plate
recognition, and scalable Web applications. He has written a number of articles concerning .NET
technologies and has worked in various capacities on three books. He is currently working as a
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
development manager in the New Business Technologies group at FreeMarkets in Pittsburgh,
Pennsylvania.
About the Technical Reviewer
Philip Pursglove is a developer with the Willis Group, based in Ipswich, United Kingdom. He has worked
with every version of Visual Basic from 3.0 onward. Philip was one of the first developers in the UK to gain
the Microsoft Certified Application Developer certification; he also holds the Microsoft Certified Solution
Developer certification in addition to a degree in business information systems. Philip writes for Pinnacle
Publishing's Hardcore Visual Basic and SQL Server Professional magazines, and he speaks at user
group events in the UK. He maintains a Web site at www.philippursglove.com and can be reached
at <[email protected]>.
Acknowledgments
First, I would like to thank Karen Watterson at Apress. I couldn't even think about finishing this book without
her timely expert comments and motivation. Second, as always, project manager Tracy Brown Collins did
a great job of managing the entire project so we could finish it within the time constraints. Without a
technical reviewer, a book could never be published. Philip Pursglove did a good job of improving the
technical aspect of the book. Thanks also to Kim Wimpsett, the copy editor, and Kari Brooks, the
production manager, for their hard work and for giving the book a professional look.
-Mahesh Chand
I would like to thank Andy Harris for convincing me to write my first book.
-David Talbot
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Introduction
This book is for experienced developers who want to write desktop or Web-based database applications in
.NET. This book assumes you have some prior programming knowledge of an object-oriented
programming language such as C++, Java, or Visual Basic; some basic concepts of database
programming; and some experience with previous versions of Visual Studio (VS). This book also assumes
you know the basic concepts of .NET and how to install it.
The following sections briefly introduce this book's chapters.
Chapter 1: "ADO.NET Basics"
This chapter provides you with a high-level overview of ADO.NET. This chapter covers the basics of
ADO.NET, describes its advantages over current data access technologies, and briefly introduces
ADO.NET classes and namespaces. It also shows you how to use ADO.NET classes and namespaces to
write simple database applications using VS .NET (VS .NET). Finally, Microsoft VS .NET provides
tremendous support for writing database applications in no time using its wizards and utilities. This chapter
also briefly introduces ADO.NET components and how they fit in the model and work together.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 2: "Data Components in Visual Studio .NET"
The Visual Studio .NET (VS .NET) Integrated Development Environment (IDE) provides design-time
support to work with data components. In this chapter, you'll learn how to use these data components in
the VS .NET IDE at design-time to create database applications. This chapter starts with the Server
Explorer, a useful tool for database applications. You'll focus on developing database applications quickly
using data components in VS .NET without writing a lot of code. You'll work through a step-by-step tutorial
to help you develop and run a project. The chapter also discusses the Connection, DataAdapter,
Command, DataSet, and DataView components in more detail. After finishing this chapter, you'll have a
good understanding of data components and how to work with them in VS .NET.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 3: "ADO.NET in Disconnected Environments"
In this chapter, you'll get a broad view of the ADO.NET architecture and the basic building blocks of
ADO.NET in a disconnected environment. This chapter plays a major role for later chapters as well.
Actually, ADO.NET not only provides a way to work with databases, it also allows you to access various
kinds of data sources and even in-memory representations of data. You'll learn how to write database
applications without using a database. You'll also explore the System.Data and System.Data.Common
namespace classes. Some of the common data objects covered in this chapter are DataTable,
DataColumn, DataRow, and DataSet.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 4: "ADO.NET in Connected Environments"
This chapter examines ADO.NET functionality in a connected environment, which means you won't be
storing data in memory. You'll be reading and storing data in data sources. You access data from a data
source and save data back to the data source with the help of a bridge between the application and the
data source; in ADO.NET this bridge is a data provider. ADO.NET provides many data providers for
working with different data sources to make data access fast, reliable, and easy to use. Each data provider
has data components (classes) that let you connect to a data source and read, write, add, delete, and
update data. This chapter examines these components and shows how to use Windows data-bound
controls to bind data with ADO.NET components.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 5: "Handling ADO.NET Events"
Events are useful for notifying you when some action happens to an object. An event can have a method
associated with it. Not too many books cover the ADO.NET events in details. This chapter shows you how
you can handle events for ADO.NET objects. It covers almost every ADO.NET data component event and
how to use them in your applications.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 6: "Integrating XML with ADO.NET"
This chapter begins with the introduction of the classes provided by the .NET Framework Library to work
with Extensible Markup Language (XML) documents. This chapter discusses how to read from and write to
XML documents using the .NET Framework Library classes. After that it discusses how to navigate
through XML documents. The chapter also discusses XML transformations. In addition, this chapter covers
the relationship between ADO.NET and XML and shows how to mix them up and use rich ADO.NET
database components to display and manipulate XML data. Finally, this chapter covers the
XPathNavigator class, which navigates XML documents.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 7: "Data Binding and Windows Forms Data-Bound
Controls"
Data-bound controls are not only ease to use, but they also provide many built-in features that
programmers will find useful. This chapter discusses the basics of data binding and data-bound controls,
as well as how to develop interactive Graphical User Interface (GUI) database applications using these
controls in minimal time and with minimal effort. This chapter covers how to use Windows controls such as
the TextBox, Button, Label, CheckBox, ComboBox, ListBox, and DataGrid controls in the databinding process and how to write your custom data-bound applications to navigate through the records of
a data source. In this chapter, you'll learn some data-binding techniques that are hard to find in other
ADO.NET books.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 8: "Constraints and Data Relations"
This chapter discusses constraints and data relations in detail. First, this chapter starts with a discussion of
constraints and how ADO.NET constraint objects maintain data integrity. The second part of this chapter
discusses data relations.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 9: "ADO.NET Exception Handling"
Exception and error handling is one of the most important parts of writing reliable and error-prone
applications. If you come from a C++ background, you're probably familiar with different exceptional
handling methods such as C++ exceptional handling, structured exceptional handling, and Microsoft
Foundation Classes (MFC) exceptions. If you come from a Visual Basic background, you're probably
familiar with the On Error statement. Besides the exception handling in previous versions of VC++ and
Visual Basic, .NET implements exceptions in a different way, and all .NET-supported languages (C# and
VB .NET) share the same mechanism. Now Visual Basic developers can enjoy the same rich exception
handling C++ developers have enjoyed. Discussing .NET exception handling is beyond the scope of this
book; this chapter concentrates on ADO.NET exception handling classes.
Applied ADO.NET: Building Data-Driven Solutions
by Mahesh Chand and David Talbot ISBN:1590590732
Apress © 2003 (928 pages)
This text provides extensive coverage of ADO.NET technology
including ADO.NET internals, namespaces, classes, and
interfaces, and takes a comprehensive look at XML
namespaces and classes, and how to integrate both with
ADO.NET.
Table of Contents
Applied ADO.NET—Building Data-Driven Solutions
Introduction
Chapter 1 - ADO.NET Basics
Chapter 2 - Data Components in Visual Studio .NET
Chapter 3 - ADO.NET in Disconnected Environments
Chapter 4 - ADO.NET in Connected Environments
Chapter 5 - Handling ADO.NET Events
Chapter 6 - Integrating XML with ADO.NET
Chapter 7 - Data Binding and Windows Forms Data-Bound Controls
Chapter 8 - Constraints and Data Relations
Chapter 9 - ADO.NET Exception Handling
Chapter 10 - Working with the ODBC .NET Data Provider
Chapter 11 - Stored Procedures and Views
Chapter 12 - Oracle, SQLXML, and Other .NET Data Providers
Chapter 13 - Developing a Custom Data Provider
Chapter 14 - Developing Database Web Applications using ASP.NET
Chapter 15 - Using ADO.NET in Xml Web Services
Chapter 16 - ASP.NET Server Controls and Data Binding
Chapter 17 - Building Real-World Web Applications
Chapter 18 - Object-Relational Mapping in .NET
Chapter 19 - Mapped Objects: Performance Considerations and Data Binding
Chapter 20 - COM Interoperability and ADO.NET
Chapter 21 - Messaging
Chapter 22 - SQL Server and ADO.NET: Notes on Performance
Appendix A - Relational Databases: Some Basic Concepts
Appendix B - Commonly Used SQL Statements
Appendix C - ADO.NET Frequently Asked Questions
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
Chapter 10: "Working with the ODBC .NET Data Provider"
This chapter discusses the ODBC .NET data provider and how to work with various data sources such as
Access, MySQL, Excel, and text using the ODBC data provider.