Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
 Windows 8
 Adobe CS6
 CCNA 2012
 CCNP 2012
 Web Design
 Project Management
 Mobile Devices
 Windows Server 2012
 SQL Server 2012
Economics and Business
 Business Information Systems
 Human Resources

Database Programming with Visual Basic .Net

by: Carsten Thomsen

Notify me when in stock

On-line Price: $88.00 (includes GST)

Paperback package 984

20%Off Retail Price

You save: $22.00

Usually ships within 3-5 business days.

Retail Price: $110.00

Publisher: APRESS,Oct-2002

Category: VB.NET Level:

ISBN: 1590590325
ISBN13: 9781590590324

Add to Shopping Cart

You can read Database Programming with Visual Basic .NET, Second Edition cover-to-cover, or use it as a reference book for its many listings with ready-made solutions of 'drop-in' code. This book will teach you the concepts of disconnected data access with ADO.NET; how to create various database details, such as tables, constraints, projects, stored procedures, views, and triggers; how to use SQLXML 3.0 with SQL Server 2000; how to incorporate message queuing into applications using MSMQ 3.0; and more. You'll learn how to master ADO.NET both from within the VS. NET IDE and programmatically.

  One of the most popular features carried over from the first edition is the real-world sample application that Carsten builds throughout this book. It's a user management system that's based on SQL Server, Active Directory, and Message Queuing. With this example code, you can connect to SQL Server using any of the three .NET Data Providers: SQL Server .NET Data Provider, OLE DB .NET Data Provider, or ODBC .NET Data Provider. The example code also includes how to connect to and manipulate data in MySQL 3.23.51 or later, Oracle 9i or later, Microsoft Access 2000 or later, and, of course, SQL Server. You will also find guidance on connecting to SQL Server 2000 using the SQLXML 3.0 plug-in to transfer data using XML from managed code or HTTP. Exchange Server 2000 data manipulation is also covered, with original working code.

  Database Programming with Visual Basic .NET, Second Edition is the ultimate resource for developers needing to master database programming, written by a recognized Microsoft MVP.

      Author Information

  Carsten Thomsen - Carsten Thomsen is a Microsoft MVP, recognition he received in August 1999. He lives in his native Denmark and currently holds the MCSE and MCSD certifications. Carsten has been programming in Visual Basic for almost 10 years, with a specialization in data access. However, with the advent of Visual Studio .NET, he has concentrated on two programming languages, C# and Visual Basic .NET.

  Part One Getting Started with .NET and Databases

Chapter 1: A Lightning-Quick Introduction to Visual Basic .NET

Chapter 2: Using Databases

  Part Two ADO.NET Connected Layer Reference

Chapter 3: Understanding ADO.NET

Chapter 4: Looking at Data Providers

Chapter 5: Connections and Transactions

Chapter 6: The Command and Parameter Classes

Chapter 7: DataReaders

Chapter 8: The DataAdapter and CommandBuilder Classes

  Part Three ADO.NET Disconnected Layer Reference

Chapter 9: The DataSet Class

Chapter 10: The DataTable and DataView Classes

Chapter 11: The DataRow and DataColumn Classes

Chapter 12: Data Relations

  Part Four Working with Databases in the VS .NET IDE

Chapter 13: Presenting the IDE from a Database Viewpoint

  Part Five Exception Handling and Debugging

Chapter 14: Exception Handling

Chapter 15: Using the Debug and Trace Classes

  Part Six Server-Side Processing

Chapter 16: Using Stored Procedures

Chapter 17: Using Views

Chapter 18: Using Triggers

  Part Seven Hierarchical Databases

Chapter 19: Hierarchical Databases

Chapter 20: Exchange Server

  Part Eight Message Queuing

Chapter 21: Message Queues

  Part Nine XML and SQL Server 2000

Chapter 22: Using XML with SQL Server 2000

  Part Ten Data Wrappers

Chapter 23: Data Wrappers

  Part Eleven Data-Bound Controls

Chapter 24: Windows Data-Bound Controls

Chapter 25: Web Data-Bound Controls

  Part Twelve Example Application

Chapter 26: UserMan


Appendix A Cursors and Locking

Appendix B Using Classic ADO and COM Interop

Appendix C Connected Layer Properties, Methods, and Events

Appendix D Disconnected Layer Properties, Methods, and Events