Skip to content

Database Programming with Visual Basic . NET

Spend $50 to get a free DVD!

ISBN-10: 1590590325

ISBN-13: 9781590590324

Edition: 2nd 2003

Authors: C. Torben Thomsen, Carsten Thomsen

List price: $59.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
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 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.
Customers also bought

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