Beginning Visual Basic 2005 Databases (Programmer to Programmer)

Having just read "Beginning Visual Basic 2005" from the same publisher and author (which I feel was a decent book to get started using VB), I moved onto this title and was very disappointed with it. The book forces you to begin your database programming using MS ACCESS, which I had no interest in doing. So, just skip those chapters right? Wrong. It really does force you down this path due to later projects in the book relying on you completing the earlier chapters. I even tried cheating by just downloading the code from the Access chapters so I could just jump into the SQL server sections. While this allowed me to continue, the book continues to make references to things I should have learned in the first 4 chapters. While, I understand the reasoning for trying to cover many different Database platforms, having Access, SQL Server, and Oracle all in the same book just leads to confusion and frustration. The "Do this for SQL server, Or do this for Oracle" examples were just a pain.

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.

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. A companion volume to Beginning Visual Basic 2005 offers a comprehensive overview of the fundamentals of database concepts and data manipulation, explains how to design and implement a variety of database applications, and describes how to access data from Windows applications, ASP.NET applications, and XML Web Services. Original. (Intermediate)