Page #68 (Chapter 9 - Dealing with Multiple Browsers)

	Chapter 10 - Retrieving and Storing Data in Databases
	Visual Basic Developers Guide to ASP and IIS
	A. Russell Jones

Copyright 1999 SYBEX Inc.

---

	Chapter 10: Retrieving and Storing Data in Databases

	Overview

	An entire book in this set of VB Developer's Guides is devoted to explaining ADO in detail, so you can see that it's a topic too large to cover completely in a single chapter. Nevertheless, you should be able to find enough information here to cover most of your data access needs.

	I'm going to assume that you understand how to move around and create objects (tables, queries, indexes, etc.) in your database of choice. I've written the examples in this chapter so they'll work in both Access and SQL Server.

	The purpose of this chapter is to show you how to use ADO in WebClasses. If you've used ADO from Active Server Pages or other types of Visual Basic projects, you won't find much that's new in this chapter. In other words, there's no syntactical difference between using ADO from ASP or from standard projects in VB and using ADO from WebClasses. But there's a big difference in the way you approach data access from a Web application.

	Those of you who have not used Data Access Objects (DAO) yet should find this a quick and practical introduction. By the end of the chapter, you will be able to retrieve and store data via ADO, use stored procedures, and use DDL and ActiveX Data Object Extensions (ADOX) to create and modify objects in your database.

	I am—reluctantly—going to write most of the code so you can use it from either Access or SQL Server. I will warn you in advance that Access is suitable for developmental and learning purposes only; you should not use it for production-quality applications. If you're using Access 2000, you can use the new Microsoft Data Engine (MSDE) to experiment with stored procedures. For MSDE databases, use the SQL Server examples in this chapter.