- Web Database Development Step by Step .Net Edition
- A Note Regarding Supplemental Files
- Acknowledgments
- Introduction
- 1. Introducing Web Database Pages
- 2. Key Concepts
- 2. Organizing Your Web Environment
- 3. Introducing ASP.NET
- 4. Introducing Web Forms
- 5. Introducing Visual Basic .NET
- Coding Visual Basic .NET Statements
- Using Visual Basic Data Types
- Using Literals and Constants
- Using Operators
- Manipulating Dates
- Manipulating Strings
- Working with Arrays
- Using Collections
- Accessing Objects
- Coding Logic Statements
- Writing Loops
- Defining Subroutines, Functions, and Classes
- Handling Errors
- Summary
- 6. Understanding Database Concepts and Terms
- The Nature of Relational Databases
- Designing a Database
- Informal Database Design
- Identify the major entities in the application
- Create a table for each major entity
- Choose a key for each major entity
- Add entity attributes to each major entity table
- Create additional tables for repeating attributes
- Make sure each field is truly an attribute of the primary key
- Review the relationships among the tables
- Formal Database Design
- Implementing a Database Design in Access 2002
- SQL Concepts and Syntax
- Understanding the SELECT Statement
- Understanding the FROM Clause
- Understanding the WHERE Clause
- Understanding the GROUP BY Clause
- Understanding the HAVING Clause
- Understanding the ORDER BY Clause
- Understanding the DELETE Statement
- Understanding the INSERT Statement
- Understanding the UPDATE Statement
- Summary
- The Nature of Relational Databases
- 7. Accessing Databases with ADO.NET
- 3. Developing Applications
- 8. Accessing the File System and Graphics
- 9. Creating Custom Components
- 10. Running Database Queries
- 11. Identifying Sessions and Visitors
- 12. Updating Databases
- 13. Handling File Uploads and Pictures
- 14. Creating and Consuming Web Services
- 4. Tuning and Debugging
- 15. Tuning and Debugging Applications
- Monitoring ASP.NET Application Performance
- Achieving Performance Objectives
- Tuning Your Program Code
- Tuning ASP.NET Usage
- Be sure to disable debug and trace modes
- Preload the Application object with useful data
- Use Page.IsPostback to avoid unnecessary processing
- Use server controls appropriately
- Save the ViewState only when necessary
- Disable the session state when you aren’t using it
- Choose your session state provider carefully
- Cache data and page output whenever possible
- Avoid unnecessary round trips to the server
- Tuning Database Usage
- General Debugging Tips
- Debugging with Microsoft CLR Debugger
- Summary
- 15. Tuning and Debugging Applications
- Author Biography
- Index
- About the Author
- Copyright
About the Author
Jim Buyens is the senior PC-LAN administrator for AG Communication Systems, a leading provider of telecommunications switching equipment and software. An early champion of TCP/IP applications and connectivity, he architected a coast-to-coast corporate network with over 25 Windows NTxae based servers and 1,000 client PCs. Heu2019s also the Webmaster at www.agcs.com, designing, deploying, and overseeing an intranet with over 14,000 Web pages. He also maintains a Web site featuring support for his books and help in finding Windows NT resources. The URL is http://www.interlacken.com. He is the author of Building Net Sites With Windows NT: An Internet Services Handbook (Addison Wesley, July 1996) and Stupid Web Tricks (Microsoft Press, 1998).
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.