ASP.NET 2.0 与数据库指南 Beginning ASP.NET 2.0 and Databases

分类: 图书,进口原版书,计算机 Computers & Internet ,
作者: John Kauffman,Bradley Millington 著
出 版 社: 吉林长白山
出版时间: 2006-12-1字数:版次: 1页数: 535印刷时间: 2006/12/01开本:印次:纸张: 胶版纸I S B N : 9780471781349包装: 平装内容简介
ASP.NET is Microsoft's popular technology for creating dynamic web sites that pull unique information for each visitor rather than showing everyone the same static HTML pages. The introduction of the exciting 2.0 version allows for a far easier relationship between data and ASP.NET than ever before. In this book, bestselling author John Kauffman and Microsoft ASP.NET data insider Bradley Millington guide you through the most important uses of ASP.NET—working with databases in your ASP.NET web sites.
As you progress from simple to more complex topics, you'll be introduced to the many additional ASP.NET and data connectivity tools that Microsoft's Web Platform and Tools team has released. Kauffman and Millington take you beyond the basics to discuss the permutations, pitfalls, and best practices that occur in real business scenarios.
作者简介:
John Kaufman (Ogdensburg NY) is a trainer and writer working in Asia and North America specializing in connecting databases to the web. While teaching he keeps a list of student questions and mistakes and uses that information as the basis for future material in books. John authored best-seller Beginning ASP Databases and coauthored several other best-sellers including Beginning Active Server Pages 3. Bradley Millington (Redmond, WA) is a Microsoft Program Manager for the Web Platform and Tools Team with primary responsibility for the database controls in ASP.NET. He is a well-known frequent speaker at Microsoft technical conferences including TechEd and PDC.
目录
Introduction.
Chapter 1: Introduction to ASP.NET 2.0 and ADO.NET.
Overview of the .NET Technologies.
Introduction to the .NET Framework.
Introduction to ASP.NET.
Introduction to ASP.NET 2.0.
Introduction to ADO.NET.
Review of ASP.NET 1.x and ADO.NET for Data Access.
ASP.NET 2.0 and Data Access.
Review of Terminology.
Requirements for Using ASP.NET 2.0.
A Web Server.
The .NET Framework Version 2.0.
An Editor to Create Web Pages.
A Database Management System.
Setup for This Book.
Install Visual Web Developer Express, SSE, and the ASP.NET Development Server.
Download This Book’s Files.
Create the Practice Web Site.
Install the Sample Databases.
Demonstrations.
Common Mistakes.
Summary.
Exercises.
Chapter 2: Connecting to an Access Database.
Introduction to Microsoft Access and the JET Database Engine.
Pros and Cons of Using Access in Web Applications.
Connecting to a Microsoft Access Database in Visual Web Developer.
Using an AccessDataSource Control.
Variations in Select Statements.
Variations in MDB File Location.
Managing MDB File Permissions.
Handling Access Connection Failures Gracefully.
Common Mistakes.
Summary.
Exercises.
Chapter 3: Connecting to SQL Server and SQL Server Express.
Introduction to SQL Server and Connection Strings.
Preparing to Use a SQL Server Database.
Specifying Connection Strings.
Using the SqlDataSource Control.
Understanding Security in SQL Server.
Authentication Options in SQL Server.
Authentication with SQL Server Express.
Database Rights with SQL Server Express.
Authentication Requirements for the SqlDataSource Control.
Storing the Connection String in the web.config File.
Manually Adding a Connection String to the web.config File.
Encrypting Connection Strings.
Choosing between DataSet and DataReader.
Discovering the Schema of an Unfamiliar Database.
Handling Failures with SqlDataSource.
Common Mistakes.
Summary.
Exercises.
Chapter 4: Connecting to Other Relational Databases.
Introduction to Connections with Providers.
Understanding the Relationship between Layers of Connectivity Software.
Understanding Supported ADO.NET Providers.
Using ADO.NET Providers in ASP.NET 2.0.
Connecting to an Access MDB File When a Password Is Used.
Connecting to Oracle Database.
Connecting to MySQL.
Syntax for an ODBC Connection to MySQL.
Connecting to Excel.
Connecting to Other Databases.
Exploring Common Mistakes.
Summary.
Exercises.
Chapter 5: Displaying Data in Tables.
Chapter 6: Customizing the Appearance of Tables.
Chapter 7: Sorting and Paging Data.
Chapter 8: Displaying Data in Selection Lists.
Chapter 9: Filtering and Master—Details Scenarios.
Chapter 10: Displaying Data in Templated Controls and Data Binding.
Chapter 11: Updating and Deleting Data.
Chapter 12: Inserting New Records.
Chapter 13: Validation.
Chapter 14: Business Objects As a Source of Data.
Chapter 15: XML and Other Hierarchical Data.
Chapter 16: Caching Data.
Chapter 17: Handling Events for Data Controls.
Chapter 18: Performance Checklist.
Chapter 19: Case Study: FAQ System.
Appendix A: A Short and Practical Introduction to SQL Statements.
Appendix B: Exercise Answers.
Index.