For a web site to offer its users an experience that improves on that of newspapers or textbooks, it needs a way to change the information it contains dynamically - and that means it needs access to a data source. Through the combination of ASP and ADO, Microsoft provides everything necessary to access, read from, and write to a database, and then allow web users to view and manipulate that data from a web browser. In this book, we'll show you how it's done.

What does this book cover?

Packed with clear explanations and hands-on examples, Beginning ASP Databases contains everything you'll need on your journey to becoming a confident, successful programmer of data-driven web sites. In particular, we'll look at:

• Connecting to common data sources, including SQL Server and MS Access
• Reading data with data reader and dataset objects
• Creating and deleting records, and editing data
• Displaying data with ASP's web server controls
• Writing and using stored procedures from VB code
• Placing your data access code in reusable class libraries

The book closes with a real-world case study that consolidates the tutorials throughout the book into a practical result.

Who is this book for?

To use this book, you need a computer running either Windows 2000 or Windows XP Professional Edition. The examples it contains will not run on Windows XP Home Edition.

This book is for people who have some experience of programming ASP with Visual Basic , are familiar with the operation of the Framework, and want to learn how to use ASP to make data-centric web applications. No prior knowledge of database programming is necessary.