Skip to main content

Beginning VB.NET Databases

Beginning VB.NET Databases

Thearon Willis

ISBN: 978-0-764-56800-8

Oct 2004

768 pages

Select type: Paperback

Product not available for purchase


What is this book about?

Beginning Visual Basic .NET Databases teaches Visual Basic .Net developers the concepts and skills necessary to write VB.Net database applications. This book touches on database design concepts but focuses on using ADO.Net to access and manipulate data in relational databases. While the book covers all data providers in ADO.Net briefly, the primary objective is to focus on using the OleDb provider for accessing Access databases and the SQL provider for accessing SQL Server databases.

What does this book cover?

Readers learn how to how to use queries, views, and stored procedures to efficiently access and manipulate data from their applications. We provide examples and instruction on accessing data from Windows applications, ASP.Net applications, as well as Web Services.

Specific coverage includes the following:

  • ODBC
  • OleDB
  • SQL, Stored Procedures, and Views
  • Creating Queries
  • Building a Data Access Class
  • Selecting and Updating Data
  • Accessing Data in ASP.NET
  • Working with XML Web Services
Chapter 1. Databases.

Chapter 2. An Introduction to ADO.Net

Chapter 3. Visual Studio .Net Data Wizards (Covers Components in the Data tab of the Toolbox).

Chapter 4. Basic SQL.

Chapter 5. SQL and Queries for Access.

Chapter 6. Selecting Data in Access.

Chapter 7. Inserting and Updating Data in Access.

Chapter 8. Migrating Data From Access.

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

Chapter 10. Building Business and Data Access Components (build components that will be used with the rest of the chapters).

Chapter 11. Inserting Data.

Chapter 12. Selecting Data.

Chapter 13. Updating Data.

Chapter 14. Accessing Data In ASP.Net.

Chapter 15. Creating An XML Web Service.

Chapter 16. Accessing An XML Web Service.

Appendix A: Data Type Cross Reference.

Appendix B: Building The Time Tracker Project UI.

Appendix C: Exercise Answers.

Download all the code from the book in .rar format.
This download has all of the same material as the .zip download at approximately 1/6 the size. You will need a program capable of uncompressing .rar files. If your compression software does not support the .rar format, you may download a trial version of WinRAR at
Download all the code from the book in .zip format.
ChapterPageDetailsDatePrint Run
16-18Error in Figure 1-7,Table 1-7 shows the data type for GroupID and ProjectID as Text fields.

The database is ProjetTimeTracker.mdb.

On page 15 figure 1-6 shows the data type as Number.

It actually has to be a number because relationship with the tables can't otherwise be formed.
17GroupProjects Table,The instructions for creating the GroupProjects table in the ProjectTimeTracker.mdb database give 'Text' as the data type for both the GroupID and ProjectID fields. These need to be 'Numeric' (Replication ID). 11/17/04
23MIssing relationship,One row of relationships missing: Cols Primary Key Table= Projects , Primary Key= ProjectID , Foreign Key Table= TimeSheetItems , Foreign Key= ProjectID . The addition of this row will then agree with the relationships in Fig 1-8, pg 20, and with the script in Step 4, pg 27. 12/8/04
58Error in Code,

In the LoadSpecificDataSet, three lines of code are wrong. There should be no spaces in the column names of the Products table.

These lines read: (each on one line)
 ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( Product Name ).ColumnName, 150, HorizontalAlignment.Left)  ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( Product Description ).ColumnName, 200, HorizontalAlignment.Left)  ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( Unit Price ).ColumnName, 60, HorizontalAlignment.Right) 
and Should read: (each on one line)
 ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( ProductName ).ColumnName, 150, HorizontalAlignment.Left)  ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( ProductDescription ).ColumnName, 200, HorizontalAlignment.Left)  ListView1.Columns.Add( Me.ProductsDS1.Tables( Products ).Columns( UnitPrice ).ColumnName, 60, HorizontalAlignment.Right) 
99Extra space in code,The code line reads: .Filter = Access Database (*.mdb) | *.mdb | this does not work because of the trailing space after *.mdb . 12/7/04
265Error in Code,On page 265 (and again on 269) the example code shows the bytIV variables as being declared and initialized to a 25 character string with a leading space before the r .

There should not be a leading space.
Appendix B638Wrong Form Size in Step 6,Step 6 says to set the form size to 760,510.

The Form size should actually be 760,530. If set to the first size, there will be no room to display the Label Update Date and textbox.
658Step #111,The instruction reads that a ListView control should be dragged from the toolbox and dropped on pnlProjects. It should be pnlRoles. 11/18/04
681Error in Step 2,A variable is missing for NavigationPanel_MouseEnter event. Private imgCurrentNavImage As Image needs to be entered in step 2 in the text only. The code download is correct. 12/8/04
Appendix B682Missing Line under "pnlGroups" Case Statement,The code on page 682 should be read as the following :
 Select Case objControl.Name   Case  pnlProjects      strActiveScreen =  Projects      lblCurrentScreen.Text =  Projects      lblAllScreens.Text =  All   &  Projects      imgScreen.Image = ImageList1.Images(ImageProjects)     lblScreen.Text =  Projects      optOption1.Text =  Name      optOption2.Text =