Author(s): Thearon Willis
Year: Nov 2005
File type: PDF
Size (for download): 8.6 MB
This book teaches Visual Basic 2005 developers the concepts and skills necessary to write VB 2005 database applications that can be used throughout their enterprises. Although the book touches on database design concepts, its focus is on using ADO.NET to access and manipulate data in relational databases. This book covers all data providers in ADO.NET briefly, but focuses on using the OleDb Data Provider for accessing Access databases, the SQLData Provider for accessing SQLServer databases, and the Oracle Data Provider for accessing Oracle databases. Most of the examples in this book involve writing database applications for SQLServer and Oracle.
This book was designed for the developer who wants to learn how to write database applications using Visual Basic 2005 and back-end databases such as Microsoft Access, Microsoft SQLServer, and Oracle.
You will learn how to use queries, views, and stored procedures to efficiently access and manipulate data from your applications. I provide examples and instruction on accessing data from Windows applications, ASP.NET applications, and Web Services. You’ll also be exposed to more advanced concepts, such as writing business logic components and data access components, as well as how to read and write data from the Windows Registry. You will also learn how to encrypt and decrypt data using the .NET encryption classes and how to hash passwords to further secure your access to your data.
TABLE OF CONTENT:
Chapter 01 – Databases
Chapter 02 – An Introduction to ADO.NET
Chapter 03 – Visual Studio 2005 Data Wizards
Chapter 04 – Basic SQL
Chapter 05 – SQL and Queries for Access
Chapter 06 – Selecting Data in Access
Chapter 07 – Inserting,Updating,and Deleting Data in Access
Chapter 08 – Migrating Data from Access
Chapter 09 – 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