Class notes - last day of class - as requested
2002-03-20 by dangcookie
Class Notes 3-19-02 You need to buy a book on the MS Active X Data Objects. The class book might be ok for you. Granted, everything's in the Help menu except for good examples. Topic - ADO Active X Chan says we can either buy the book assigned for this class, or find a different book that works for you. "ADO.NET and ADO Examples and Best Practices For VB Programmers" William R. Vaughn Chan swears this guy's God. "ADO 2.0 Reference" book (Amazon - $30) I'm not sure if this is the exact title. ADO 2.6 Programmer's Reference David Sussman the one for this class Apress good tech book company. Probably have to buy online. Book must cover these topics well: Connection Object Record Set Object Command object cool in advanced ADO programming. Sometimes we'll want to call stored procedures on a SQL database, to which we'll want to pass parameters. Parameters collection of the Command Object Action Queries with ADO Insert, Update, Delete, retrieval String SQL a bit on the SQL language and construct long strings and pass them. We're going to have Access select certain fields from certain records and retrieve them. We'll create a grid control and populate it with data. GetRows methods of a __ object. He's going to want us to get a record set. Different types of record sets. Some records let you go back and forth, others don't. Optimistic and Pessimistic locking. "State" property is the recordset open or closed? We're going to start off with where we left off. Check out Homework 4 because it will be the first homework. Property procedures Sharing data between forms. We don't want to have to input the same data twice. We'll use Property procedures. ADO library 2.6 check that you have it. MDAC.EXE download it from MS to install 2.6 if you don't have it. DON'T get 2.7 (.NET)! Check References window. o ADO.NET is the same as always. Once you've learned 2.6, you'll have no problem switching over. Recordset Object, Command Object look them up in the Object Browser. Learn SQL! Joining is the hard part. Selecting is easy. Advanced queries GroupBy queries in Access.