|
Web Database Development Step by Step .NET
Learn the latest Web database technologies for the .NET Framework - complete with line-by-line explanations and code samples.
The Microsoft .NET Framework is all about simplifying the exchange of data among applications across the Internet, regardless of operating system or back-end software. The step-by-step lessons in this easy-to-grasp
tutorial detail the major .NET database technologies to demonstrate how to create powerful, flexible Web databases that can serve your needs today and scale for the future. You'll discover the background behind the latest Web database technologies - and see them in action with complete code samples. If you know how to use HTML, know something about databases, and want to integrate the two in the .NET era with Microsoft Visual Basic .NET, this book is for you. Topics covered include:
* Getting started with Web databases
* Organizing your Web environment
* Introducing ASP.NET
* Introducing Web Forms
* Introducing Microsoft Visual Basic .NET
* Understanding database concepts and terms
* Accessing databases with ADO.NET
* Accessing the file system and graphics
* Running database queries
* Identifying visitors and sessions
* Updating databases
* Handling file uploads and pictures
* Creating and using XML Web services
* Tuning and debugging applications
Table of Contents:
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
|
