Kevin Spencer, Thearon Willis, John Kauffman

Beginning ASP Databases (eBook, PDF)

• Format: PDF

Produktbeschreibung

This book explains, demonstrated, and applies techniques that lie at the intersection of the two great tools of the Information Age. One tool, the database, is relatively old. The other, the Internet, is quite new. With these two tools together, readers can create powerful Web pages. In this book, readers will learn how to incorporate databases into their ASP applications using ADO, which provides a set of objects through which one can connect to, read from, and write to databases. From installing the necessary software and a basic guide to SQL, to handling stored procedures, readers will get several real-world questions answered with code ready to cut and paste and a chance to practice a t every step of the way.

---

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.