Kevin Spencer, Thearon Willis, John Kauffman

Beginning ASP Databases (eBook, PDF)

• Format: PDF

Produktbeschreibung

* Offers an entry point to one of the most crucial aspects of Microsoft-oriented Web development--database integration with Active Server Pages

* Covers ADO/OLE DB architecture, SQL, recordsets, databases and cookies, error handling, command object, stored procedures, irregular data handling, performance testing and tuning and more

* Discusses how to incorporate databases into your ASP applications, using ActiveX Data Objects (ADO)

* Provides code examples, exercises, and quizzes - each captioned with step-by-step explanations

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 856
• Erscheinungstermin: 26. August 2003
• Englisch
• ISBN-13: 9781430211211
• Artikelnr.: 44000377

Autorenporträt

Kevin Spencer started programming in C in the early 1990s and wrote a number of shareware programs for DOS, most of which were door programs for BBSs. In the process, he learned to construct relational databases in C, and later worked with Microsoft Visual FoxPro and Access. As Internet database connectivity technologies began to emerge from Microsoft, he learned them as well. He then started his own business, Site Design by TAKempis, which specializes in Internet database application programming with ASP/ADO. Microsoft awarded him with the "Most Valuable Professional" award in 1997. He has written articles about Microsoft FrontPage and ASP/ADO for several online magazines, including ASP Today.

Inhaltsangabe

1: Why Use ASP and ADO to Put Your Database on the Web?.- 2: Setting Up ASP and ADO.- 3: Simple Recordsets - Reading Data.- 4: Basic SQL for ADO Recordsets.- 5: More Uses for Simple Recordsets.- 6: Connections.- 7: Behind the Scenes of ADO.- 8: Recordset Parameters.- 9: RecordSet Methods and Properties.- 10: SQL Statements To Modify Data.- 11: Databases and Cookies.- 12: The Errors Collection.- 13: Command Object.- 14: Stored Procedures and Passing Parameters.- 15: Irregular Data.- 16: ADO Tips and Tricks.- 17: Performance Testing and Performance Improvements.- The Sailors Case Study.- Appendix A: Structure of Sailors.mdb.- and Objective.- Vocabulary and Business Rules.- Where to Download.- Structure and Relationships of Tables.- People Table.- Boats.- BoatClass.- Rank.- Clubs.- Overview of Queries.- Structure of Tables.- Structure of Queries.- Appendix B: Structure of Clothier.mdb.- and Objective.- Vocabulary and Business Rules.- Where to Download.- Structure of Tables and Queries.- Items Table.- Vendors Table.- Table Data.- Appendix C: Profile.mdb Database Schema.- Tables.- profile.- BLOBs.- Stored Queries.- deletetest.- inserttest.- paramselecttest.- selecttest.- updatetest.- Appendix D: Creating a Sailors Database in SQL Server.- Creating the Sailors Database.- Creating the Data Source Name.- Exporting the Tables.- Appendix E: Active Server Pages Object Model.- The Request Object.- The Response Object.- The Application Object.- The Session Object.- The Server Object.- The ObjectContext Object.- Appendix F: Microsoft ActiveX Data Objects 2.0 Library Reference.- Objects.- Command Object.- Connection Object.- Error Object.- Errors Collection.- Field Object.- Fields Collection.- Parameter Object.- Parameters Collection.- Properties.- Property Object.- RecordsetObject.- Method Calls Quick Reference.- Command.- Connection.- Errors.- Field.- Fields.- Parameter.- Parameters.- Properties.- Recordset.- Appendix G: VBScript Reference.- Array Handling.- Assignments.- Constants.- Error constant.- System Color constants.- Comparison constants.- Date and Time constants.- Date Format constants.- Message Box Constants.- String constants.- Tristate constants.- VarType constants.- Control Flow.- Functions.- Conversion Functions.- Date/Time Functions.- Math Functions.- Miscellaneous Functions.- Object Management Functions.- Script Engine Identification.- String Functions.- Variable Testing Functions.- Variable Declarations.- Error Handling.- Input/Output.- MsgBox.- InputBox.- Procedures.- Other Keywords.- Visual Basic Run-time Error Codes.