Web Database Development Step by Step .NET Edition

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