| |
| |
About the Author | |
| |
| |
About the Technical Reviewer | |
| |
| |
Acknowledgments | |
| |
| |
Introduction | |
| |
| |
Who This Book Is For | |
| |
| |
How This Book Is Organized | |
| |
| |
Technology Requirements | |
| |
| |
Example Code | |
| |
| |
Data Source | |
| |
| |
Feedback | |
| |
| |
| |
Getting Started with .NET and Databases | |
| |
| |
| |
A Lightning-Quick Introduction to Visual Basic .NET | |
| |
| |
Reviewing Programming Concepts | |
| |
| |
Getting Cozy with the VS .NET Integrated Development Environment | |
| |
| |
Summary | |
| |
| |
| |
Using Databases | |
| |
| |
What Is a Database? | |
| |
| |
Why Use a Database? | |
| |
| |
Relational vs. Hierarchical | |
| |
| |
What VB .NET Programmers Need to Know about Relational Databases | |
| |
| |
UserMan Database Schema | |
| |
| |
Summary | |
| |
| |
| |
ADO.NET Connected Layer Reference | |
| |
| |
| |
Understanding ADO.NET | |
| |
| |
Data-Related Namespaces | |
| |
| |
Summary | |
| |
| |
| |
Looking at Data Providers | |
| |
| |
Summary | |
| |
| |
| |
Connections and Transactions | |
| |
| |
Connections | |
| |
| |
Transactions | |
| |
| |
Handling Connection and Transaction Exceptions | |
| |
| |
Summary | |
| |
| |
| |
The Command and Parameter Classes | |
| |
| |
Using Command Objects | |
| |
| |
Using Parameter Objects | |
| |
| |
Summary | |
| |
| |
| |
DataReaders | |
| |
| |
Using the DataReader Class | |
| |
| |
Summary | |
| |
| |
| |
The DataAdapter and CommandBuilder Classes | |
| |
| |
The DataAdapter Explained | |
| |
| |
Using the CommandBuilder Class | |
| |
| |
Summary | |
| |
| |
| |
ADO.NET Disconnected Layer Reference | |
| |
| |
| |
The DataSet Class | |
| |
| |
Using the DataSet Class | |
| |
| |
Summary | |
| |
| |
| |
The DataTable and DataView Classes | |
| |
| |
Using the DataTable Class | |
| |
| |
Using the DataView Class | |
| |
| |
Summary | |
| |
| |
| |
The DataRow and DataColumn Classes | |
| |
| |
Using the DataRow Class | |
| |
| |
Using the DataColumn Class | |
| |
| |
Summary | |
| |
| |
| |
Data Relations | |
| |
| |
Using the DataRelation Class | |
| |
| |
Summary | |
| |
| |
| |
Working with Databases in the VS .NET IDE | |
| |
| |
| |
Presenting the IDE from a Database Viewpoint | |
| |
| |
Using the Server Explorer | |
| |
| |
Looking at Database Projects | |
| |
| |
Designing Databases with Visio for Enterprise Architect | |
| |
| |
Designing Databases with the Database Designer | |
| |
| |
Using the Table Designer | |
| |
| |
Designing Queries with the Query Designer | |
| |
| |
Script Editing Using the SQL Editor | |
| |
| |
Creating Typed DataSets | |
| |
| |
Summary | |
| |
| |
| |
Exception Handling and Debugging | |
| |
| |
| |
Exception Handling | |
| |
| |
Structured Exception Handling | |
| |
| |
Unstructured Exception Handling | |
| |
| |
Summary | |
| |
| |
| |
Using the Debug and Trace Classes | |
| |
| |
Using the Debug Class | |
| |
| |
Using the Trace Class | |
| |
| |
Summary | |
| |
| |
| |
Server-Side Processing | |
| |
| |
| |
Using Stored Procedures | |
| |
| |
Optimization Issues | |
| |
| |
Using Stored Procedures and Functions | |
| |
| |
Summary | |
| |
| |
| |
Using Views | |
| |
| |
Using Views | |
| |
| |
Summary | |
| |
| |
| |
Using Triggers | |
| |
| |
Using Triggers | |
| |
| |
Summary | |
| |
| |
| |
Hierarchical Databases | |
| |
| |
| |
Hierarchical Databases | |
| |
| |
Looking at LDAP | |
| |
| |
Accessing Active Directory Programmatically | |
| |
| |
Accessing Active Directory Using the OLE DB .NET Data Provider | |
| |
| |
Summary | |
| |
| |
| |
Exchange Server | |
| |
| |
Using the Microsoft OLE DB Exchange Server Provider | |
| |
| |
Using the Microsoft OLE DB Provider for Internet Publishing | |
| |
| |
Accessing Exchange Server as a Linked Server from SQL Server | |
| |
| |
Summary | |
| |
| |
| |
Message Queueing | |
| |
| |
| |
Message Queues | |
| |
| |
Installing Message Queuing | |
| |
| |
Connectionless Programming | |
| |
| |
Taking a Quick Look at the MessageQueue Class | |
| |
| |
When to Use a Message Queue | |
| |
| |
How to Use a Message Queue | |
| |
| |
Making Message Queues Transactional | |
| |
| |
Looking at System-Generated Queues | |
| |
| |
Securing Your Message Queuing | |
| |
| |
MSMQ 3.0 Features | |
| |
| |
Summary | |
| |
| |
| |
XML and SQL Server 2000 | |
| |
| |
| |
Using XML with SQL Server 2000 | |
| |
| |
SQL Server and XML | |
| |
| |
Using SQLXML 3.0 | |
| |
| |
Summary | |
| |
| |
| |
Data Wrappers | |
| |
| |
| |
Data Wrappers | |
| |
| |
Why Use Data Wrappers? | |
| |
| |
Looking at Object Oriented Programming | |
| |
| |
Wrapping a Database | |
| |
| |
Summary | |
| |
| |
| |
Data-Bound Controls | |
| |
| |
| |
Windows Data-Bound Controls | |
| |
| |
Data-Bound Controls vs. Manual Data Hooking | |
| |
| |
Different Controls for Different UIs | |
| |
| |
Using Data-Bound Controls with Windows Forms | |
| |
| |
Summary | |
| |
| |
| |
Web Data-Bound Controls | |
| |
| |
Using Data-Bound Controls with Web Forms | |
| |
| |
Binding ASP.NET Server Controls to a Data Source | |
| |
| |
Summary | |
| |
| |
| |
Example Application | |
| |
| |
| |
UserMan | |
| |
| |
Identifying the UserMan Information | |
| |
| |
Discovering the Objects | |
| |
| |
Creating the Client | |
| |
| |
Tips and Ideas | |
| |
| |
Summary | |
| |
| |
Appendixes | |
| |
| |
| |
Cursors and Locking | |
| |
| |
Looking at Cursors | |
| |
| |
Examining Data Source Locking | |
| |
| |
Summary | |
| |
| |
| |
Using Classic ADO and COM Interop | |
| |
| |
Understanding and Using COM Interop | |
| |
| |
Summary | |
| |
| |
| |
Connected Layer Properties, Methods, and Events | |
| |
| |
Connection Class | |
| |
| |
Transaction Class | |
| |
| |
Exception and Error Classes | |
| |
| |
Command Class | |
| |
| |
Command Class | |
| |
| |
Parameter Class | |
| |
| |
DataReader Class | |
| |
| |
XmlReader Class | |
| |
| |
DataAdapter Class | |
| |
| |
Summary | |
| |
| |
| |
Disconnected Layer Properties, Methods, and Events | |
| |
| |
DataSet Class | |
| |
| |
DataTable Class | |
| |
| |
DataView Class | |
| |
| |
DataRow Class | |
| |
| |
DataColumn Class | |
| |
| |
DataRelation Class | |
| |
| |
Summary | |
| |
| |
Index | |