Page 319 - DCAP408_WEB_PROGRAMMING

Unit 14: Database Connectivity

where he may edit the title, URL, or description of the specified record. Create a third page Notes
to actually save the changes to the database.
6. The connection is closed when the session ends. Explain

7. The global.asa has four events - Application-Start, Session-Start, Application-End and
Session-End. Comment
8. Once you have designed you database the next step will be to create a DSN less entry,
UserDB1. Explain with a suitable program
9. ADO.NET simplifies the data reading infrastructure by applying the old “divide et impera”
motto. Discuss
10. Explain why Data driven sites must be capable of editing as well as addition and deletion
of data?

Answers: Self Assessment

Fill in the blanks:

1. Microsoft Access Drive 2. address
3. post-startup 4. DSN-less connection
5. DSN 6. DBQ parameter

7. Physical 8. Recordset
9. DataSet 10. cursor type
11. DBCommand 12. Records
13. Array 14. Remote Data control
15. Visual Basic

14.8 Further Readings

Books A Keyton Weissinger, ASP in a Nutshell, 2nd Edition [ILLUSTRATED]
(Paperback), O’Reilly Media; 2 edition (January 1, 2000)
Bob Reselman, Active Server Pages 3.0 by Example, Que Publishing

David Buser, Chris Ullman, Brian Francis, Dave Sussman, Beginning Active
Server Pages 3.0, John Wiley & Sons
John W. Gosney, ASP Programming for the Absolute Beginner (For the Absolute
Beginner) (Paperback), Course Technology PTR; 1 edition (July 15, 2002)
Keith Morneau, Jill Batistick, Active server pages, Course Technology
Scott Mitchell, Designing Active Server pages, O’Reilly Media

Online links http://www.takempis.com/adointro.asp
http://en.wikipedia.org/wiki/ActiveX_Data_Objects

LOVELY PROFESSIONAL UNIVERSITY 313