|
Beginning VB.NET Databases
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.
|
