- 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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.