Database Programming with Visual Basic .NET

Take your pick: you may either read this book cover-to-cover, or just refer to it when you want ready-made solutions of "drop-in" code. Either way, Database Programming with Visual Basic .NET, Second Edition will teach you to master ADO.NET programmatically and from within the VS. NET IDE. You will learn the concepts of disconnected data access with ADO.NET. You'll also learn to create tables, constraints, projects, stored procedures, views, and triggers. The book will explain how to use SQLXML 3.0 with SQL Server 2000, and how to incorporate message queuing into applications using MSMQ 3.0. Author Carsten Thomsen, a recognized Microsoft MVP, carries over one of the most popular features from the first edition: the real-world sample application that he built throughout. With this example code, you can connect to SQL Server from your choices of SQL Server .NET Data Provider, OLE DB .NET Data Provider, or ODBC .NET Data Provider. Exchange Server 2000 data manipulation is also covered, with original working code.

About the Author

xiii

About the Technical Reviewer

xiv

Acknowledgments

xv

Introduction

xvii

Part One Getting Started with .NET and Databases

1

(56)

A Lightning-Quick Introduction to Visual Basic .NET

3

(28)

Using Databases

31

(26)

Part Two ADO.NET Connected Layer Reference

57

(142)

Understanding ADO.NET

59

(6)

Looking at Data Providers

65

(6)

Connections and Transactions

71

(52)

The Command and Parameter Classes

123

(22)

DataReaders

145

(24)

The DataAdapter and CommandBuilder Classes

169

(30)

Part Three ADO.NET Disconnected Layer Reference

199

(108)

The DataSet Class

201

(24)

The DataTable and DataView Classes

225

(36)

The DataRow and DataColumn Classes

261

(24)

Data Relations

285

(22)

Part Four Working with Databases in the VS .NET IDE

307

(64)

Presenting the IDE from a Database Viewpoint

309

(62)

Part Five Exception Handling and Debugging

371

(44)

Exception Handling

373

(34)

Using the Debug and Trace Classes

407

(8)

Part Six Server-Side Processing

415

(62)

Using Stored Procedures

417

(38)

Using Views

455

(10)

Using Triggers

465

(12)

Part Seven Hierarchical Databases

477

(40)

Hierarchical Databases

479

(24)

Exchange Server

503

(14)

Part Eight Message Queueing

517

(84)

Message Queues

519

(82)

Part Nine XML and SQL Server 2000

601

(72)

Using XML with SQL Server 2000

603

(70)

Part Ten Data Wrappers

673

(24)

Data Wrappers

675

(22)

Part Eleven Data-Bound Controls

697

(46)

Windows Data-Bound Controls

699

(22)

Web Data-Bound Controls

721

(22)

Part Twelve Example Application

743

(26)

UserMan

745

(24)

Appendixes

769

(150)

Appendix A Cursors and Locking

771

(18)

Appendix B Using Classic ADO and COM Interop

789

(4)

Appendix C Connected Layer Properties, Methods, and Events

793

(88)

Appendix D Disconnected Layer Properties, Methods, and Events

881

(38)

Index

919

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Database Programming with Visual Basic .NET

Summary

Table of Contents

Supplemental Materials