14.0.0- Advanced Data Handling Techniques

Advanced Data Handling Techniques

This chapter is the final one in our ADO trilogy. It brings together the remaining objects in the ADO object model and demonstrates finally how we can get our information back to our web pages from other sources, such as text files as well as our databases.

In all there are five standalone objects in ADO 2.5, yet we've spent the last two chapters discussing just two of them. That's because the Recordset and Connection objects are at the heart of all we do. However, if we want to do anything more than just ask simple questions of the data store, then we'll need the functionality offered by the other objects in ADO 2.5. We can't hope to do anything more than touch very briefly upon some much larger subject areas and point you in a direction where you'll be able to learn more, but this shouldn't detract from the fact that the subjects we will discuss in this chapter are fundamental to you using databases in web pages.

In this chapter we'll discuss:

• The Command object
• A quick introduction to SQL
• Stored procedures
• The Parameters collection
• Adding and updating your databases using the Recordset object and SQL
• Customized data access
• Semi-structured data and the Record and Stream objects