Book description
Discover what’s behind the latest Web database technologies and how to create flexible Web databases that can serve your needs today and scale for the future with the step-by-step lessons and complete code samples in this easy-to-grasp tutorial.
Table of contents
- 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
Product information
- Title: Web Database Development Step by Step .NET Edition, Second Edition
- Author(s):
- Release date: April 2002
- Publisher(s): Microsoft Press
- ISBN: 9780735616370
You might also like
book
Build Your Own ASP.NET 4 Web Site Using C# & VB, 4th Edition
Build Your Own ASP.NET 4 Web Site Using C# & VB is aimed at beginner ASP.NET …
book
Microsoft® SQL Server™ 2005: Database Essentials Step by Step
SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers enhanced scalability, availability, …
book
ASP.NET 2.0 Illustrated
“This book is a phenomenal start for someone new to ASP.NET, as well as a complete …
book
ASP.NET 2.0 Website Programming Problem - Design - Solution
ASP.NET 2.0 Programming: Problem Design Solution is aimed at describing, designing, and implementing a site much …