Skip to main content

Beginning Visual Basic 2005 Databases

Beginning Visual Basic 2005 Databases

Thearon Willis

ISBN: 978-0-471-75926-3

Nov 2005

768 pages

Select type: E-Book

$25.99

Product not available for purchase

Description

As one of the most popular programming languages in the world, Visual Basic continues to expand on the functionality and flexibility of its framework. This book explains how to use Visual Basic 2005 to write efficient database applications that can be used throughout an enterprise.

With this teaching tool, you'll learn how to use queries, views, and stored procedures to efficiently access and manipulate data from your applications. You'll get a firm grasp on using ADO.NET as well as OleDb, SQL, and Oracle to access specific databases. Plus, hands-on examples and try-it-out exercises help you put your reading into practice so that with each chapter, you'll gradually build the pieces of a single application.

What you will learn from this book

  • How ADO.NET continues to evolve as a building block for accessing and manipulating data in relational databases
  • Ways to encrypt and decrypt data, hash passwords, and further secure access to your data
  • Techniques for accessing your Web Service from both Windows(r) and Web applications
  • Best practices for using business logic and data access components to produce report data or update data in your back-end databases

Who this book is for

This book is for developers who want to learn to write database applications and back-end databases, such as Microsoft(r) Access, Microsoft(r) SQL Server, and Oracle(r). Some experience with Visual Basic 2005 is helpful but not required.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Acknowledgments.

Introduction.

Chapter 1: Databases.

Chapter 2: An Introduction to ADO.NET.

Chapter 3: Visual Studio 2005 Data Wizards.

Chapter 4: Basic SQL.

Chapter 5: SQL and Queries for Access.

Chapter 6: Selecting Data in Access.

Chapter 7: Inserting, Updating, and Deleting Data in Access.

Chapter 8: Migrating Data from Access.

Chapter 9: Stored Procedures and Views for SQL Server and Oracle.

Chapter 10: Building Business Logic and Data Access Components.

Chapter 11: Inserting Data.

Chapter 12: Selecting Data.

Chapter 13: Updating Data.

Chapter 14: Accessing Data in ASP.NET.

Chapter 15: Creating a Web Service.

Chapter 16: Accessing a Web Service.

Appendix A: Data Type Cross-Reference.

Appendix B: Time Tracker Project UI.

Appendix C: Exercise Solutions.

Index.

Download the code files.
Download
Code Downloads
Code downloads for this title are available here.
Download
Download the code files.
Code Downloads
Code downloads for this title are available here.
ChapterPageDetailsDatePrint Run
81OleDbConnection
Calling the Close method on an OleDbConnection object that is not opened DOES NOT cause an error as the text states.

However, the OleDbConnection object does need to be instantiated which is what the reader failed to do.
3/1/06

96Error in Text
In the subsection of Try Out in part number 5 it says:

Right-click Access SQL...
It should say:
Right-click Access Queries

because that is the project we are using in this section.
3/1/06

97 & 103Error in Text/Grid
Instructions for page 103, step 4:

The reader should copy the data from a row in the grid, place the copied text in NotePad and then just copy the Guid.
07/12/2006

105Error in Code
ComboBox1.DataSource = objDataTable.Tables(0)
ComboBox1.DisplayMember = ProjectName
ComboBox1.ValueMember = ProjectID

Should be:

'Bind the DataTable to the ComboBox
ComboBox1.DataSource = objDataTable
ComboBox1.DisplayMember = ProjectName
ComboBox1.ValueMember = ProjectID
3/15/06

209Typo
The schema for the GroupProjects table:
GroupProjectsID (plural)

should be:
GroupProjectID (singular)
11/20/2006

413Error in Text
Step 10:br>
cboEmployeeWeekEndingDate
should be:
cboEmployeeWeekEnding
3/6/06

626Error in Step
Step 117:
Drag a ListView control from the Toolbox and drop it onto pnlProjects.

should read:
Drag a ListView control from the Toolbox and drop it onto pnlRoles.
01/08/07