Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days

Summary

Today's lesson introduced you to the ActiveX Data Objects. After discussing and creating DSNs, you looked at the Recordset, Connection, and Command object. You saw how these can be used together or separately and when you might use each of these. You also looked at calling stored procedures. To do this you use the Command object, adding the necessary parameters and then calling the Execute method. Values may also be returned from here. Calling stored procedures like this will be integrated into our banking online application. For more information on ADO, see http://msdn.microsoft.com or http://www.microsoft.com/data.