Synopses & Reviews
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
About the Author
Jim Buyens is the senior PC-LAN administrator for AG Communication Systems, a leading provider of telecommunications switching equipment and software. An early champion of TCP/IP applications and connectivity, he architected a coast-to-coast corporate network with over 25 Windows NT based servers and 1,000 client PCs. He’s also the Webmaster at www.agcs.com, designing, deploying, and overseeing an intranet with over 14,000 Web pages. He also maintains a Web site featuring support for his books and help in finding Windows NT resources. The URL is http://www.interlacken.com. He is the author of Building Net Sites With Windows NT: An Internet Services Handbook (Addison Wesley, July 1996) and Stupid Web Tricks (Microsoft Press, 1998).
Table of Contents
Acknowledgments; Introduction; How This Book Is Organized; Microsoft Press Support; Part 1: Introducing Web Database Pages; Chapter 1: Getting Started with Web Databases; Selecting Server-Side Tools; Upgrading from ASP to ASP.NET; Preparing Your Environment; Creating a Simple Web Database Display; Whats Next?; Summary; Part 2: Key Concepts; Chapter 2: Organizing Your Web Environment; Setting Up a Development Environment on Your Own Computer; Installing a Microsoft Web Server; Installing Other Services; Installing the .NET Framework; Configuring Your Web Server; Managing Security for Web Pages in Windows 2000 and Windows XP; Finding a Suitable Web Presence Provider; Summary; Chapter 3: Introducing ASP.NET; Understanding the ASP.NET Life Cycle; Coding ASP.NET Elements; Defining Code Declaration Blocks; Defining Code Render Blocks; Understanding the Page Object; Inserting Server-Side Comments; Using Server-Side Includes; Coding Common ASP.NET Directives; Coding Advanced ASP.NET Directives; Summary; Chapter 4: Introducing Web Forms; Reviewing Form Fundamentals; Improving the Forms Model with ASP.NET; Creating Web Forms; Coding HTML Server Controls; Coding Web Server Controls; Responding to Web Form Events; Preserving Form Data Between Submissions; Coding Validation Server Controls; Using Web Forms Effectively; Summary; Chapter 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; Chapter 6: Understanding Database Concepts and Terms; The Nature of Relational Databases; Implementing a Database Design in Access 2002; SQL Concepts and Syntax; Summary; Chapter 7: Accessing Databases with ADO.NET; Introducing ADO.NET; Opening and Closing ADO.NET Connections; Using the Command Objects; Using Data Readers; Using Stored Procedures; Using the DataAdapter, DataSet, and DataTable Objects; Using DataView and DataRelation Objects; Managing Transactions; Summary; Part 3: Developing Applications; Chapter 8: Accessing the File System and Graphics; Introducing .NET File Processing Objects; Building a Zero-Maintenance Picture Gallery; Summary; Chapter 9: Creating Custom Components; Using Assemblies; Creating User Controls; Creating a Page Banner User Control; Creating a Cascading List User Control; Testing the User Controls; Summary; Chapter 10: Running Database Queries; Creating Customized DataGrids; Creating an Interactive Query that Uses a DataGrid; Creating Simple Query Pages; Summary; Chapter 11: Identifying Sessions and Visitors; Using the Session and Application Objects; Identifying Visitors; Summary; Chapter 12: Updating Databases; Sending E-Mail from a Web Page; Registering a New Visitor; Confirming Self-Registrations; Posting a New Ad; Summary; Chapter 13: Handling File Uploads and Pictures; Processing Uploaded Files; Developing a Picture Upload Page; Linking to the Upload Picture Page; Summary; Chapter 14: Creating and Consuming Web Services; Understanding Web Services; Implementing a Contoso Classified Web Service; Locating Web Services; Summary; Part 4: Tuning and Debugging; Chapter 15: Tuning and Debugging Applications; Monitoring ASP.NET Application Performance; Achieving Performance Objectives; General Debugging Tips; Debugging with Microsoft CLR Debugger; Summary; Appendix : Author Biography; Contacting the Author;