Database Programming with Visual Basic . NET

Name: Database Programming with Visual Basic . NET
Price: 5.7 USD
Availability: InStock
ISBN: 9781590590324

ISBN-10: 1590590325

ISBN-13: 9781590590324

Edition: 2nd 2003

Authors: C. Torben Thomsen, Carsten Thomsen

List price: $59.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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…

Book details

List price: $59.99
Edition: 2nd
Copyright year: 2003
Publisher: Apress L. P.
Publication date: 10/15/2002
Binding: Paperback
Pages: 984
Size: 7.25" wide x 9.00" long x 2.00" tall
Weight: 3.586
Language: English



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