| Introduction | ix |
| PART 1 INTRODUCING WEB DATABASE PAGES | 1 |
| CHAPTER 1 Getting Started with Web Databases | 3 |
| Selecting Server-Side Tools 4 ( Upgrading from ASP to ASP.NET 7 . Preparing Your Environment 8 . Creating a Simple Web Database Display 9 . What's Next? 24 . Summary 24 | |
| PART 2 KEY CONCEPTS | 25 |
| CHAPTER 2 Organizing Your Web Environment | 27 |
| Setting Up a Development Environment on Your Own Computer 28 . Installing a Microsoft Web Server 32 . Installing Other Services 37 . Installing the .NET Framework 37 . Configuring Your Web Server 41 . Managing Security for Web Pages in Windows 2000 and Windows XP 55 . Finding a Suitable Web Presence Provider 57 . Summary 58 | |
| CHAPTER 3 Introducing ASP.NET | 59 |
| Understanding the ASP.NET Life Cycle 60 . Coding ASP.NET Elements 64 . Defining Code Declaration Blocks 64 . Defining Code Render Blocks 66 . Understanding the Page Object 67 . Inserting Server-Side Comments 83 . Using Server-Side Includes 84 . Coding Common ASP.NET Directives 85 . Coding Advanced ASP.NET Directives 90 . Summary 104 | |
| CHAPTER 4 Introducing Web Forms | 105 |
| Reviewing Form Fundamentals 105 . Improving the Forms Model with ASP.NET 107 . Creating Web Forms 108 . Coding HTML Server Controls 110 . Coding Web Server Controls 120 . Responding to Web Form Events 125 . Preserving Form Data Between Submissions 137 . Coding Validation Server Controls 139 . Using Web Forms Effectively 147 . Summary 150 | |
| CHAPTER 5 Introducing Visual Basic .NET | 151 |
| Coding Visual Basic .NET Statements 152 . Using Visual Basic Data Types 153 . Using Literals and Constants 157 . Using Operators 160 . Manipulating Dates 167 . Manipulating Strings 173 . Working with Arrays 174 . Using Collections 181 . Accessing Objects 187 . Coding Logic Statements 189 . Writing Loops 192 . Defining Subroutines, Functions, and Classes 193 . Handling Errors 197 . Summary 206 | |
| CHAPTER 6 Understanding Database Concepts and Terms | 207 |
| The Nature of Relational Databases 208 . Implementing a Database Design in Access 2002 218 . SQL Concepts and Syntax 232 . Summary 242 | |
| CHAPTER 7 Accessing Databases with ADO.NET | 243 |
| Introducing ADO.NET 244 . Opening and Closing ADO.NET Connections 247 . Using the Command Objects 250 . Using Data Readers 263 . Using Stored Procedures 266 . Using the DataAdapter, DataSet, and DataTable Objects 269 . Using DataView and DataRelation Objects 282 . Managing Transactions 284 . Summary 286 | |
| PART 3 DEVELOPING APPLICATIONS | 287 |
| CHAPTER 8 Accessing the File System and Graphics | 289 |
| Introducing .NET File Processing Objects 290 . Building a Zero-Maintenance Picture Gallery 294 . Summary 326 | |
| CHAPTER 9 Creating Custom Components | 327 |
| Using Assemblies 328 . Creating User Controls 332 . Creating a Page Banner User Control 337 . Creating a Cascading List User Control 345 . Testing the User Controls 358 . Summary 362 | |
| CHAPTER 10 Running Database Queries | 363 |
| Creating Customized DataGrids 364 . Creating an Interactive Query that Uses a DataGrid 368 . Creating Simple Query Pages 381 . Summary 390 | |
| CHAPTER 11 Identifying Sessions and Visitors | 391 |
| Using the Session and Application Objects 391 . Identifying Visitors 402 . Summary 418 | |
| CHAPTER 12 Updating Databases | 419 |
| Sending E-Mail from a Web Page 419 . Registering a New Visitor 422 . Confirming Self-Registrations 437 . Posting a New Ad 444 . Summary 454 | |
| CHAPTER 13 Handling File Uploads and Pictures | 455 |
| Processing Uploaded Files 455 . Developing a Picture Upload Page 459 . Linking to the Upload Picture Page 476 . Summary 478 | |
| CHAPTER 14 Creating and Consuming Web Services | 479 |
| Understanding Web Services 479 . Implementing a Contoso Classified Web Service 489 . Locating Web Services 503 . Summary 504 | |
| PART 4 TUNING AND DEBUGGING | 505 |
| CHAPTER 15 Tuning and Debugging Applications | 507 |
| Monitoring ASP.NET Application Performance 508 . Achieving Performance Objectives 511 . General Debugging Tips 522 . Debugging with Microsoft CLR Debugger 524 . Summary 528 | |
| INDEX | 529 |
